Top 28 Data warehouse architect Jobs in Chicago, Il

Data Architect | US
Cuesta Partners —Chicago, IL
- $175,000 - $225,000 a year
- Full-time
- Remote
- Computer Science
- SQL
- AWS
- Health insurance
- 401(k)
DATA ARCHITECT ANALYST
Loyola University Chicago —Chicago, IL
- $105,252 a year
- Full-time
- Computer science
- Computer Science
- Customer service
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
3d
Azure Data Architect
Anblicks —Addison, IL
- Full-time
- Analysis skills
- 1 year
- Senior level
Data Architect – Sales & Marketing Technology
TIAA —Chicago, IL
- $118,000 - $149,000 a year
- Online Application
- 5 years
- SQL
- Mentoring
Senior Data Engineer
Belvedere Trading —Chicago, IL
- $150,000 - $200,000 a year
- Email
- SQL
- Senior level
- No travel
Quick Apply
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
5h
Data AI Architect
SPR —Chicago, IL
- $150,000 - $185,000 a year
- Management
- Computer Science
- Java
- AD&D insurance
- Paid holidays
3d
Data Architect (AWS, Azure, GCP)
CapTech Consulting —Chicago, IL
- Full-time
- Azure
- 5 years
- Office
- Loan repayment program
- Disability insurance
Quick Apply
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 Data Warehouse Developer
Mavens Guild —Chicago, IL
- Full-time
- Computer science
- Computer Science
- Bachelor of Science
Quick Apply
Lead Systems Engineer (data)
Bravo17 LLC —Chicago, IL
- Full-time
- Remote
- Computer science
- 7 years
- Computer Science
- Health insurance
- Paid time off
2d
Sr. Consultant - Data Engineer
Insygnum —Chicago, IL
- 5 years
- Java
- SQL
ETL Architect
Reyes Holdings —Rosemont, IL
- $114,000 - $143,000 a year
- Full-time
- Computer science
- Computer Science
- DevOps
Quick Apply
10d
BI Team Lead- Back Office
Medline Industries —Northbrook, IL
- $116,000 - $174,000 a year
- Full-time
- Hybrid work
- 6 years
- Computer Science
- SQL
- Health insurance
- 401(k)
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
4d
Sr. Business Intelligence Analyst
Life Fitness, LLC —Rosemont, IL
- $109,400 - $153,800 a year
- Full-time
- Hybrid work
- Office
- 3 years
- SQL
- Commuter assistance
- Health savings account
Quick Apply
Director, Analytics, Data Engineering
Quad/Graphics —Chicago, IL
- $122,040 - $170,000 a year
- Azure
- Computer Science
- System design
- Paid holidays
- Health insurance
Senior BI Engineer (Hybrid)
Enova International —Chicago, IL
- $72,000 - $115,000 a year
- Full-time
- Office
- SQL
- US work authorization
- Paid parental leave
- Paid holidays
Essbase Hyperion Consultant (Locals to IL)
Sonoma Consulting Inc. —Oak Brook, IL
- Contract
- Mid-level
- Quality control
Quick Apply

I want to receive the latest job alert for data warehouse architect in chicago, il

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 chicago, il

Data Architect | US

Cuesta Partners
Chicago, IL

Apply Now

Job Details

Full-time
$175,000 - $225,000 a year

Benefits

Health insurance
401(k)

Qualifications

Data model design
Looker
Domo
Commercial use (data warehousing systems)
Cloud analytics services
Economics
Databricks
Data visualization software proficiency
Statistics
Computer Science
Requirements design
Bachelor's degree in statistics
Team leadership
Coaching
Data quality assurance
AI tools proficiency
Integration Architecture Design (Architecture design skills)
Bachelor's degree in economics
Talent development
Schema design
Business consulting
Snowflake
Change management
SQL
Data quality management
Team development
Data Architecture Design (Architecture design skills)
AWS
Cloud database architecture
Bachelor's degree

Full Job Description

Cuesta Partners is looking for a Data Architect to engage with us on transformational data programs with companies looking to take their AI & data capabilities to the next level.

Key Areas of Focus:

Business data modeling

Trade-offs between different modeling philosophies – dimensional, 3NF, Data Vault
Conceptual vs physical modeling
Modeling techniques such as inheritance, parent / child tables, ragged structures, slowly changing dimensions etc.
Normalization vs de-normalization trade-offs
Detailed understanding the design trade-offs around different modeling approaches
Ability to lead model review sessions, and being able to lay out the design "options" and implications, and also present it in a way that both executives and technical-minded people can understand

Modern data delivery design patterns

