Statistical Reporting Analyst

Responsibilities

• Develop methods and procedures to report quality data timely and efficiently (utilizing best practices of data management).
• Work closely with the Product teams to analyze and research new regulatory reporting requirements, including existing and new states, using the project life cycle.
• Provide business support to the Finance and Accounting team.
• Assist with the design of logical reporting data models based upon business requirements and help to define data access parameters.
• Work 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/or Excel applications.
• Review data as a means of providing insight into existing data issues and supporting the decisions that need to be made around data remediation, including the development of data cleansing and standardization rules.
• Aid in the design and maintenance of SQL scripts and packages using SSIS.
• Create and maintain SQL scripts and packages using SSIS.
• Build and test complex SQL queries and stored procedures.
• Perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples).
• Support ETL processing for transforming and loading data into the data warehouse.
• Develop reports to help conduct data analysis and validation.
• Understand the various levels of reporting detail required for statistical and statutory reporting.
• Escalate issues as required for data quality, technology, data mapping issues, and other issues that may arise.
• Support and/or assist in the QA & UAT when required.

Qualifications

• Bachelor's degree in 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, correct the mismatched data.
• Experience building appropriate data models and designing tables to effectively support large data volumes.
• Demonstrate 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.
• 4+ years of advanced knowledge of T-SQL and/or ANSI SQL, ETL and Data Warehousing.
• Experience in building and testing complex technical solutions and scripts using SSIS SQL Server.
• Experience in building and testing complex technical solutions and scripts using SSIS SQL Server.
• Experience in gathering and analyzing business requirements.
• Experience in performing detailed data analysis (i.e. 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 in 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, root cause analysis skills and ability to solve difficult problems.
• Experience Complete on time with accuracy: Scheduled processing of premium and loss data to meet requirements of statistical and statutory reporting.
• Schedule external reporting processes.
• Understand the various levels of reporting detail required for statistical and statutory reporting.
• Escalate issues as required for data quality, technology, data mapping issues, and other issues that may arise.
• Support and/or assist in the QA & UAT when required.