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. This position will develop methods and procedures to report quality data timely and efficiently (utilizing best practices of data management.) This role will work closely with the 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. This individual will 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.
Additionally, the Analyst will 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. The Analyst will assist with the design of logical reporting data models based upon business requirements and will help to define data access parameters.
Minimum Qualification
- 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+ experience 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+ experience of advanced knowledge of T-SQL and/or ANSI SQL, ETL and Data Warehousing Create and maintain SQL scripts and packages using SSIS.
- Database/ETL developer responsible for building relational and data warehousing applications, unit test, document the ETL process.
- Proficiency in the development of complex technical solutions and scripts using SSIS SQL Server.
- Developing data links and data loading scripts, including data transformations, reconciliations, and accuracies.
- Have a participated in all phases of Software Development Lifecycle (SDLC).
- Support ETL processing for transforming and loading data into the data warehouse.
- Experience in building and testing complex SQL queries and stored procedures.
- Experience in gathering and analyzing business requirements.
- Ability to perform 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.
- Ad-hoc requests for data, including audit requests.
- Production Support
- New Development (intermediate).
- Enhancements.
- Performs all other duties, at the discretion of management, as assigned.
Responsibilities
- Interview customers to determine requirements for data, reports, analyses, metadata, training, service levels and performance.
- Document business requirements for development changes necessary to correct data issues or as requested by the Business as they relate to statutory or statistical reporting.
- Work with stakeholders according to the schedule agreed to resolve data issues.
- Coordinate and communicate between Business and IT Development Team.
- Identify, analyze, and remediate data issues related to the operational processing of the monthly, quarterly and annual statutory/statistical reporting solutions and work with stakeholders according to the schedule agreed to resolve these issues.
- Maintain system protocols by writing and updating procedures.
- Interact with and guide the Developers toward the solution detailed in the specifications.
- Perform analysis while considering the business implications of the solution to the current and future states.
- Plan and execute tests to verify that the reporting solutions support the specifications and requirements provided by the Business and are in accordance with business objectives.
- Provide training on reporting solutions, where applicable, to business users with respect to project materials, delivery methods, and timeframes.
- Provide support for defining models, data transformation and validation rules within the reporting solution.
- 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.
- Participate in the change control process to determine system impact on statutory and statistical reporting process.
- Support and/or assist in the QA & UAT when required.
The above-cited duties and responsibilities describe the general nature and level of work performed by people assigned to the job. They are not intended to be an exhaustive list of all the duties and responsibilities that an incumbent may be expected or asked to perform.
Other Qualities
- Strong written and verbal communication skills, tailored to diverse stakeholders.
- Ability to handle aggressive schedules, multiple tasks, tight deadlines.
- Strong Analytical ability and problem-solving skills.
- Ability to perform multiple assignments.
- Ability to understand and apply applicable rules, regulations, and requirements relating to reporting data.
Additional Information
Fortegra is not accepting unsolicited resumes from search firms for this position.
Applicants must be authorized to work for any employer in the United States. We are unable to sponsor or assume sponsorship of employment visas at this time. We welcome applicants of all backgrounds and national origins.
Recruitment Updates
Fortegra has recently been made aware of unauthorized communications regarding career opportunities by individuals not associated with Fortegra or our recruitment team. Fortegra will only contact you from the Fortegra domain address (@fortegra.com). If you receive a message from someone posing as a Fortegra recruiter via text message, WhatsApp, Telegram or other messaging platform, please report it as phishing and block the sender.
Internal Notice: As part of our commitment to talent development, this position is open for internal promotion applications at the time of public posting.
#LI-Onsite
Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights (https://www.eeoc.gov/poster) notice from the Department of Labor.
