← Back to jobsJob ID col-cmvv5apm004lz42b9eekyocjw

Mount Sinai Health SystemPosted 30+ days ago

Lead Data Warehouse Engineer - Artificial Intelligence-Ready Mount Sinai (AIR.MS)

Full-time
On-site
12–15 years
$145K – $218K/yr
Posted 30+ days ago

Mount Sinai Health System is a leading academic medical institution that partners with scientists and clinicians to enhance scientific discovery. The Lead Data Warehouse Engineer will be responsible for integrating multi-modal clinical data into the AIR.MS data warehouse, leading technical efforts, and collaborating with various teams to expand AIR.MS functionality.

Posted
30+ Days Ago
Source
careers.mountsinai.org
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • Design databases and pipelines that balance functionality, performance, cost, and development time; evaluate technical options with the product manager
  • Design, build, test, and maintain data pipelines that extract/capture data from source systems, transform and augment those data, and integrate it into a multi-modal data repository
  • Serve as a team leader; contribute to project planning, work breakdown, dependency sequencing, and release management
  • Develop and promote standards, conventions, design patterns, DevOps/SDLC best practices, and operational procedures for pipelines and warehouse maintenance
  • Mentor junior engineers in data warehousing, data engineering skills, and operational support
  • Design, build, and maintain data management processes, including loading flat files (csv, tsv, pipe-delimited, JSON)
  • Lead design sessions, code walkthroughs, peer reviews, and produce technical documentation
  • Tune database objects, stored procedures, and pipelines to optimize performance and minimize compute and storage costs
  • Monitor database and pipeline operations; lead troubleshooting and remediation of failures; provide occasional after-hours on-call support
  • Collaborate with DBAs and system administrators on backups, performance tuning, statistics/index maintenance, and patching
  • Provide high-quality customer service to researchers, clinicians, and internal partners; maintain a science‑driven, customer-focused approach
  • Ensure patient privacy and data security in compliance with IRB & cybersecurity policies, HIPAA, 42 CFR Part 2, NYS Article 27-F, and other regulations
  • Stay current with emerging technologies to improve capabilities, efficiency, quality, or cost
  • Identify improvements in procedures, technology, compliance, and data privacy/security
  • Periodically assist DBAs with user provisioning, backups, restorations, capacity planning, and performance monitoring
  • Perform related duties as assigned

Qualifications

  • Bachelors degree in a technical discipline; Masters degree preferred
  • 12-15 years preferred of related experience, including 7 years of experience designing, developing, and maintaining relational databases, data pipelines, and dimensional/OLAP warehouses

Preferred

  • Expert knowledge of data warehousing: 3NF & dimensional modeling (fact table types, SCDs), change data capture, incremental loads, data lineage, source-to-target mappings, pattern-based & parameter-driven development
  • Experience working with healthcare data
  • Expert-level experience with data engineering technologies: SQL, indexing, stored procedures, UDFs, sequences, dynamic SQL, data transformation tools, job orchestration tools for data processing
  • Experience with DevOps/SDLC best practices; Agile (Scrum, Kanban) with JIRA and Confluence; version control with git
  • Strong communication and customer service skills for working with researchers, clinicians, administrators, and IT staff
  • Excellent critical thinking, problem-solving, multitasking, and collaboration skills; ability to work independently in a fast-paced environment
  • Preferred experience with healthcare data (EHR, billing/claims, cost accounting), Epic Clarity/Caboodle, data models (OMOP, i2b2, PCORnet)
  • Experience with database administration: configuration, performance tuning, partitioning, materialized views, permissions, backups & restorations
  • Knowledge of Hadoop, Spark, Kafka and other big data technology stacks and streaming tools
  • Source-to-target mappings
  • Healthcare data experience
  • Version control with git
  • EHR experience
  • Billing/claims experience
  • Cost accounting experience
  • Big data technology stacks

Required skills

3NF ModelingAgile MethodologiesBackupsBig Data TechnologiesBillingChange Data CaptureClaims DataConfluenceCost Accounting DataCustomer ServiceData LineageData Transformation ToolsData WarehousingDatabase Administration

Full job description

