Data & Statistical Reporting Analyst
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Data analyst collecting, analyzing, and reporting Property & Casualty insurance statistics for Preferred Mutual. Managing regulatory submissions, SQL analysis, data quality, and compliance.
Responsibilities:
- 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:
- 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:
- 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
Similar Jobs
Senior Business Insights Analyst
Senior Business Insights Analyst improving billing, subscription, and revenue decisions at Philo, a streaming TV service. Building trusted metrics and executive-ready insights across growth, retention, content, and product.
Data and Systems Reporting Analyst
Remote Data & Systems Reporting Analyst building data systems and reports for Empower Community Care’s behavioral health, child welfare, and community care programs. Ensuring accurate reporting, quality monitoring, and stakeholder insights.
Business Intelligence Lead
Business Intelligence Lead transforming CRM, telephony, and workforce data into actionable intelligence for Humana’s VA Contact Center. Driving reporting, systems integration, automation, and operational strategy.
Reporting Analyst, Consumer Services
Reporting Analyst building automated marketing reports for Power Digital, an AI-native growth firm. Transforming campaign data into client-ready insights and optimization recommendations.
Reporting Analyst, Consumer Services
Reporting Analyst building automated marketing reports and visualizations for Power Digital’s clients. Analyzing campaign data to deliver actionable insights and optimization recommendations.
Reporting Analyst, Consumer Services
Reporting Analyst analyzing digital marketing data for Power Digital, an AI-native growth firm. Building automated reports, visualizations, and actionable client performance insights.
Reporting Analyst, Consumer Services
Reporting Analyst building automated marketing reports and performance insights for Power Digital, an AI-native growth firm. Translating campaign data into client recommendations across digital channels.
Contract Trainer – Controlling, Business Intelligence, Power BI, AI Tools
Teilzeit-Honorartrainer:in bei WBS Training für Controlling und Business Intelligence. Vermittlung von Power BI, KI-Tools und praxisnahen Lerninhalten im Homeoffice.
Contract Trainer – Controlling, Business Intelligence, Power BI, AI Tools
Teilzeit-Honorartrainer:in bei WBS TRAINING für Controlling- und Business-Intelligence-Kurse. Begleitung von Lernenden mit Power BI, KI-Tools und Flipped-Classroom-Didaktik.
Statistical Reporting Analyst
Statistical Reporting Analyst managing P&C insurance statistical submissions for U.S. carriers and MGAs. Validating, reconciling, and resolving bureau reporting data issues across jurisdictions.
Business Intelligence Analyst
Business Intelligence Analyst creating client-facing analyses and reusable data products for Doximity’s clinician platform. Applying SQL, Python, and healthcare datasets to identify medical-professional behavior patterns.
Business Intelligence, Data Analyst
Business Intelligence/Data Analyst analyzing large-scale transactional, operational, and customer data at Binance, a global blockchain ecosystem. Building visualizations, machine learning models, and executive recommendations.
Senior Financial Reporting Analyst, Maritime Administration
Senior analyst preparing MARAD quarterly and annual financial reporting packages. Supporting a consulting firm’s federal government CFO services with Delphi, GTAS and USSGL controls.
Business Analytics Specialist
Business Analyst aligning Pearson’s data initiatives with business needs and delivery outcomes. Translating stakeholder requirements into Agile processes, documentation, and user stories.
Business Intelligence Analyst
Business Intelligence Analyst transforming healthcare data into actionable insights for Pinnacle Treatment Centers’ addiction treatment services. Developing dashboards, reports, and visualizations for strategic healthcare decisions.
Mid-Level Data Analyst – Business Analytics
Analista de Dados Pleno criando dashboards, análises e indicadores para a Mell.ro. Apoio a decisões comerciais, operacionais e financeiras com dados de funil, contratos e carteira.
Reporting Analyst, CPG
Reporting Analyst creating automated marketing reports and performance insights for Power Digital, an AI-native growth firm. Translating campaign data into client recommendations across digital channels.
Medicaid Business Intelligence Lead
Medicaid BI Lead modernizing enrollment analytics, compliance reporting, and scalable data solutions for Humana’s healthcare business. Supporting state implementations and Medicaid Enrollment Operations.
Senior Medicaid BI/Reporting Business Analyst
Senior Medicaid BI analyst supporting pharmacy modernization through SQL analysis, reporting requirements, and validation. Liaising with healthcare stakeholders, technical teams, and report developers.
Reporting Analyst
Reporting Analyst building validated Oracle reports, extracts, and queries for Accenture Federal Services. Supporting federal agency data calls and financial reporting.