Lead Data Warehouse Engineer - Artificial Intelligence-Ready Mount Sinai (AIR.MS)
Tasks
- Assess state of data integration
- Collaborate on backups performance tuning statistics index maintenance patching
- Design build test maintain data pipelines for source capture transformation integration
- Design databases and pipelines for functionality performance cost
- Develop and promote data pipeline warehouse standards conventions design patterns
- Develop plan to integrate metadata and data
- Ensure patient privacy and data security compliance
- Lead design sessions code walkthroughs peer reviews technical documentation
- Lead integration of multi modal clinical data into data warehouse
- Lead project planning work breakdown dependency sequencing release management
- Load and manage flat files csv tsv pipe delimited json
- Mentor junior engineers
- Monitor database and pipeline operations troubleshoot remediate failures
- Provide after hours on call support when needed
- Tune database objects stored procedures and pipelines for performance cost
Perks/Benefits
Skills/Tech-stack
3NF | Agile | Change Data Capture | Confluence | Data Capture | Data Lineage | Data Pipelines | Data Transformation | Data Warehouse | DevOps | Dimensional Modeling | Dynamic SQL | Git | Incremental loads | Indexing | Jira | Job orchestration | Kanban | MySQL | SAP HANA | SDLC | SQL | Scrum | Stored Procedures | UDFs
Education
Related jobs
-
Cognos Analytics | Control-M | DB2 | Database Administration | ETLRemote workSenior-level ContractLincoln, United States R4h ago
-
Data Engineer USD 148K-263KAPI | Apache Kafka | Apache Spark | Cassandra | Distributed SystemsDisability insurance | Health insurance | Holiday pay | Learning and development | Life insuranceMid-level Full TimeUSA-Remote Work R4h ago
-
Software Engineer - AI Agent Memory Infrastructure USD 156K-316KConflict Resolution | Data Compression | Data Ingestion | Data Modeling | Data StorageMid-level Full TimeSan Jose, California, United States4h ago
-
GenAI Engineer USD 93K-163KAWS Bedrock | Agentic Workflows | C++ | CI/CD | CohereHealth and wellness benefits | Mentorship | Professional developmentEntry-level Full TimeArlington/Rosslyn, Virginia, United States5h ago
-
Senior GenAI Engineer USD 102K-171KAPI Development | AWS Bedrock | Agentic Workflows | CI/CD | CohereSenior-level Full TimeArlington/Rosslyn, Virginia, United States5h ago
-
Data Scientist - Platform Infrastructure USD 127K-189KData Governance | Data Modeling | Data Pipelines | Data Quality | ETLMid-level Full TimeLos Angeles, California, United States5h ago
-
C++ | Data Compression | Data Ingestion | Data Processing | Data StorageSenior-level Full TimeSan Jose, California, United States5h ago
-
Computer Vision | Data Pipelines | Language Models | Language Processing | Large Language ModelsSenior-level Full TimeBellevue, WA | Menlo Park, CA6h ago
-
Senior Software Engineer, Cloud Databases USD 174K-252KAnalytical processing | Benchmarking | C++ | Cloud Databases | Cloud platformSenior-level Full TimeKirkland, WA, USA6h ago
-
C++ | Clustering | Data Pipelines | Data Processing | DebuggingSenior-level Full TimeMountain View, CA, USA6h ago
-
Principal Engineer, Data Protection USD 307K-427KArtificial Intelligence | Data Protection | Data Transformation | Data labeling | Machine LearningSenior-level Full TimeSunnyvale, CA, USA; New York, NY, …6h ago
-
Data Engineer, Global Business and Operations USD 130K-187KBigQuery | Data Governance | Data Marts | Data Modeling | Data PipelinesMid-level Full TimeNew York, NY, USA6h ago
-
Data Engineer USD 110K-110KAutomated testing | Data Architecture | Data Modeling | Data Security | Data VisualizationMid-level Full TimeAnnapolis, MD, US8h ago
-
Staff Software Engineer - Data Query USD 191K-224KAgile | Automated testing | Big Data | C++ | Data StructuresSenior-level Full TimeUnited States, Remote R13h ago
-
ArcGIS Pro | Arcpy | Bokeh | Dash | GDAL401k | Dental insurance | Health insurance | Vision insuranceSenior-level Full TimeFayetteville, North Carolina, United States16h ago
-
ArcGIS Pro | Arcpy | Bokeh | Dash | GDAL401k | Dental insurance | Health insurance | TS/SCI clearance | Vision insuranceSenior-level Full TimeSneads Ferry, North Carolina, United States16h ago
-
Data Engineer - Mid-Level USD 130K-160KAirflow | Automated Deployment | Automated testing | CI/CD | Control workflows401k matching | Dental insurance | Health insurance | Lunch and snacks provided | Maternity & paternity leaveMid-level Full TimeEl Segundo, California, United States16h ago
-
Staff Engineer, Machine Learning USD 196K-269KCamera | Computer Vision | Convolutional Neural Networks | DETR | Deep Neural Networks401k employer match | Dental insurance | Life insurance | Long-term disability | Medical insuranceSenior-level Full TimeMountain View, CA16h ago
-
Software Engineer – Surgical Robot Manufacturing USD 127K-192KAutomated testing | Control Systems | HTML | JSON | JavaScriptMid-level Full TimeSunnyvale, CA, United States17h ago
-
Senior Data Engineer - Logistics USD 38K-38KBig Data | Cloud Computing | Cloud Cost Optimization | Column-Level Security | Cost Optimization401k plan | Dental insurance | Health insurance | Life insurance | Paid time offSenior-level Full TimeSpringdale, AR Terminal Office - Springdale, …17h ago
-
Data Engineer USD 127K-170KAzure Data | Azure Data Factory | Azure Data Lake | Azure Data Lake Storage | Azure DevOpsCareer advancement | Flexible work environment | Professional development | Recognition | Work-life balanceSenior-level Full TimeTampa, FL, USA, United States17h ago
-
Data Reliability Engineer USD 87K-123KAWS | Alerting | Amazon DynamoDB | Amazon EMR | Amazon Kinesis401k matching | Dental insurance | Employee resource groups | Flexible work environment | Health insuranceMid-level Full TimeKS Overland Park, United States17h ago
-
Big Data | Cloud Cost Optimization | Cost Optimization | Data Architecture | Data Governance401k plan | Dental insurance | Health insurance | Life insurance | Paid time offMid-level Full TimeSpringdale, AR Terminal Office - Springdale, …17h ago
-
Senior Data Engineer (Apache Spark, NiFi, SQL) USD 140K-231KApache NiFi | Apache Spark | Hadoop | Java | Netezza401k match | Fitness reimbursement | Paid sick and safe time | Paid vacation | Tuition reimbursementSenior-level Full TimeO'Fallon, Missouri (Main Campus), United States17h ago
-
AWS | Amazon Redshift | Amazon S3 | Apache Airflow | Bitbucket401k match | Dental insurance | Employee assistance program | Flexible work/life support | Health insuranceSenior-level Full TimeBOSTON, United States17h ago