Mount Sinai Health System is a leading academic medical institution that partners with scientists and clinicians to enhance scientific discovery. The Lead Data Warehouse Engineer will be responsible for integrating multi-modal clinical data into the AIR.MS data warehouse, leading technical efforts, and collaborating with various teams to expand AIR.MS functionality.

Responsibilities

  • Design databases and pipelines that balance functionality, performance, cost, and development time; evaluate technical options with the product manager
  • Design, build, test, and maintain data pipelines that extract/capture data from source systems, transform and augment those data, and integrate it into a multi-modal data repository
  • Serve as a team leader; contribute to project planning, work breakdown, dependency sequencing, and release management
  • Develop and promote standards, conventions, design patterns, DevOps/SDLC best practices, and operational procedures for pipelines and warehouse maintenance
  • Mentor junior engineers in data warehousing, data engineering skills, and operational support
  • Design, build, and maintain data management processes, including loading flat files (csv, tsv, pipe-delimited, JSON)
  • Lead design sessions, code walkthroughs, peer reviews, and produce technical documentation
  • Tune database objects, stored procedures, and pipelines to optimize performance and minimize compute and storage costs
  • Monitor database and pipeline operations; lead troubleshooting and remediation of failures; provide occasional after-hours on-call support
  • Collaborate with DBAs and system administrators on backups, performance tuning, statistics/index maintenance, and patching
  • Provide high-quality customer service to researchers, clinicians, and internal partners; maintain a science‑driven, customer-focused approach
  • Ensure patient privacy and data security in compliance with IRB & cybersecurity policies, HIPAA, 42 CFR Part 2, NYS Article 27-F, and other regulations
  • Stay current with emerging technologies to improve capabilities, efficiency, quality, or cost
  • Identify improvements in procedures, technology, compliance, and data privacy/security
  • Periodically assist DBAs with user provisioning, backups, restorations, capacity planning, and performance monitoring
  • Perform related duties as assigned

Preferred

  • Expert knowledge of data warehousing: 3NF & dimensional modeling (fact table types, SCDs), change data capture, incremental loads, data lineage, source-to-target mappings, pattern-based & parameter-driven development
  • Experience working with healthcare data
  • Expert-level experience with data engineering technologies: SQL, indexing, stored procedures, UDFs, sequences, dynamic SQL, data transformation tools, job orchestration tools for data processing
  • Experience with DevOps/SDLC best practices; Agile (Scrum, Kanban) with JIRA and Confluence; version control with git
  • Strong communication and customer service skills for working with researchers, clinicians, administrators, and IT staff
  • Excellent critical thinking, problem-solving, multitasking, and collaboration skills; ability to work independently in a fast-paced environment
  • Preferred experience with healthcare data (EHR, billing/claims, cost accounting), Epic Clarity/Caboodle, data models (OMOP, i2b2, PCORnet)
  • Experience with database administration: configuration, performance tuning, partitioning, materialized views, permissions, backups & restorations
  • Knowledge of Hadoop, Spark, Kafka and other big data technology stacks and streaming tools
  • Data warehousing
  • 3NF modeling
  • Dimensional modeling
  • Change data capture
  • Incremental loads
  • Data lineage
  • Source-to-target mappings
  • Pattern-based development
  • Parameter-driven development
  • Healthcare data experience
  • SQL
  • Indexing
  • Stored procedures
  • UDFs
  • Dynamic SQL
  • Data transformation tools
  • Job orchestration tools
  • DevOps best practices
  • Agile methodologies
  • JIRA
  • Confluence
  • Version control with git
  • EHR experience
  • Billing/claims experience
  • Cost accounting experience
  • Epic Clarity
  • Epic Caboodle
  • Data models
  • Database administration
  • Configuration
  • Performance tuning
  • Partitioning
  • Materialized views
  • Permissions
  • Backups
  • Restorations
  • Hadoop
  • Spark
  • Kafka
  • Big data technology stacks
  • Streaming tools
  • communication
  • Customer service
  • Critical thinking
  • Problem-solving
  • Multitasking
  • Collaboration
  • work independently

Company

  • Integrated health system providing care, research, and medical education
  • New York, New York, USA
  • https://www.mountsinai.org/
  • Founded in 2013
  • 10001+ employees

