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.
Bedford Park, IL, 60638, US
Actively hiring, first seen by us 9 days agoVisit 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
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 type in the employer’s posting: FULL_TIMEFrom the employer’s 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
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
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.
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.
From the employer’s posting.
Actively hiringFirst seen by us 9 days ago, still listed, and not a repost of an earlier posting.
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
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.
Day 9
Similar jobs usually come down between day 5 and day 43.
From 16,008 similar postings that came down. Coming down is not always a hire.
1 open job
Open jobs by the week we first saw them, last 12 weeks.
Hiring recordAdd 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.
- 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.
Complete your application on firstchicagoinsurance.applicantpro.com. The employer’s form will show what is required.
Already applied? Track this application
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 DoThe analyst supplies data; actuarial analyses and judgments remain with Actuarial, and source systems and data corrections remain with their owners.
What You BringTimely 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 & BenefitsFirst Chicago Insurance Company provides a competitive benefits package to all full- time employees. Following are some of the perks First Chicago employees receive:
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.
New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.
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.
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.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
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.
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.
No clear work-authorization passage found. Eligibility is unconfirmed.