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
-
Senior-level Contract Full TimeReston, VA, United States10h ago
-
Senior Data Engineer (Remote) USD 155KAgile | Apache Spark | BigQuery | Cassandra | Data Governance401k match | Dental insurance | Employee assistance program | Employee stock purchase plan | Flexible scheduleSenior-level Full TimeWork From Home, United States R13h ago
-
Mid-level Full TimeUS-Kansas-Wichita16h ago
-
Senior-level Full TimeCincinnati, OH, United States17h ago
-
Acceptance Testing | Data Analysis | Data Visualization | Data reporting | ExcelOn site work authorizationSenior-level Full TimeArlington/Rosslyn, Virginia, United States17h ago
-
Delivery Senior Consultant, Data Engineering and Gen AI USD 119K-208K.NET | AWS | Agentic AI | Agile | AngularSenior-level Full TimeGilbert, Arizona, United States; Lake Mary, …17h ago
-
Software Engineer/Researcher, AI-Native Database Systems USD 156K-387KC++ | Database Architecture | Distributed Systems | Indexing | Information RetrievalSenior-level Full TimeSan Jose, California, United States17h ago
-
Data Pipelines | Data Storage | Distributed Systems | High Performance | High-Performance ComputingCareer growthEntry-level Full TimeSan Jose, California, United States17h ago
-
Agent architecture | Backend Development | Document ingestion | Frontend Development | IndexingCross-functional collaboration | Hands-on experience | MentorshipEntry-level InternshipSan Jose, California, United States17h ago
-
Apache Flink | Apache Spark | Automation | C++ | Cause analysisSenior-level Full TimeSan Jose, California, United States17h ago
-
Agentic data | Apache Hive | Apache Spark | Coding Data | Data CurationSenior-level Full TimeMenlo Park, CA18h ago
-
Cloud Data and AI Engineer, Professional Services USD 127K-183KBigtable | C++ | Cloud Databases | Cloud SQL | Cloud platformTravel up to 30%Mid-level Full TimeReston, VA, USA18h ago
-
Research Engineer, Benchmarking, Robotics, DeepMind USD 147K-211KBenchmarking | Data Pipelines | Deep learning | Docker | Embedded deploymentMid-level Full TimeMountain View, CA, USA18h ago
-
Data Engineer USD 123K-151KC++ | Cloud platform | Data Migration | Data Modeling | Data PartitioningBenefits | Hybrid scheduleMid-level Full TimeAustin, TX, USA R18h ago
-
Staff Software Engineer USD 264K-300KAdversarial Testing | Algorithm Design | C++ | Data Pipelines | Data StructuresBonus | Equity | Hybrid scheduleSenior-level Full TimeMountain View, CA, USA R18h ago
-
Senior Software Engineer, Spam and Abuse, AI/ML USD 174K-253KAPI Development | Algorithms | Continuous Deployment | Continuous Training | Data ProcessingSenior-level Full TimeSan Jose, CA, USA18h ago
-
Staff Software Engineer, Cloud SQL, MySQL USD 207K-301KArtificial Intelligence | Cloud Platforms | Data Structures | Data Structures and Algorithms | Database DesignEmployee stock purchase | Health insurance | Paid time off | Retirement plansSenior-level Full TimeSunnyvale, CA, USA18h ago
-
Data Engineer I - API USD 152K-220KAlteryx | Business Control Systems Integration | Business control | Clean | Control systems integration401k contribution | Dental insurance | Disability insurance | Employee referral awards | Health insuranceMid-level Full TimeClayton, NC, US21h ago
-
Senior Machine Learning Engineer, Ad Serving USD 195K-408KContinuous Improvement | Deep learning | Experimentation | Feature Engineering | JavaDisability benefits | Equity awards | Health insurance | Life insurance | Paid time offSenior-level Full TimeNew York, New York1d ago
-
Senior Machine Learning Engineer, Ad Serving USD 195K-352KContinuous Improvement | Deep learning | Distributed Systems | Experimentation | Feature EngineeringCommuter benefits | Dental insurance | Disability benefits | Equity awards | Health insuranceSenior-level Full TimeBoston, Massachusetts1d ago
-
Lead Analytics Engineer USD 123K-175KCI/CD | DBT | Data Governance | Data Modeling | NetsuiteFull-time telecommuting | Remote work optionSenior-level Full TimePalo Alto, California1d ago
-
Staff Software Engineer, AI Data Platform USD 250K-280KCloud platform | Google Cloud | Google Cloud Platform | GraphQL | KafkaSenior-level Full TimeSan Francisco Bay Area R1d ago
-
Cloud Network Engineer III (Anchorage, Alaska) USD 110K-149KAgile | Aruba | Bandwidth Planning | Cisco | Continuous DeliverySenior-level Full TimeAnchorage, AK, United States1d ago
-
Sr. Software Development Engineer, MLOPs USD 168K-227KAlerting | Amazon EKS | CI/CD | Checkpointing | Data IngestionSenior-level Full TimeBellevue, Washington, USA1d ago
-
Software Development Engineer, Aurora Storage USD 143K-194KAWS | Amazon Aurora | Distributed Systems | High Availability | MySQLCareer growth | Flexible work schedule | Mentorship | Work-life balanceMid-level Full TimeRedmond, Washington, USA1d ago