Top 45 Data warehouse architect Jobs in Illinois

Senior Data Engineer – Insurance Data Platform
CCMSI —Danville, IL
- $100,000 - $150,000 a year
- Monday to Friday
- Remote
- System design
- HIPAA
- 8 years
- Paid holidays
- Disability insurance
Data Architect | US
Cuesta Partners —Chicago, IL
- $175,000 - $225,000 a year
- Full-time
- Remote
- Computer Science
- SQL
- AWS
- Health insurance
- 401(k)
Solution Architect - Data & AI
Northern Trust Corp. —Chicago, IL
- $137,400 - $233,600 a year
- Full-time
- Azure
- AWS
- US work authorization
- Health insurance
- Dental insurance
6d
Junior Architect / Senior Data Engineer - Remote
Optum —Schaumburg, IL
- $91,700 - $163,700 a year
- Full-time
- Hybrid work
- 5 years
- Pass drug screening
- System design
9d
Data AI Architect
SPR —Chicago, IL
- $150,000 - $185,000 a year
- Management
- Computer Science
- Java
- AD&D insurance
- Paid holidays
9d
DATA ARCHITECT ANALYST
Loyola University Chicago —Chicago, IL
- $105,252 a year
- Full-time
- Computer science
- Computer Science
- Customer service
Data Architect – Sales & Marketing Technology
TIAA —Chicago, IL
- $118,000 - $149,000 a year
- Online Application
- 5 years
- SQL
- Mentoring
Azure Data Architect
Anblicks —Addison, IL
- Full-time
- Analysis skills
- 1 year
- Senior level
Staff Software Engineer, Backend (Lake Analytics Platform)
Affirm —Chicago, IL
- $204,000 - $290,000 a year
- On call
- Remote
- 8 years
- Bachelor's degree
- Mentoring
- Employee stock purchase plan
- Health insurance
10d
Senior Data Architect (AWS, Azure, GCP)
CapTech Consulting —Chicago, IL
- $120,000 - $200,000 a year
- Full-time
- 7 years
- Azure
- Office
- Loan repayment program
- Disability insurance
Quick Apply
Senior Solution Architect-Data-TED/PE
Krasan Consulting Services Inc —Springfield, IL
- $65 - $70 an hour
- Full-time
- Remote
- Computer science
- Computer Science
- HIPAA
Quick Apply
Sr. Consultant - Data Engineer
Insygnum —Chicago, IL
- 5 years
- Java
- SQL
Data Architect (AWS, Azure, GCP)
CapTech Consulting —Chicago, IL
- Full-time
- Azure
- 5 years
- Office
- Loan repayment program
- Disability insurance
Quick Apply
Senior Data Engineer
Belvedere Trading —Chicago, IL
- $150,000 - $200,000 a year
- Email
- SQL
- Senior level
- No travel
Quick Apply
Informatica Cloud Data Engineer (IDMC/IICS)
Capgemini Sogeti —Chicago, IL
- Full-time
- Azure
- Mid-level
- SQL
- Paid parental leave
- Paid holidays
3d
Snowflake Data Architect
Keeley Construction —Belleville, IL
- Hybrid work
- Azure
- Computer Science
- Salesforce
- Opportunities for advancement
Quick Apply
Senior Data Warehouse Developer
Mavens Guild —Chicago, IL
- Full-time
- Computer science
- Computer Science
- Bachelor of Science
Quick Apply
Oracle Utilities Onshore Report Strategy Lead
Logic —Chicago, IL
- $87,400 - $266,300 a year
- Full-time
- Oracle
- US work authorization
- Military encouraged
- Paid holidays
- Disability insurance
Oracle Utilities Onshore Report Strategy Lead
Accenture —Chicago, IL
- $87,400 - $266,300 a year
- Full-time
- Oracle
- US work authorization
- Military encouraged
- Paid holidays
- Disability insurance
Principal Integration Engineer - Trade Data Warehouse
U.S. Bank National Association —Chicago, IL
- $143,905 - $169,300 a year
- Full-time
- Management
- DevOps
- System design
- Paid holidays
- Disability insurance
1d

I want to receive the latest job alert for data warehouse architect in illinois

By signing in to your account, you agree to SimplyHired's Terms of Service and consent to our Cookie and Privacy Policy.

Explore jobs in more locations

data warehouse architect jobs near illinois

Senior Data Engineer – Insurance Data Platform

CCMSI -
Danville, IL

Apply Now

Job Details

$100,000 - $150,000 a year

Benefits

