Director Data Warehouse Jobs in Romeoville, IL (NOW HIRING)

Shirley Ryan AbilityLab is the global leader in physical medicine and rehabilitation for adults and children with the most severe, complex conditions. By joining our team, you’ll be part of our life-changing mission and vision. You’ll contribute to an innovative, multifaceted culture that is second to none — one that embraces collaboration, excellence, discovery and compassion. You’ll play a role in something that’s never been done before as we integrate science and clinical care to help patients achieve better, faster outcomes — as we Advance Human Ability, together.Job Description SummaryThe 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.Key Responsibilities:Data Modeling & Design: Create and maintain physical databases, dimensional data models, schemas, and data dictionary documentation. Guide and oversee data modeling process, technologies, and outcomesData Architecture Strategy: Ensure database design(s) and implementation support strategic information needs of the organization, and maintain the Data Warehouse Data RoadmapPerformance & 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.The Senior Enterprise Data Warehouse Architect will consistently demonstrate support of the Shirley Ryan AbilityLab statement of Vision, Mission and Core Values by striving for excellence, contributing to team efforts and showing respect and compassion for patients and their families, fellow employees and all others with whom there is contact at or in the interest of the institute.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.Job DescriptionThe Senior Enterprise Data Warehouse Architect will:Design & ArchitectureResponsible 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 levelDefine data standards, naming conventions, and data architecture best practices.Data Management & OptimizationEnsure data architecture supports all Data Sets (types), and maintains integrity across systems.Optimize data storage, indexing, and query performance for analytical workloads. Governance, Security & ComplianceCollaborate 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 AlignmentWork 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 & InnovationCollaborate 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 & TroubleshootingMonitor 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 RelationshipsReports directly to the Director of Data Platform ArchitectureKnowledge, Skills & Abilities RequiredBachelors 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 platforms8+ 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 solutionsIn-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, etcExperience integrating data from medical EHR systems, and Workday financial SAAS platform into Data warehouse / BI platformsWorking knowledge of SQL and NLQ data access techniques and methodologiesExcellent organizational and problem-solving abilities.Experience leading analytical development programsWorking ConditionsNormal office environment with little or no exposure to dust or extreme temperature.The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of personnel so classified.Pay and Benefits*:Pay Range:$110,800.00 - $184,000.00Benefits:Shirley Ryan AbilityLab offers a comprehensive benefits program that is competitive with our industry peers in our geographic locations: https://www.sralab.org/benefits*Benefits and benefits’ eligibility can vary by position. Actual compensation will be determined by equity and qualifications of the role.Equal Employment Opportunity EmployerShirley Ryan AbilityLab is an Equal Employment Opportunity Employer. All applicants will be afforded equal employment opportunity without discrimination because of race, color, religion, sex, marital status, national origin or ancestry, citizenship status, age, disability, sexual orientation, gender identity, genetic information, military status, order of protection status, unfavorable discharge from military service, or any other characteristics protected by law.EEO is the Law | EEO is the Law - Know Your Rights | View our Full PolicyShirley Ryan AbilityLab is an Affirmative Action Employer as required by law. #J-18808-Ljbffr