Senior Data Analyst

First Chicago Insurance Company (FCIC)•Chicago, IL

3d•$100 - $175

About The Position

First Chicago is hiring a Senior Data Analyst as the dedicated data resource for its Strategic Finance unit. The role builds and maintains data extracts, analytical datasets, and reproducible reports from the enterprise data lake and source systems, ensuring analysis relies on timely, reconciled, and documented data. The analyst reports to the Chief Accounting Officer & Treasurer. The primary focus is supporting the Senior Strategy & Performance Analyst’s investigations, action tracking, and executive reporting, beginning with Claims data. Support for Financial Planning & Analysis and special projects is provided as capacity permits. The role supplies data and reporting to the unit; it does not own enterprise KPI definitions, source systems, or analytical conclusions. Actuarial analyses and judgments remain with Actuarial, while source systems and data corrections remain with their owners. The position focuses first on strategy and performance analysis of Claims data, including severity and frequency, loss and loss adjustment expense, loss development, cycle times, attorney representation, litigation, complaints, vendor costs, and state/program variances. It may also provide data for other business areas as assigned. As capacity permits, the analyst supports budgeting, forecasting, modeling, variance analysis, and special projects. Success is measured by timely data delivery 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 user confidence in the numbers provided. Success is not measured by the volume of reports or dashboards produced.

Requirements

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.
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.
Working knowledge of P&C insurance data, including 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.

Nice To Haves

P&C insurance data experience is strongly preferred.
Scripting experience, such as Python, for data preparation and automation is preferred.

Responsibilities

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 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 supplemental definitions.
Supply 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 support special projects with data and analysis as assigned.
Support strategy and performance analysis, with Claims data as the first priority, including analysis of severity and frequency, loss and loss adjustment expense, loss development, cycle times, attorney representation, litigation, complaints, vendor costs, and state/program variances.