Paid holidays
Visa sponsorship
Disability insurance
Health insurance
Dental insurance
401(k)
Paid time off
Vision insurance
Employee stock ownership plan
Opportunities for advancement
Life insurance

Qualifications

Commercial use (data warehousing systems)
Performance tuning
Cloud analytics services
Cloud data warehouses
Finance
Query plan analysis
Spark
Data retrieval time improvement
Git
IT experience within insurance industry
SQL
Pandas
Production systems
ETL process automation
Continuous integration
Financial concepts
CPT coding
Scalability
Cloud automation
DevOps automation
Query management
Providing code feedback

Full Job Description

Overview

Senior Data Engineer – Insurance Data Platform

Location: Remote
Schedule: Monday – Friday, 8:00 AM – 4:30 PM CT (additional hours as needed)
Salary Range: $100,000 – $150,000 (commensurate with experience)

Build Your Career With Purpose at CCMSI

At CCMSI, we partner with global clients to solve their most complex risk management challenges, delivering measurable results through advanced technology, collaborative problem-solving, and an unwavering commitment to their success.

We don’t just process claims—we support people. As the largest privately-owned Third Party Administrator (TPA), CCMSI delivers customized claim solutions that help our clients protect their employees, assets, and reputations. We are a certified Great Place to Work®, and our employee-owners are empowered to grow, collaborate, and make meaningful contributions every day.

Job Summary

The Senior Data Engineer has a firm grasp of insurance data and serves as the owner and designer of data pipelines which moves claims, policy, billing, medical, and financial data from our core administration systems into our analytics platform, and from there into client-facing reporting, internal dashboards, and ML models.

This is a builder role which architects, writes code, mentors junior engineers, and partners directly with claims operations, actuarial, finance, and CCMSI’s client services teams to transform operational data into usable format for decision making.

Accuracy, scalability, and reliability are critical—this data supports client reporting, regulatory filings, and financial decision-making.

Responsibilities

Design, build, and maintain ELT/ETL pipelines moving data from our claims administration system (iCE), policy admin, medical bill review, banking, and third-party vendor feeds into our cloud data warehouse.

Own the data models for core insurance objects — claims, policies, coverages, reserves, payments, recoveries, exposures, units, and loss development triangles — and make sure they hold up under actuarial scrutiny.

Build and maintain integrations with external vendors and partners — medical bill review (MBR), pharmacy benefit managers (PBM), bureau reporting (NCCI, state bureaus, ISO), excess carriers, and client BI environments.

Develop and support the data feeds that drive client loss runs, board reports, and self-insured trust deliverables.

Accuracy here is non-negotiable — these reports go to clients, auditors, and regulators.

Build and maintain data quality monitoring, anomaly detection, and reconciliation processes. If a paid loss number is wrong, we need to know before the client does.

Partner with the actuarial and analytics teams on loss development, IBNR, and trending data structures — including the triangle data that feeds reserve studies.

Support state and federal regulatory reporting data needs (EDI claims reporting, Medicare Section 111)

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skills, and/or abilities required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Insurance Experience (Non-Negotiable)

5+ years working with insurance data in a carrier, TPA, MGA, broker, or insurance-tech environment.
Deep working knowledge of claims data structures — claimants, coverages, reserves (indemnity, medical, expense), payments, recoveries, financial transactions, and the relationship between policy and claim.
Experience with at least one major claims administration system
Familiarity with workers' compensation and/or general liability claims data specifically — jurisdictional rules, body parts, ICD/CPT codes, NCCI class codes, etc.
Comfortable with insurance financial concepts: paid vs incurred, case reserves vs IBNR, loss development, reinsurance recoveries, deductibles, SIRs, and aggregate stop-loss.

Technical

8+ years total professional data engineering experience.
Expert SQL — window functions, recursive CTEs, query tuning, execution plans. You should be able to look at a slow query and know where it's going to hurt.
Strong Python for data work (pandas, PySpark, SQLAlchemy, plus general-purpose Python — APIs, testing, packaging).
Production experience with at least one modern cloud data warehouse (Snowflake, Databricks, BigQuery, Synapse, or Redshift).
Solid experience with an orchestration tool
Comfortable with one or more ELT tools
Experience with cloud infrastructure —Azure preferred. IaC experience (Terraform/Bicep/CloudFormation) a plus.
Git, CI/CD, code review as a normal part of how you work.

Other

Bachelor's degree in CS, MIS, math, statistics, or equivalent experience. We care more about what you can do than where you went to school.
Clear written and verbal communication. You'll be talking to actuaries, claims VPs, and clients — not just other engineers.
You can work independently in a remote-first environment without anyone hovering.