Qualifications

  • Bachelors degree in a technical discipline; Masters degree preferred
  • 12-15 years preferred of related experience, including 7 years of experience designing, developing, and maintaining relational databases, data pipelines, and dimensional/OLAP warehouses
  • Expert knowledge of data warehousing: 3NF & dimensional modeling (fact table types, SCDs), change data capture, incremental loads, data lineage, source-to-target mappings, pattern-based & parameter-driven development
  • Experience working with healthcare data
  • Expert-level experience with data engineering technologies: SQL, indexing, stored procedures, UDFs, sequences, dynamic SQL, data transformation tools, job orchestration tools for data processing
  • Experience with DevOps/SDLC best practices; Agile (Scrum, Kanban) with JIRA and Confluence; version control with git
  • Strong communication and customer service skills for working with researchers, clinicians, administrators, and IT staff
  • Excellent critical thinking, problem-solving, multitasking, and collaboration skills; ability to work independently in a fast-paced environment
  • Preferred experience with healthcare data (EHR, billing/claims, cost accounting), Epic Clarity/Caboodle, data models (OMOP, i2b2, PCORnet)
  • Experience with database administration: configuration, performance tuning, partitioning, materialized views, permissions, backups & restorations
  • Knowledge of Hadoop, Spark, Kafka and other big data technology stacks and streaming tools
  • 12-15 years preferred of related experience, including 7 years of experience designing, developing, and maintaining relational databases, data pipelines, and dimensional/OLAP warehouses.

Required skills

  • 3NF Modeling, Agile Methodologies, Backups, Big Data Technologies, Billing, Change Data Capture, Claims Data, Confluence, Cost Accounting Data, Customer Service, Data Lineage, Data Transformation Tools, Data Warehousing, Database Administration, Database Configuration, DevOps, Dimensional Modeling, Dynamic SQL, Electronic Health Records (EHR), Epic Caboodle, Epic Clarity, Git, Hadoop, Healthcare Data, Incremental Loads, Indexing, JIRA, Job Orchestration Tools, Kafka, Kanban, Materialized Views, OMOP Data Model, PCORnet Data Model, Parameter-Driven Development, Partitioning, Pattern-Based Development, Performance Tuning, Permissions Management, Restorations, SQL, Scrum, Sequences, Software Development Life Cycle (SDLC), Source-to-Target Mappings, Spark, Stored Procedures, Streaming Tools, User Defined Functions (UDFs), Version Control, i2b2 Data Model

Preferred skills

  • Experience working with healthcare data

Experience

  • 12-15 years

Job details

Employment type

Full-time

Seniority level

12–15 years

Date posted

May 11, 2026

Work mode

On-site

Job source

careers.mountsinai.org

Company

Mount Sinai Health System

Information Technology & AI

Integrated health system providing care, research, and medical education

See all 17 jobs from Mount Sinai Health System →
  • New York, New York, USA
  • Information Technology & AI
  • 10001+ employees
  • Founded 2013
  • mountsinai.org

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Warehouse Engineer jobs in New York

Apexon

1d ago

New

Data Warehouse and BI Maintenance and Operations Engineer

Full-timeRemoteUnited StatesCompetitive

Apexon is hiring a Data Warehouse and BI Maintenance and Operations Engineer to support the data lake, data warehouse, and reporting layer of a Medicaid Analytics platform.

Why similarSame roleRemote

Amazon

1d ago

New

Business Intelligence Engineer II, Amazon Global Logistics

Full-timeOn-siteBellevue, WA$100K – $160K/yr

Amazon hires a Business Intelligence Engineer II to support Sales, Marketing, and Pricing analytics for Global Logistics.

Why similarSame roleData Warehousing

American Heart Association

1d ago

New

Data Warehouse Developer

Full-timeRemoteUnited States$95K – $115K/yr

The American Heart Association is hiring a Data Warehouse Developer to build and maintain data integration architectures, models, and pipelines for its Precision Medicine Platform.

Why similarSame roleRemote

Get new Data Warehouse Engineer jobs in New York by email

Create job alert

Lead Data Warehouse Engineer - Artificial Intelligence-Ready Mount Sinai (AIR.MS)

Mount Sinai Health System · $145K – $218K/yr

Apply on company site