Senior Data Analyst

First Chicago Insurance Company (FCIC)

Bedford Park (IL)

Presencial

USD 100.000 - 175.000

Jornada completa

Hace 5 días
Sé de los primeros/as/es en solicitar esta vacante

Una candidatura completa en un minuto

Currículum y carta de presentación personalizados, listos para enviar.

Supera los filtros ATS

Ventajas ofrecidas por este puesto de trabajo

Competitive Salaries
Training & Development
Medical and Dental
401k with company match
Paid Time Off and Holidays
Tuition Reimbursement
Wellness Program
Company events

Descripción de la vacante

First Chicago Insurance Company is seeking a Senior Data Analyst to serve as the data resource for Strategic Finance. You will build data extracts, analytical datasets, and reproducible reports sourced from the data lake and systems for timely, reconciled, and documented insights.

You will report to the Chief Accounting Officer & Treasurer and support investigations and executive reporting with a focus on claims data, FP&A data, and special projects as capacity allows.

Formación

  • Bachelor’s degree or equivalent experience in a related field.
  • 5+ years in data analysis, BI, or reporting in financial services.
  • Advanced SQL and data lake/cloud environment experience.
  • Proficiency with BI tools and Excel; Python for automation preferred.
  • Knowledge of P&C insurance data helpful.

Responsabilidades

  • Build and maintain data extracts and datasets from data lake and source systems.
  • Develop reproducible, documented queries and reports.
  • Reconcile datasets to GL and financials; document differences.
  • Identify data-quality issues and coordinate resolution with data owners.
  • Maintain data dictionary and lineage documentation.
  • Support executive summaries and automated reporting.
  • Assist with budgeting/forecasting data for FP&A as capacity permits.

Conocimientos

Advanced SQL
BI/data visualization
Excel
Python scripting
Data validation & reconciliation
Discretion with confidential data

Educación

Bachelor's degree in Data Analytics, Statistics, CS, IS, Finance, Accounting, Economics, or related field

Herramientas

SQL
Data lake
Cloud data warehouse
Excel
Python

Descripción del empleo

First Chicago is hiring a Senior Data Analyst as the dedicated data resource for its Strategic Finance unit. You will build and maintain the data extracts, analytical datasets, and reproducible reports the unit relies on, drawn directly from the enterprise data lake and source systems, so its analysis rests on timely, reconciled, and documented data.

You will report to the Chief Accounting Officer & Treasurer. Your first priority is supporting the Senior Strategy & Performance Analyst's investigations, action tracking, and executive reporting, with Claims data first. Financial Planning & Analysis and special projects are supported as capacity permits.

The role supplies data and reporting to the unit. It does not own enterprise KPI definitions, source systems, or the conclusions drawn from the analysis.

What You Will Do
  • Build and maintain data extracts and analytical datasets from the enterprise data lake and source systems, including claims, policy, premium, and financial data, at the level investigations require: carrier, state, program, product, distribution channel, department, and vendor.
  • Develop reproducible, documented queries and reports that can be refreshed, reviewed, and rerun without manual rework.
  • Reconcile datasets to the general ledger, financial reporting, and system control totals before release; document reconciling differences and their causes.
  • Identify and document data-quality issues; elevate source-system defects to the responsible data owners and track them to resolution.
  • Maintain a data dictionary and lineage documentation for the unit's datasets, applying enterprise KPI definitions where they exist and documenting any supplemental definitions.
  • Supply the data behind action tracking and monthly executive summaries, including documented baselines and post-implementation measurement of improvement initiatives.
  • Use existing enterprise reports where they are timely and sufficient; build supplemental data and reports only where they are not.
  • Automate recurring extracts and reports where automation reduces manual effort and error risk.
  • As capacity permits, support Financial Planning & Analysis with data for budgeting, forecasting, and variance analysis, and special projects with data and analysis as assigned.
Areas of Focus
  • Strategy & performance analysis (primary): Claims data first: severity and frequency, loss and loss adjustment expense, loss development, cycle times, attorney representation, litigation, complaints, vendor costs, and state/program variances. Data for other business areas as assignments require.
  • Financial Planning & Analysis (as capacity permits): Data extracts and supporting datasets for budgeting, forecasting, modeling, and variance analysis.
  • Special projects (as capacity permits): Data and analysis support as assigned.

The analyst supplies data; actuarial analyses and judgments remain with Actuarial, and source systems and data corrections remain with their owners.