Preferred Experience:

Direct experience with TPA platforms.
Experience with EDI claims reporting (IAIABC formats), Medicare Section 111 reporting, or state-specific filings.
Exposure to actuarial reserving software and the data structures they consume.
Experience with medical bill review data and PPO/network logic.
Streaming/event experience — Kafka, Kinesis, Event Hubs, Debezium.
ML/feature-engineering experience supporting predictive models (claim severity, litigation propensity, fraud, return-to-work).
Experience with HIPAA, SOC 2, or similar compliance regimes — claims data is regulated, and you should be comfortable working inside those guardrails.
Prior TPA, self-insured group, or public entity pool experience.

What Success Looks Like

First 90 Days

Gain a strong understanding of CCMSI’s core data systems and architecture

Deliver at least one meaningful pipeline improvement or enhancement

Build relationships with key stakeholders across claims, actuarial, and client services

First 6 Months

Own a critical portion of the data platform end-to-end

Improve data reliability, quality, or performance for key pipelines

Actively mentor junior team members

First Year

Recognized as the go-to person on claims/policy data architecture across IT and the business.

Delivered on a strategic initiative — modernization, real-time data, or a major new client integration — that you helped scope and lead

Why You’ll Love Working Here

4 weeks (Paid time off that accrues throughout the year in accordance with company policy) + 10 paid holidays in your first year
Comprehensive benefits: Medical, Dental, Vision, Life, and Disability Insurance
Retirement plans: 401(k) and Employee Stock Ownership Plan (ESOP)
Career growth: Internal training and advancement opportunities
Culture: A supportive, team-based work environment

Compensation & Compliance

The posted salary reflects CCMSI’s good-faith estimate in accordance with applicable pay transparency laws. Actual compensation will be based on qualifications, experience, geographic location, and internal equity. This role may also qualify for bonuses or additional forms of pay.

CCMSI offers comprehensive benefits including medical, dental, vision, life, and disability insurance. Paid time off accrues throughout the year in accordance with company policy, with paid holidays and eligibility for retirement programs in accordance with plan documents.

CCMSI posts internal career opportunities in compliance with applicable state and local promotion transparency laws.

Visa Sponsorship: CCMSI does not provide visa sponsorship for this position.

ADA Accommodations: CCMSI is committed to providing reasonable accommodations throughout the application and hiring process.

Equal Opportunity Employer: CCMSI complies with all applicable employment laws, including pay transparency and fair chance hiring regulations.

Background checks, if required for the role, are conducted only after a conditional offer and in accordance with applicable fair chance hiring laws.

Our Core Values

At CCMSI, we believe in doing what’s right—for our clients, our coworkers, and ourselves. We look for team members who:

Lead with transparency We build trust by being open and listening intently in every interaction.
Perform with integrity We choose the right path, even when it is hard.
Chase excellence We set the bar high and measure our success. What gets measured gets done.
Own the outcome Every employee is an owner, treating every claim, every decision, and every result as our own.
Win together Our greatest victories come when our clients succeed.

We don’t just work together—we grow together. If that sounds like your kind of workplace, we’d love to meet you.

#CCMSICareers #EmployeeOwned #GreatPlaceToWorkCertified #ESOP #TPA #DataEngineering #InsuranceData #CloudData #Analytics #RemoteJobs #IND123 #LI-Remote

Apply Now

Refine Your Search

data warehouse architect jobs in illinois

Senior Data Engineer – Insurance Data Platform

Data Architect | US

Solution Architect - Data & AI

Junior Architect / Senior Data Engineer - Remote

Data AI Architect

DATA ARCHITECT ANALYST

Data Architect – Sales & Marketing Technology

Azure Data Architect

Staff Software Engineer, Backend (Lake Analytics Platform)

Senior Data Architect (AWS, Azure, GCP)

Senior Solution Architect-Data-TED/PE

Sr. Consultant - Data Engineer

Data Architect (AWS, Azure, GCP)

Senior Data Engineer

Informatica Cloud Data Engineer (IDMC/IICS)

Snowflake Data Architect

Senior Data Warehouse Developer

Oracle Utilities Onshore Report Strategy Lead

Oracle Utilities Onshore Report Strategy Lead

Principal Integration Engineer - Trade Data Warehouse

I want to receive the latest job alert for data warehouse architect in illinois

Related Searches

Explore jobs in more locations

Overview

Build Your Career With Purpose at CCMSI

Job Summary

Responsibilities

Qualifications

Job Seeker Tools

Employer Tools

Browse

Stay Connected