Back to jobs

Senior Data Analyst

Pay
$100,000–175,000/yearLocation-specific pay — pay source
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.
Read the full posting
Work setting
Hybrid — work setting source
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.
Read the full posting
Employment
Full-time — employment source
Employment type in the employer’s posting: FULL_TIME
From the employer’s posting

What you’ll work on

Full posting
  • Build and maintain data extracts and analytical datasets from the data lake and source systems

  • Reconcile datasets to the general ledger and control totals before release, documenting differences

  • Develop reproducible, documented queries and reports that rerun without manual rework

  • Identify data-quality issues and escalate source-system defects to data owners

  • Supply data behind action tracking and monthly executive summaries

From the employer’s posting
Build and maintain data extracts and analytical datasets from the enterprise data lake and source systems
Reconcile datasets to the general ledger, financial reporting, and system control totals before release; document reconciling differences and their causes.
Develop reproducible, documented queries and reports that can be refreshed, reviewed, and rerun without manual rework.
Identify and document data-quality issues; escalate source-system defects to the responsible data owners and track them to resolution.
Supply the data behind action tracking and monthly executive summaries

What you’ll bring

All qualifications

Core experience

  • Bachelor's degree in Data Analytics, Statistics, Computer Science, Information Systems, Finance, Accounting, Economics, or a related field, or equivalent experience.
  • Proficiency with BI/data visualization tools and advanced Excel.
Qualification wording
Bachelor's degree in Data Analytics, Statistics, Computer Science, Information Systems, Finance, Accounting, Economics, or a related field, or equivalent experience.
Proficiency with BI/data visualization tools and advanced Excel. Scripting experience (such as Python) for data preparation and automation preferred.
Education & alternatives
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.

Benefits in the posting

Full benefits wording
  • 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
  • *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.

From the employer’s posting.

Posting record

Report an error

Actively hiringFirst seen by us 9 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 12, 20269 days ago
Recorded sightings
11
Last seen by us
Nov 22, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

In line with similar jobs

$100K–$175K against $95K–$145K, the middle half of what similar US postings state.

From 2,327 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 9

Similar jobs usually come down between day 5 and day 43.

From 16,018 similar postings that came down. Coming down is not always a hire.

First Chicago Insurance Company is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • Excel
Where the posting names them
- 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.
- 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.

Your next step

Complete your application on firstchicagoinsurance.applicantpro.com. The employer’s form will show what is required.

Already applied? Track this application

Job description

View original posting ↗

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; escalate 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.





Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
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.
Location & working pattern

Bedford Park, IL, 60638, US

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.
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.