Senior Data Warehouse Architect

🔥 10 minutes ago

🇺🇸 United States – Remote

💵 $110.8k - $184k / year

⏰ Full Time

🟠 Senior

🚰 Data Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Shirley Ryan AbilityLab

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

🏥 Healthcare

🧬 Biotechnology

💰 Grant on 2023-07

Healthcare • Biotechnology

Shirley Ryan AbilityLab is the global leader in physical medicine and rehabilitation for adults and children with severe and complex conditions, including traumatic brain and spinal cord injuries, stroke, amputation, and cancer-related impairments. Formerly known as the Rehabilitation Institute of Chicago, it has been ranked as the No. 1 Rehabilitation Hospital in America since 1991. Opened in March 2017, the AbilityLab features a unique translational care model where clinicians, scientists, innovators, and technologists collaborate in a single space to advance patient recovery through real-time application of research. The organization is committed to fostering an inclusive environment that values diversity and equity, and emphasizes a culture of innovation, curiosity, and compassion.

📋 Description

• 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. • Ensure data architecture supports all Data Sets (types), and maintains integrity across systems. • Optimize data storage, indexing, and query performance for analytical workloads. • 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). • 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. • 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. • 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.

🎯 Requirements

• 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.

🏖️ Benefits

• Comprehensive benefits program that is competitive with our industry peers in our geographic locations.