Data & Statistical Reporting Analyst

Preferred Mutual Insurance Company

. Collect, analyze, and interpret data, information, and statistics .

Posted 10/30/2026full-timeRemote • United StatesMid-LevelSenior💰 $72,500 - $100,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Proficient in data analysis and statistical reporting, with strong expertise in SQL and Microsoft Excel. Demonstrates a solid understanding of Property & Casualty insurance metrics and functions, ensuring compliance and effective communication with stakeholders.

Highest-signal resume keywords

SQL ProficiencyData AnalysisInsurance Industry ExperienceAgile MethodologiesRegulatory Compliance

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalysisSQLStatistical ReportingData CleaningData MappingComplex CalculationsData ProfilingUser Acceptance TestingData Dictionary CreationData Quality Monitoring

Soft Skills

Analytical SkillsProblem-Solving SkillsAttention to DetailCommunication SkillsCollaboration Skills

Tools & Technologies

Microsoft ExcelAzure DevOpsJira

Industry Keywords

Property & Casualty InsuranceRegulatory ReportingISOAAISCARUnderwritingClaimsBillingActuaryFinance

Tech Stack

Tools & technologies

AzureSQL

About the role

Key responsibilities & impact

Collect, analyze, and interpret data, information, and statistics
Collect statistical or numerical figures and compile reports for company management
Identify trends in data
Prepare, reconcile, and submit statistical data files to external bureaus and regulators, including ISO, AAIS, and CAR
Prepare regulatory data call submissions
Monitor bureau rejections and coordinate corrective actions with internal stakeholders
Support projects related to data quality, compliance, and system upgrades
Support or perform testing of system changes or migrations affecting reporting and data, including user acceptance testing and data-flow validation
Monitor regulatory reporting developments and help maintain organizational compliance
Collect, clean, and analyze structured and unstructured data from multiple sources
Create and maintain source-to-target mapping documents across data warehouse layers, feeds, reports, and source systems
Create, run, and modify complex SQL queries for analysis of tables, loads, cubes, reports, and feeds
Collaborate with developers, testers, EPMO, and business stakeholders to document and deliver data requirements
Write data-level business requirements, including complex calculations
Create and maintain data dictionaries

Requirements

What you’ll need

Bachelor’s degree in computer science, Information Technology or a related field OR equivalent combination of education and experience
3+ years of experience in project management, data analysis, or a related field
Insurance industry experience required
Proficiency in SQL for database querying
Knowledge of Microsoft Excel, including pivot tables and VLOOKUP
Strong understanding of Property & Casualty insurance coverage types and policy structures, including personal and commercial lines preferred
Strong data exploration and analytical skills
Ability to profile datasets and identify patterns, anomalies, and relationships
Ability to decompose business questions into structured analytical tasks
Working knowledge of P&C insurance functions including 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 with sprint planning, standups, refinements, and retrospectives
Ability to write and refine user stories with clear acceptance criteria
Experience using Agile tools such as Azure DevOps or Jira
Strong analytical and problem-solving skills with high attention to detail
Ability to communicate complex technical concepts to non-technical stakeholders
Strong documentation and data storytelling skills
Ability to work independently and collaboratively in a fast-paced, dynamic Agile environment
Ability to organize workload for timely reporting requirements

Benefits

Comp & perks

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 at 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 beginning the first day of employment
Health Savings Accounts with employer contribution
Professional development
Challenging careers
Competitive compensation