Statistical Reporting Analyst

The Statistical Reporting Analyst is responsible for reporting financial and statistical data to insurance bureaus, state insurance departments, and other organizations for all lines of insurance. The role will develop methods and procedures to report quality data timely and efficiently, utilizing best practices of data management. The analyst works closely with Product teams to analyze and research new regulatory reporting requirements, including existing and new states, using the project life cycle.

The successful candidate may also provide business support to the Finance and Accounting team. The analyst is responsible for analysis, design, testing, maintenance, and support of statistical reporting solutions, working with internal business representatives, external customers, and IT development staff to analyze requirements and develop solutions using Microsoft SQL Server Management Studio, Toad Data Point, and Excel applications.

Additionally, the analyst reviews data to provide insight into existing data issues and supports the decisions that need to be made around data remediation, including the development of data cleansing and standardization rules. The analyst assists with the design of logical reporting data models based upon business requirements and helps define data access parameters.

• Bachelor’s degree in a relevant area of study or equivalent work experience.
• 1–3 years of technical experience in financial report delivery for P&C insurance carriers.
• 1–3 years of Statistical Reporting experience for P&C insurance carriers.
• 4+ years of advanced knowledge of T‑SQL and/or ANSI SQL, ETL and Data Warehousing.
• Ability to create complex scripts to identify and address data quality issues and correct mismatched data.
• Experience building appropriate data models and designing tables to effectively support large data volumes.
• Demonstrated ability to pull together a well‑designed, end‑to‑end process with knowledge of the MS‑SQL product‑stack.
• Ability to troubleshoot and tune database configurations, ETL processes, and SQL code for optimal performance.
• Experience with warehousing best practices and methodologies.
• Experience creating and maintaining SQL scripts and packages using SSIS.
• Database/ETL developer responsible for building relational and data warehousing applications, unit testing, and documenting the ETL process.
• Proficiency in developing complex technical solutions and scripts using SSIS and SQL Server.
• Developing data links and data loading scripts, including data transformations, reconciliations, and ensuring accuracies.
• Participation in all phases of the Software Development Lifecycle (SDLC).
• Support for ETL processing to transform and load data into the data warehouse.
• Experience building and testing complex SQL queries and stored procedures.
• Experience gathering and analyzing business requirements.
• Ability to perform detailed data analysis to determine the structure, content, and quality of the data through examination of source systems and data samples.
• Proficiency with MS Office Suite, SQL Server Management Studio, Toad Data Point, and related BI tools.
• Finance process and data analysis experience with strong understanding of relationships and operational dependencies in a typical finance department.
• Expertise in:
  • Delivering solutions using established database technologies such as SQL.
  • Server.
  • Developing strategies and tactics, and determining the correct prioritization of work items to ensure the best business outcome.
• Understanding of insurance financial operations, processes, and insurance data structures.
• Knowledge of statutory reporting requirements for P&C lines of business.
• Strong techno/functional experience delivering reporting solutions to finance teams.
• Proven analytics and root‑cause analysis skills and ability to solve difficult problems.

• Complete on time with accuracy:
  • Scheduled processing of premium and loss data to meet requirements of statistical and statutory reporting.
  • Schedule external reporting processes.
  • Ad‑hoc requests for data, including audit requests.
• Production Support:
  • New Development (intermediate).
  • Enhancements.
  • Perform all other duties, at the…