> Markdown version of [/jobs/ext/1507487-sr-data-warehouse-architect](https://www.wearedevelopers.com/jobs/ext/1507487-sr-data-warehouse-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Sr Data Warehouse Architect

- **Company:** Shirley Ryan AbilityLab
- **Location:** Chicago, IL, United States
- **Experience:** Expert
- **Salary:** $110,800.0 - $184,000.0
- **Contract:** Permanent contract
- **Skills:** Query Performance, Artificial Intelligence, Data Analysis, Microsoft Azure, Big Data, Software as a Service, Cloud Computing, Cloud Database, Databases, Data Architecture, Data Dictionary, Data Files, Data Governance, Data Infrastructure, Data Integration, Extract Transform Load (ETL), Data Mart, Data Mining, Data Profiling, Data Security, Data Warehousing, Database Design, Dimensional Modeling, Meta-Data Management, Online Analytical Processing, NoSQL, Operational Data Store, Oracle (Applications), Power BI, Standard Sql, SQL Databases, Tableau (Software), Technical Data Management Systems, Data Storage Technologies, EHR Systems, System Availability, Snowflake, Indexer, Data Lakes, Information Technology, Data Lineage, Data Analytics, Performance Monitor, Data Management, Data Pipelines, Workday, Databricks
- **Published:** July 30, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=88c3de392f2ad8cf

## About the Role

The Senior Enterprise Data Warehouse Architect will demonstrate Shirley Ryan AbilityLab Core Attributes: Communication, Accountability, Flexibility/Adaptability, Judgment/Problem Solving, Customer Service and Core Values (Hope, Compassion, Discovery, Collaboration, & Commitment to Excellence) while fulfilling job duties., * Bachelors or Masters degree in Computer Science, Information Technology, or relevant field.

 * 8+ years of proven experience as an Enterprise Data Warehouse Architect role, preferably in an environment integrating data from medical EHR systems into Data warehouse / BI platforms
 * 8+ years of experience (as DBA or Data Warehouse Architect) with Snowflake and/or Oracle Autonomous Database (ADB)
 * 8 years of experience creating / leading data modeling activities for Data Warehouse or analytical solutions
 * In-depth understanding of database management systems (SQL & NOSQL) , online analytical processing (OLAP), and ETL (Extract, transform, load) frameworks.
 * Experience in data warehouse design (e.g. dimensional modeling), supporting multiple analytics outcomes (include Data Mining, AI and MLL)
 * Experience with modern BI / Information delivery technologies (e.g. Microsoft Power BI, Oracle OAS, Tableau Cloud).
 * Experience with modern Analytical Data management platforms (Snowflake, Databricks, Azure Fabric, etc..)
 * Familiar with common Data Warehouse architecture design strategies and appropriate application; including medallion, data Lake, data mart, ODS, etc
 * Experience integrating data from medical EHR systems, and Workday financial SAAS platform into Data warehouse / BI platforms
 * Working knowledge of SQL and NLQ data access techniques and methodologies
 * Excellent organizational and problem-solving abilities.
 * Experience leading analytical development programs

## Description

The Senior Enterprise Data Warehouse Architect is responsible for designing, implementing, and maintaining enterprise-level data & database designs, supporting data warehousing and advanced analytical solutions. This role translates strategic and tactical business information requirements into technical data warehouse architecture, implementable data models, and data pipeline strategies., Data Modeling & Design: Create and maintain physical databases, dimensional data models, schemas, and data dictionary documentation. Guide and oversee data modeling process, technologies, and outcomes

Data Architecture Strategy: Ensure database design(s) and implementation support strategic information needs of the organization, and maintain the Data Warehouse Data Roadmap

Performance & Security: Optimize data warehouse performance, perform data profiling, and ensure data quality, integrity, and security across platforms.

Collaboration: Work with Business Analysis, EDW platform Engineering, and IT teams to deliver high-performance analytics capabilities., * Responsible for the data architecture and database design of the Enterprise Data Warehouse, collaborating with other Data platform architects on the overall architecture of the data warehouse ecosystem.

 * Create logical and physical data models to support analytical needs of the organization, guide and oversee data modeling activities executed at a project or program level
 * Define data standards, naming conventions, and data architecture best practices.

Data Management & Optimization

 * Ensure data architecture supports all Data Sets (types), and maintains integrity across systems.
 * Optimize data storage, indexing, and query performance for analytical workloads.

Governance, Security & Compliance

 * Collaborate with Data Governance team to Implement data policies, including metadata management and data lineage tracking.
 * Ensure compliance with security, privacy, and regulatory requirements (e.g., GDPR, HIPAA depending on industry).

Collaboration & Stakeholder Alignment

 * Work closely with business analysts, data engineers, data scientists, and leadership to translate business needs into technical solutions.
 * Communicate architectural decisions and provide guidance to development teams.

Technology Evaluation & Innovation

 * Collaborate in the evaluation, testing, and recommendation of new tools, platforms, and technologies (cloud data warehouses, BI tools, ETL & MLL frameworks, etc.)
 * Stay current with trends in data architecture, cloud platforms, and big data technologies.

Performance Monitoring & Troubleshooting

 * Monitor data warehouse performance and resolve bottlenecks and/or data quality issues.
 * Ensure Data design reflects high availability, reliability, and scalability of the data warehouse environment.

Reporting Relationships

Reports directly to the Director of Data Platform Architecture


## Related Videos

- [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search)
- [Destigmatizing the Workplace: Building Real Inclusion](https://www.wearedevelopers.com/videos/1492-destigmatizing-the-workplace-building-real-inclusion)
- [Leveraging Real time data in FSIs](https://www.wearedevelopers.com/videos/806-leveraging-real-time-data-in-fsis)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Dynamic Entities in .NET: Building Low-Code Systems on Top of Entity Framework Core](https://www.wearedevelopers.com/videos/100218-dynamic-entities-in-net-building-low-code-systems-on-top-of-entity-framework-core)
- [The Future of Employee Wellbeing: Benefits, Trust & Performance](https://www.wearedevelopers.com/videos/1808-the-future-of-employee-wellbeing-benefits-trust-performance)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)