Data as product
Design compromises & considerations
Know what exemplar deliverables look like
Team composition and responsibilities / work to be done
Streaming vs batch design patterns / considerations
Pros / cons of data mesh delivery model vs alternatives
Comparison of modern cloud native platforms vs legacy on-premises data solutions

Master data governance

Types and most common root cause of DQ issues
Remediation approaches
MDM architecture styles / patterns
Key capabilities of MDM & DQ vendors

Expert in technologies including 1 or more of each class:

Data management layer
- Snowflake
- Databricks
- Microsoft Fabric
- GCP Big Query/ AWS DB Options
Data acquisition & integration
- Azure Data Factory (ADF)
- Matillion
- FiveTran & HVR
- Keboola
Data transformation & orchestration
- ETL
- DBT
- Python / SQL
- Apache Airflow etc.
Vis:
- PowerBI
- Tableau
- Looker
- Domo / ThoughtSpot / Qlik / platform BI vendors (ORCL, SAP, AWS etc.)

Architecture transformations:

Considerations / experience evaluating lift & shift vs re-model trade-offs
Considerations / experience when consolidating decentralized silos
Considerations / experience when moving to modern cloud stacks
Considerations / experience when enabling unified operational & analytics data hubs

Communication & leadership skills:

Able to identify & evaluate most important criteria when making design decisions
Able to look around corners – recognize likely issues before they happen
Able to communicate complex subjects with executive leaders
Able to solicit input & feedback to model and design decisions
Ability to teach / leverage experience to develop team/talent around them
Use past experiences to help with change management to eases concerns over shifts in approach

What You'll Do:

Design the business data model based on the discovered business processes and data analysis
Set the standard for AI-augmented development practices — ensuring projects are structured and tooled in ways that allow coding agents to operate effectively, and coaching the team to work the same way.
Translate business requirements into technical design specifications, including data streams, integrations, transformations, databases, and data warehouses.
Develop work estimates for Data Warehouse & Data Lake deliverables
Coach and mentor a team of a few dozen data engineers, analysts and ML Engineers on data architecture and modeling best practices
Define the data architecture framework, standards, and principles, including modeling, metadata, security, reference data such as product codes and client categories, and master data such as clients, vendors, materials, and employees
Define reference architecture, which is a pattern others can follow to create and improve data systems
Define data flows, i.e., which parts of the organization generate data, which require data to function, how data flows are managed, and how data changes in transition
Collaborate and coordinate with team members, clients and external SMEs

What We're Looking For:

Bachelor’s degree in a technical or quantitative field (e.g. Computer Science, Math, Economics Statistics)
10+ years of work experience in the data analytics space
Active, hands-on experience using AI-assisted development tools (e.g., Cursor, Claude Code, Codex, or similar) in your daily workflow — including building working prototypes, agentic pipelines, RAG systems, or LLM-powered data and analytics products — is a strong asset.
Previous experience in the consulting space is a plus
A passion for exploring and solving different kinds of problems
A desire to learn and assimilate technical information quickly
Hands-on experience deploying solutions in large-scale, high performing databases
Expertise aligned to technologies listed in Key Areas of Focus

Benefits: What you’ll gain:

At Cuesta, we value entrepreneurship, humility, diversity, learning, speed, and balance. We provide our team members with:

Constant opportunities for exposure & learning
Flexible working location and enabling personal-life harmony with work
Agency and influence in the company’s total strategy and direction
Collaboration with a high-performing team
Competitive base salary (outlined in this listing) and target bonus of 20-25%
401k, healthcare benefits, paid time-off, and more!

Compensation Range: $175K - $225K

Apply Now

Refine Your Search

data warehouse architect jobs in chicago, il

Data Architect | US

DATA ARCHITECT ANALYST

Junior Architect / Senior Data Engineer - Remote

Azure Data Architect

Data Architect – Sales & Marketing Technology

Senior Data Engineer

Solution Architect - Data & AI

Data AI Architect

Data Architect (AWS, Azure, GCP)

Senior Data Architect (AWS, Azure, GCP)

Senior Data Warehouse Developer

Lead Systems Engineer (data)

Sr. Consultant - Data Engineer

ETL Architect

BI Team Lead- Back Office

Staff Software Engineer, Backend (Lake Analytics Platform)

Sr. Business Intelligence Analyst

Director, Analytics, Data Engineering

Senior BI Engineer (Hybrid)

Essbase Hyperion Consultant (Locals to IL)

I want to receive the latest job alert for data warehouse architect in chicago, il

Related Searches

Explore jobs in more locations

Job Seeker Tools

Employer Tools

Browse

Stay Connected