Note: The job is a remote job and is open to candidates in USA. TopDog Law is a rapidly growing personal injury firm that combines innovative technology and data-driven decision-making. The Analyst, Underwriting Analytics will play a crucial role in forecasting case values and modeling outcomes, directly influencing operational and marketing strategies.
Responsibilities
- Write and optimize SQL queries to support case valuation modeling, reporting automation, and underwriting analysis
- Leverage SQL, Excel/PowerPivot, Python, AI and other analytics tools to build and maintain reliable, scalable reporting
- Apply structured problem-solving to well-defined and moderately ambiguous underwriting and case valuation questions
- Stay informed on emerging analytics and AI capabilities that can enhance underwriting analytics practices
- Build and maintain dashboards and reports that provide clarity to underwriting and operational leaders
- Serve as an analytical resource supporting case valuation forecasting (CVFO) and related modeling across case types and segments
- Support the definition and upkeep of KPIs used to monitor underwriting accuracy and case portfolio performance
- Analyze case outcomes, conversion rates, and portfolio performance against underwriting assumptions
- Help identify discrepancies, trends, and anomalies across case types, states, and lead segments
- Translate data findings into clear summaries and recommendations for the Underwriting Analytics Team
- Support forecasting and reconciliation work tied to case volume, vintage performance, and portfolio composition
- Contribute ideas to improve existing models, queries, and processes—not just maintain them as-is
Skills
- Strong analytical and problem-solving mindset with attention to detail
- 1-3 years of experience in business analytics, data operations, or a related quantitative field
- Solid SQL skills with the ability to write and troubleshoot moderately complex queries against large datasets
- Proficiency with Excel, including PowerPivot/DAX
- Ability to manage multiple priorities and meet deadlines in a fast-paced environment
- Clear communication skills with the ability to present findings to both technical and non-technical audiences
- High commitment to data integrity and accuracy
- Thrives in a fast-paced, performance-driven, high-growth environment
- Intellectual curiosity and an ownership mindset
- Ability to take direction, prioritize effectively, and execute with speed
- Exposure to Python or R is a plus
Benefits
- Eligible for performance-based bonus
- Benefits include: Medical, dental, and vision insurance
- 401(k) with company match
- HSA
- Life insurance
- Disability coverage
- Paid time off
- Parental leave
- Our job postings reflect the compensation range for the specific market and location of each role. Ranges vary by geography based on local market rates and cost of labor.
Company Overview