Returning Candidate?

Reporting Analyst

Reporting Analyst

US-CA-San Francisco
Job ID 

More information about this job


Esurance is hiring a Reporting Analyst to join the Actuarial Reserving team in our San Francisco, CA office. As a Reporting Analyst you will gather data and create reports for the company's regulatory compliance reporting needs. Additionally, you will collect data from a variety of departments and sources while organizing, analyzing, and reviewing the data and reports to ensure they meet the needs of different regulatory agencies.


  • Supports the company’s compliance reporting of premium, exposures, and claims data; presents and communicates report findings to various levels of leadership.
  • Assists in implementing required policy reporting to various departments of motor vehicles.
  • Gathers data and develops reports for major statistical data calls received from various insurance departments and rating bureaus; implements and maintains the reporting of policy data to various Departments of Motor Vechicles (DMVs)
  • Applies business knowledge to analyze data, develop reports and solve problems.
  • Communicates on a daily basis with various internal departments and external regulatory agencies; communicates across mutiple departments within the company to research and collect data; interacts with various state insurance departments for the purposes of submitting data and answering questions about previous submissions.
  • Researches and resolves moderately complex data or reporting issues that arise between the DMV and customer service department; facilitates communications between the parties involved.
  • Identifies, gathers and performs data manipulation with relevant and quality data sources; develops and recommends innovative approaches to address business problems, solution and strategy.
  • Develops and interprets business functional requirements to translate all needs into a final reporting product;
  • Writes moderately complex Business Requirement Documentation (BRDs) and maintains documentation detailing the business requirements and functionality needed in reporting tools.
  • Defines business problems, identifies data requirements, isolates data elements and collaborate with IT to facilitate implementation of technical data solutions. Measures effectiveness and impact of change to reporting requirements.
  • Assists in developing new approaches to address business problems and solutions.


  • Excellent communication skills both verbal and written with strong analytical, research and problem-solving skills; able to explain complex concepts in a clear and concise manner.
  • Working business technical and data knowledge. Understands the company data systems for premiums and claims.
  • Able to negotiate with and persuade others; able to use diplomacy and tact when needed.
  • Organized and detail-oriented, able to work well in a changing environment and perform multiple tasks effectively and concurrently.
  • Able to work effectively under deadlines both independently, and within a collaborative team oriented environment using sound judgment in decision-making.
  • Knowledge of Microsoft Office products including intermediate to advanced proficiency with Excel (Pivot Tables, Vlookups, and Macros) is required.
  • Intermediate knowledge and understanding of SQL query and Oracle query language, and knowledge of SQL and Oracle Developer


Experience / Education:

  • Bachelor’s degree in Business, a related field or equivalent education required.
  • 3 or more years of related work experience preferred

Connect With Us!

Not ready to apply quite yet? Connect with us to get job updates based on your interests.