Data & Statistical Reporting Analyst

This is a fully remote position, open to applicants in Connecticut, +9 more states.

📋 Description

• Gather, analyze, and interpret data, information, and statistics.

• Compile statistical or numerical figures and prepare reports for company management.

• Identify patterns and trends in data.

• Prepare, reconcile, and submit statistical data files to external agencies and regulators, including ISO, AAIS, and CAR.

• Submit regulatory data calls.

• Monitor bureau rejections and collaborate with internal stakeholders to coordinate corrective actions.

• Assist in projects related to data quality, compliance, and system enhancements.

• Support or conduct testing of system changes or migrations that affect reporting and data, including user acceptance testing and data flow validation.

• Keep abreast of regulatory reporting changes and help ensure organizational compliance.

• Gather, clean, and analyze both structured and unstructured data from various sources.

• Develop and maintain source-to-target mapping documentation across data warehouse layers, feeds, reports, and source systems.

• Create, execute, and modify complex SQL queries for the analysis of tables, loads, cubes, reports, and feeds.

• Collaborate with developers, testers, EPMO, and business stakeholders to document and deliver data requirements.

• Draft data-level business requirements, including intricate calculations.

• Create and maintain data dictionaries.

⛳️ Requirements

• Bachelor’s degree in computer science, Information Technology, or a related field, or an equivalent combination of education and experience.

• A minimum of 3 years of experience in project management, data analysis, or a related field.

• Experience in the insurance industry is essential.

• Proficient in SQL for database querying.

• Familiarity with Microsoft Excel, including pivot tables and VLOOKUP.

• Strong understanding of Property & Casualty insurance coverage types and policy structures, including personal and commercial lines is preferred.

• Excellent data exploration and analytical skills.

• Capability to profile datasets and identify patterns, anomalies, and relationships.

• Ability to break down business questions into structured analytical tasks.

• Working knowledge of P&C insurance functions such as underwriting, claims, billing, operations, actuary, sales, and finance.

• Understanding of insurance metrics including exposures, written premium, earned premium, losses, and reserves.

• Experience working in Agile teams and familiarity with sprint planning, standups, refinements, and retrospectives.

• Ability to write and enhance user stories with clear acceptance criteria.

• Experience using Agile tools such as Azure DevOps or Jira.

• Strong analytical and problem-solving skills with a keen attention to detail.

• Ability to convey complex technical concepts to non-technical stakeholders.

• Strong documentation and data storytelling abilities.

• Ability to work both independently and collaboratively in a fast-paced, dynamic Agile environment.

• Excellent organizational skills for managing workload to meet reporting deadlines.

🏝️ Benefits

• Short-term disability, long-term disability, and life insurance coverage at no cost.

• Optional enhanced life insurance and critical illness plans.

• 401k plan with employer contribution regardless of employee contribution.

• Cash-balance pension plan.

• Student Loan Repayment Assistance.

• Short-term incentive plan for all employees.

• 25 days of paid time off upon hire, prorated for the first year.

• 7 days of paid sick leave.

• 10 paid company holidays.

• Personalized paid time off after 3 years.

• Access to 26 BetterHelp therapist sessions each year for employees and up to 5 dependents.

• Access to BetterHelp group and digital resources.

• Access to Family First caregiving assistance.

• Medical, dental, and vision coverage starting from the first day of employment.

• Health Savings Accounts with employer contribution.

• Opportunities for professional development.

• Engaging and challenging careers.

• Competitive compensation.