Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Senior Data Analyst

$100k - $175k

First Chicago Insurance Company (FCIC)

Job Description

Job Description

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.

Job Posted by ApplicantPro
Vacancy posted 3 days ago
Similar jobs that could be interesting for youBased on the Senior Data Analyst in Chicago, IL vacancy
  • $116.88k - $151.25k

     ...Chicago's most iconic areas. Role Overview: We are seeking a Senior Quantitative Analyst with a strong product development mindset to analyze...  ...ideal candidate brings experience in quantitative finance, data analytics, and statistical modeling, with the ability to turn... 
    Senior
    Full time
    Work at office
    Immediate start

    Cboe Exchange

    Chicago, IL
    3 days ago
  • $90k - $150k

    TransUnion's Job Applicant Privacy Notice Personal Information We Collect Your Privacy Choices Team Overview The Senior Data Analyst will report into a Senior Manager of Data Science & Analytics. As part of the Data Analytics Team, you will help with development... 
    Senior
    Full time
    Temporary work
    Work experience placement
    Work at office
    Flexible hours
    2 days per week

    Trans Union LLC

    Chicago, IL
    1 day ago
  •  ...Job Description Job Description The Institutional Data Analyst or Senior Institutional Data Analyst is a technical lead in the Office of Institutional Planning and Effectiveness. The position is responsible for the design, creation, and maintenance of institutional... 
    Senior
    Full time
    Work at office
    Visa sponsorship
    Work visa
    2 days per week

    Concordia University, Chicago

    River Forest, IL
    21 days ago
  • $81.8k - $106.6k

     ...dependable airline. Job Overview and Responsibilities The Senior Analyst - Digital Optimization will be responsible for the analytics...  ...meaning this individual is in charge of measuring experimental data, deriving meaningful insights, and ensuring integrity of high-... 
    Senior
    Hourly pay
    Work experience placement
    Work at office

    United Airlines

    Chicago, IL
    7 days ago
  • $114k - $156.2k

     ...journey that turns curious developers into lifelong advocates.Why This Role?This role sits within the DLG team as part of a two-person data team, where you'll have an experienced tech lead as your analytical partner, giving you both the autonomy to own your domain and the... 
    Senior
    Local area
    Worldwide
    Flexible hours

    Okta

    Chicago, IL
    4 days ago
  • $99.4k - $150.3k

     ...place! Agentforce is the future of AI, and you are the future of Salesforce.We're looking for a consultative, strategic and data-savvy analyst to join our Recruiting organization. In this role, you'll sit at the intersection of market research, competitor analysis, and... 
    Senior
    Full time
    For contractors
    Shift work

    Salesforce

    Chicago, IL
    4 days ago
  • $154k - $200k

    This is AdyenAdyen provides payments, data, and financial products in a single solution for customers...  ...businesses achieve their ambitions faster.Senior Optimization Data AnalystWe are looking for a Senior Optimization Data Analyst to take a defining role in how Adyen drives... 
    Senior
    Work at office
    3 days per week

    Adyen

    Chicago, IL
    3 days ago
  •  ...intersection of legal operations, process improvement, technology, data storytelling, client service and legal project management. The...  ...’ and clients’ evolving priorities.The LPM Data & Analytics Senior Analyst supports the delivery of solutions that advance the firm’s... 
    Senior
    Work at office
    Shift work

    Ropes & Gray

    Chicago, IL
    3 days ago
  • $90k - $150k

    TransUnion's Job Applicant Privacy NoticePersonal Information We CollectYour Privacy ChoicesTeam OverviewThe Senior Data Analyst will report into a Senior Manager of Data Science & Analytics. As part of the Data Analytics Team, you will help with development of TransUnion... 
    Senior
    Full time
    Temporary work
    Work experience placement
    Work at office
    Flexible hours
    2 days per week

    TransUnion

    Chicago, IL
    4 days ago
  • $116.38k - $138.41k

     ...agents and brokers to provide insurance solutions that enable businesses to manage risks with confidence.Job DescriptionThe Senior Data Analyst plays a critical role in advancing the organization's regulatory reporting, data quality, and analytical capabilities. This position... 
    Senior
    Full time
    Local area

    Argo Group

    Chicago, IL
    4 days ago
  • $100k - $150k

     ...brighter way forward. What this job involvesJLL is seeking a Manager, Data & Analytics for the National Leasing Advisory Industrial...  ...translate quantitative work into narratives that non-technical senior leaders can act on.Experience and qualificationsBachelor’s degree... 
    Senior
    Full time
    Local area
    Flexible hours

    Jones Lang LaSalle

    Chicago, IL
    12 hours ago
  •  ...Senior Marketing Analyst, Campaign Reporting & Insights Chicago, IL (Remote) 6+ month contract What You’ll Do Campaign Performance Reporting...  ...& Automation Build, maintain and improve dashboards, data transformations and repeatable reporting workflows Cut... 
    Senior
    Contract work
    Remote work

    Forbes Technical Consulting

    Chicago, IL
    1 day ago
  • $125k - $155k

    Company DescriptionPosition: Senior Data Center ConsultantEYP Mission Critical Facilities, part of Ramboll Americas Engineering, is an innovator and a market leader in sustainable Data Center Consulting & Strategy, Design, and Commissioning with a 25-year history of excellence... 
    Senior
    Work at office
    Local area
    Home office
    Flexible hours

    Ramboll Management Consulting

    Chicago, IL
    1 day ago
  • Terakeet is seeking a Sr. SEO Analyst to assess client properties for SEO/GEO best practices, develop recommendations, and measure partnership...  ...analytics, and collaborate with content teams to translate data into actionable insights that drive client success. The role is... 
    Senior
    Remote job

    Terakeet

    Chicago, IL
    3 days ago
  •  ...repurposed products that help preserve our planet. Sims is looking for a highly analytical and technically skilled Global HRIS Senior Data Analyst to join our Global HRIS team. In this role, you will maximize the value of HR technology by delivering advanced reporting,... 
    Senior

    Sims Metal

    Chicago, IL
    a month ago
  • $115k - $150k

     ...offices around the world combine experience across technology, data sciences, consulting, and customer obsession to accelerate our clients...  ...their customers truly value.OverviewSenior ConsultantAs a Senior Consultant specializing in Data Strategy, you will play a key role... 
    Senior
    Flexible hours

    Publicis Media

    Chicago, IL
    1 day ago
  • $208.5k - $225k

     ...OpportunityWe're hiring various roles from Staff level to Senior Staff level Data Scientists. At Wonder Data Science, our mission is to build...  ...mentoring and providing technical direction to other scientists, analysts, or engineers.Got These? Even Better Experience leading end... 
    Senior
    Full time
    Temporary work
    Flexible hours

    GrubHub

    Chicago, IL
    4 hours ago
  • $73.15k - $101.01k

     ...the right for brands to exist in human networks. Today, and tomorrow. We deliver Networked Experiences by leveraging comprehensive data, technology, creative, media and strategy capabilities. Digitas delivers ambitious outcomes via unique solutions that include Creative... 
    Senior
    Temporary work
    Freelance
    Flexible hours

    Publicis Groupe

    Chicago, IL
    3 days ago
  • $116.2k - $229.1k

     ...ends on 02/28/2027Work you'll do· As a Supply Chain Optimization Data Scientist you will be responsible for· Define decision...  ...Professional development From entry-level employees to senior leaders, we believe there’s always room to learn. We offer opportunities... 
    Senior
    Local area

    Deloitte

    Chicago, IL
    3 days ago
  • $73.15k - $101.01k

     ...We deliver Networked Experiences by leveraging comprehensive data, technology, creative, media and strategy capabilities. Digitas...  ...clients. To help with this, we’re looking for an outstanding Senior Analyst - someone who can analyze massive data sets, make insightful cross... 
    Senior
    Temporary work
    Freelance
    Flexible hours

    Publicis Groupe

    Chicago, IL
    11 days ago
  • $59.81k - $129.59k

    Job Summary Provides senior level analysis for complex data to generate insights that support strategic and operational decision-making. This role designs...  .... Experience leading projects or mentoring junior analysts. Familiarity with regulatory reporting and healthcare industry... 
    Senior
    Full time
    Work experience placement
    Remote work

    Molina Healthcare, Inc.

    Chicago, IL
    3 days ago
  •  ...RBI Home Office is comprised of several senior executives and members of the Finance organization...  ...Position Summary The Senior Finance Analyst will play a key role in driving the...  ...responsible for consolidating financial data, generating accurate and timely reports,... 
    Senior
    Local area
    Home office
    Relocation package

    River Bend Industries

    Chicago, IL
    1 day ago
  • $89.93k - $121.4k

    Senior Analyst - Business Data As a Senior Analyst - Business Data you will be responsible for accessing financial, SKU number and description, Sales and Margin Master data and 13+ unique ERP systems to generate analytics for business initiatives using Power BI reporting... 
    Senior
    Full time
    Immediate start
    Remote work
    Worldwide
    Shift work

    Wesco

    Chicago, IL
    4 days ago
  •  ...Job Description Job Description Senior Associate - Security Data Management Chicago, Illinois - Onsite 4 days per week Position Summary:...  ..., pricing and market data management. The Senior Data Analyst plays a central role in the firm's middle office production... 
    Senior
    Work at office

    1872 Consulting

    Chicago, IL
    20 days ago
  • $111.2k - $126.9k

     ...Senior Data Analyst - Risk Product Data At Capital One, data is at the center of everything we do. When we launched as a startup we disrupted the credit card industry by individually personalizing every credit card offer using statistical modeling and the relational database... 
    Senior
    Full time
    Part time
    Local area

    Capital One

    Chicago, IL
    3 days ago
  •  ...As a Senior Clinical Data Analyst, you will identify operational improvement opportunities through analytics that help Tendo's customers meet or exceed their financial, quality, and operational goals. Success in this role depends on deep familiarity with inpatient workflows... 
    Senior
    Remote job
    Full time

    tendo

    Chicago, IL
    3 days ago
  •  ...President, HR Operations. Opportunity JBT Marel is looking for a report Analyst. You will designs, builds, and maintains reporting and analytics...  ...that provides JBT Marel organization insights on all HR related data and supports decision making across the company. This role owns... 
    Senior
    Temporary work
    Local area
    Remote work
    Work from home

    JBT Marel Corporation

    Chicago, IL
    4 days ago
  • $114k - $156.2k

     ...that turns curious developers into lifelong advocates. Why This Role? This role sits within the DLG team as part of a two-person data team, where you'll have an experienced tech lead as your analytical partner, giving you both the autonomy to own your domain and... 
    Senior
    Local area
    Worldwide
    Flexible hours

    Okta

    Chicago, IL
    7 days ago
  • $114k - $156.2k

     ...Role This role sits within the DLG team as part of a two-person data team where youll have an experienced tech lead as your...  ...or employee residing in New York City please click here to view our full NYC AEDT Notice. Required Experience: Senior IC ]]... 
    Senior
    Full time
    Local area
    Worldwide
    Flexible hours

    Okta

    Chicago, IL
    2 days ago
  • $150k - $175k

     ...Senior Analyst Harbor Capital Advisors is seeking a Senior Analyst to join its Investment Risk and Data Science team, reporting to the Head of IRDS. The IRDS team is part of the broader Harbor Investment Research team and is primarily responsible for: Monitor the... 
    Senior
    Work at office

    Harbor Capital Advisors, Inc.

    Chicago, IL
    2 hours ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Senior Data Analyst. Be the first to apply!