Top 29 Data Warehouse Architect Jobs in Chicago, IL

Data Architect - Wealth Management
System One —Chicago, IL
- Email
- Hybrid work
- Office
- SQL
- Machine learning
Quick Apply
2d
DATA ARCHITECT ANALYST
Loyola University Chicago —Chicago, IL
- $105,252 a year
- Full-time
- Computer science
- Computer Science
- Customer service
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 (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
ETL Architect
Reyes Holdings —Rosemont, IL
- $114,000 - $143,000 a year
- Full-time
- Computer science
- Computer Science
- DevOps
Quick Apply
10d
Data AI Architect
SPR —Chicago, IL
- $150,000 - $185,000 a year
- Management
- Computer Science
- Java
- AD&D insurance
- Paid holidays
3d
Senior Data Engineer
Belvedere Trading —Chicago, IL
- $150,000 - $200,000 a year
- Email
- SQL
- Senior level
- No travel
Quick Apply
Data Architect – Sales & Marketing Technology
TIAA —Chicago, IL
- $118,000 - $149,000 a year
- Online Application
- 5 years
- SQL
- Mentoring
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
Senior Data Warehouse Developer
Mavens Guild —Chicago, IL
- Full-time
- Computer science
- Computer Science
- Bachelor of Science
Quick Apply
Azure Data Architect
Anblicks —Addison, IL
- Full-time
- Analysis skills
- 1 year
- Senior level
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)
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
Essbase Hyperion Consultant (Locals to IL)
Sonoma Consulting Inc. —Oak Brook, IL
- Contract
- Mid-level
- Quality control
Quick Apply
Sr. Consultant - Data Engineer
Insygnum —Chicago, IL
- 5 years
- Java
- SQL
Lead Systems Engineer (data)
Bravo17 LLC —Chicago, IL
- Full-time
- Remote
- Computer science
- 7 years
- Computer Science
- Health insurance
- Paid time off
2d
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
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
4h
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

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 - Wealth Management

System One -
Chicago, IL

Quick Apply

Job Details

2 days ago

Qualifications

AWS IAM
Cloud identity and access management (IAM)
Commercial use (data warehousing systems)
Stakeholder engagement
Cloud analytics services
Data visualization software proficiency
Tooling
AWS Secrets Manager
Infrastructure as Code (IaC)
Data quality assurance
Regulatory compliance
Experience at asset management companies
Business intelligence report generation
Schema design
Security compliance frameworks implementation
Infrastructure architecture design
SQL
Information security compliance
Cloud database architecture
Data integrity process (data warehousing)
AWS Glue
Airflow
Finance industry (data warehouse design experience)
Bank experience
Data access controls implementation
Regulatory Frameworks (Architecture security)
Cloud Native Design
Scalability
Cloud compliance
Cloud automation

Full Job Description

W2 only - NO C2C candidates, NO 3rd parties

For immediate consideration, please connect with me on LinkedIn at https://www.linkedin.com/in/dpotapenko and then email your resume, work authorization status, current location, availability, and compensation expectations directly to [email protected] - make sure to include the exact job title and job location in your email message.

Data Architect- Wealth Management

Position Description
Join a collaborative data and analytics team building a modern, cloud native data platform on AWS. In this hands on architecture role, you will shape the data foundations that power wealth management insights, working alongside engineers, analysts, and business stakeholders. You will have the autonomy to define standards and patterns while working with a modern lakehouse and streaming stack. This hybrid position offers a strong balance of technical depth, influence, and professional growth.

This role is located onsite at the client's office in Naperville, IL. This is a hybrid work scheduled.

Future Responsibilities:

. Design and maintain the end to end data architecture for the Wealth Management domain, including data lakes/lakehouses, warehouses, and streaming pipelines on AWS.
. Define conceptual, logical, and physical data models for core wealth management entities such as clients, households, accounts, portfolios, holdings, transactions, and advisor relationships.
. Establish architecture standards, patterns, and best practices for data ingestion, storage, transformation, and consumption across the organization.
. Architect solutions for regulatory and compliance reporting (e.g., SEC, FINRA, Reg BI, SOX, and relevant privacy regimes), ensuring auditability and data lineage.
. Lead the design of data governance, quality, cataloging, and master data management (MDM) frameworks.
. Partner with security teams to enforce encryption, access controls, and PII/PCI handling for sensitive financial and client data.
. Guide data engineering teams on implementation, review designs, and ensure alignment to the target architecture.
. Evaluate and select tools and AWS services, balancing cost, performance, scalability, and maintainability.
. Support real time and batch integration with source systems such as portfolio accounting, custody, CRM, market data feeds, and financial planning platforms.

Collaborate with business and analytics stakeholders to enable BI, reporting, and advanced analytics/ML use cases.

Requirements:

. 10–12 years of experience in data engineering / data architecture, with a substantial portion in Banking & Financial Services.
. Demonstrated experience in Wealth Management or closely adjacent areas (asset management, private banking, or brokerage), with working knowledge of financial instruments, portfolios, custody, advisory, and client/household data.
. Proven track record designing large scale data platforms on AWS.
. Strong data modeling expertise across dimensional, data vault, and normalized/3NF approaches, and knowing when to apply each.
. Deep experience with data lake / lakehouse and data warehouse architecture, including ETL/ELT design.
. Solid understanding of data governance, data quality, metadata management, and data lineage in a regulated environment.
. Experience handling sensitive data with appropriate security, privacy, and compliance controls.
. Strong stakeholder management and the ability to communicate architectural decisions to technical and non technical audiences.
. AWS storage & compute: S3, Redshift, EMR, Athena, Glue, Lake Formation; lakehouse formats Parquet and Iceberg or Delta Lake.
. Streaming and serverless orchestration: Kinesis, MSK (Managed Kafka), Lambda, Step Functions, MWAA (Managed Airflow).
. Databases: RDS, Aurora, DynamoDB.
. Security & access: IAM, KMS, encryption at rest/in transit, and fine grained access control.
. Infrastructure as Code (CloudFormation and/or Terraform), advanced SQL, and Python.
. BI / consumption tools: QuickSight, Tableau, or Power BI.

Nice to Have Skills

. AWS certifications (e.g., AWS Certified Data Analytics – Specialty, AWS Certified Solutions Architect).
. Enterprise architecture framework experience (e.g., TOGAF).
. Experience with data cataloging and governance tools (e.g., Collibra, Alation).
. Familiarity with market data providers (e.g., Bloomberg, Refinitiv) and portfolio accounting / performance systems.
. Exposure to machine learning / advanced analytics enablement.
. Experience with data mesh or domain oriented data architecture.
. Knowledge of relevant regulatory frameworks and reporting requirements in wealth management.

For immediate consideration, please connect with me on LinkedIn at https://www.linkedin.com/in/dpotapenko and then email your resume, work authorization status, current location, availability, and compensation expectations directly to [email protected] - make sure to include the exact job title and job location in your email message.

#LI-DP1

#M1

Ref: #404-IT Pittsburgh

Quick Apply

Refine Your Search

Data Warehouse Architect jobs in Chicago, IL

Data Architect - Wealth Management

DATA ARCHITECT ANALYST

Data Architect | US

Data Architect (AWS, Azure, GCP)

Senior Data Architect (AWS, Azure, GCP)

ETL Architect

Data AI Architect

Senior Data Engineer

Data Architect – Sales & Marketing Technology

Sr. Business Intelligence Analyst

Senior Data Warehouse Developer

Azure Data Architect

BI Team Lead- Back Office

Junior Architect / Senior Data Engineer - Remote

Essbase Hyperion Consultant (Locals to IL)

Sr. Consultant - Data Engineer

Lead Systems Engineer (data)

Senior BI Engineer (Hybrid)

Solution Architect - Data & AI

Staff Software Engineer, Backend (Lake Analytics Platform)

I want to receive the latest job alert for Data Warehouse Architect in Chicago, IL

Explore jobs in more locations

Job Seeker Tools

Employer Tools

Browse

Stay Connected