What You Bring
  • Bachelor's degree in Data Analytics, Statistics, Computer Science, Information Systems, Finance, Accounting, Economics, or a related field, or equivalent experience.
  • Five or more years of data analysis, business intelligence, or reporting experience, including work in insurance or financial services. P&C insurance data experience strongly preferred.
  • Advanced SQL, including complex joins, window functions, and query performance on large datasets; experience in a data lake or cloud data warehouse environment.
  • Proficiency with BI/data visualization tools and advanced Excel. Scripting experience (such as Python) for data preparation and automation preferred.
  • Working knowledge of P&C insurance data: policy and premium, claims, loss and loss adjustment expense transactions, accident-year and calendar-year views, and financial reporting concepts.
  • Disciplined approach to validation, reconciliation, documentation, and version control; ability to explain data limitations clearly to non-technical audiences; discretion with confidential information.
How Success Is Measured

Timely delivery of data for investigations; datasets that reconcile to control totals at release; documented, reproducible queries and reports that refresh without rework; reduced manual effort through automation; data-quality issues identified, escalated, and tracked to resolution; and confidence among users in the numbers provided. Success is not measured by the volume of reports or dashboards produced.

Compensation & Benefits

First Chicago Insurance Company provides a competitive benefits package to all full- time employees. Following are some of the perks First Chicago employees receive:

  • Competitive Salaries
  • Commitment to your Training & Development
  • Medical and Dental
  • Telemedicine Benefit
  • 401k with a generous company match
  • Paid Time Off and Paid Holidays
  • Tuition Reimbursement Training Programs
  • Wellness Program
  • Fun company sponsored events
  • And so much more!
  • Visit our company website at firstchicagoinsurance.com

Estimated Compensation Range: $100k/year-$175K/year.*

*Published ranges are estimates. Offered compensation will be based on experience, skills, education, certifications, and geographic location. In addition, starting salary may vary by position depending on whether the position is in-office, hybrid or remote.

Consigue la evaluación confidencial y gratuita de tu currículum.

o arrastra y suelta tu archivo aquí

Similar jobs

Puestos de trabajo similares que vale la pena comparar

Senior Strategy & Performance Analyst
Senior Strategy & Performance Analyst

First Chicago Insurance Company (FCIC) • Bedford Park (IL)

Presencial
USD 100.000 - 175.000
Competitive salaries
Training & development
Medical and dental
+5
Underwriting Operations Specialist
Underwriting Operations Specialist

First Chicago Insurance Company (FCIC • Bedford Park (IL)

Presencial
USD 48.000 - 75.000
Competitive Salaries
Medical, Dental and Vision Reimbursement
401(k) with a generous company match
+3
Entry-level Claims Call Center Specialist
Entry-level Claims Call Center Specialist

First Chicago Insurance Company (FCIC • Bedford Park (IL)

Presencial
USD 22.000 - 23.000
Competitive Salaries
Training & Development
Medical and Dental Reimbursement
+4
Experience Auto Claims Call Center Specialist
Experience Auto Claims Call Center Specialist

First Chicago Insurance Company (FCIC • Bedford Park (IL)

Presencial
USD 25.000 - 28.000
Competitive Salaries
Training & Development
Medical, Dental and Vision Reimburst
+9
Auto Property Damage Claims Specialist
Auto Property Damage Claims Specialist

First Chicago Insurance Company • Oak Brook (IL)

Presencial
USD 42.000 - 75.000
Competitive Salaries
First Year Hiring Bonus for direct
Excellent benefits
+1
Auto Property Damage Claims Specialist
Auto Property Damage Claims Specialist

First Chicago Insurance Company • Chicago (IL)

Presencial
USD 42.000 - 75.000
First Year Hiring Bonus
Growth opportunities
Competitive Salaries
+5
Experience Auto Claims Call Center Specialist
Experience Auto Claims Call Center Specialist

First Chicago Insurance Company • Chicago (IL)

Presencial
USD 25.000 - 28.000
Competitive Salaries
Training & Development
Medical, Dental and Vision Reimburse
+1
Auto Casualty Claims Supervisor
Auto Casualty Claims Supervisor

First Chicago Insurance Company (FCIC • Bedford Park (IL)

Presencial
USD 70.000 - 95.000
Medical and Dental
401k with company match
Paid Time Off
+7
Casualty Claims Specialist
Casualty Claims Specialist

First Chicago Insurance Company • Peoria (IL)

Presencial
USD 55.000 - 98.000
Competitive salaries
Training & development
Medical and dental
+6
Product Analysis Intern
Product Analysis Intern

First Chicago Insurance Company (FCIC • Bedford Park (IL)

Presencial
USD 22.000 - 33.000