Lead Healthcare Data Warehouse Architect
3 days ago
The Mount Sinai Health System is seeking a highly skilled Lead Healthcare Data Warehouse Architect to join our Scientific Computing and Data group. As a key member of our team, you will design and oversee the implementation and testing of a scalable, high-availability, high-performance data warehouse.
The Mount Sinai Data Warehouse (MSDW) contains electronic health record data for over 11 million patients in the Mount Sinai Health System. This position enables the maximal sharing of data within Sinai and beyond with NIH-funded national research projects such as N3C and INSIGHT.
Responsibilities:- Design and oversee the implementation of Mount Sinai's research-oriented clinical data warehouse for researchers and clinicians.
- Oversee the ongoing operations, maintenance, and upgrades for data pipelines and ETL jobs for the integration of data from the Epic Caboodle into an Observational Medical Outcomes Partnership (OMOP) common data model database.
- Ensure that MSDW data is provided to on-premise self-service query tools such as Leaf, ATLAS, TriNetX, MS Power BI, and to national research projects such as INSIGHT and N3C.
- Maintain the confidentiality, privacy, and integrity of all healthcare data. Comply with all applicable laws, policies, and procedures, including those of the Institutional Review Board (IRB), Compliance, HIPAA, and New York State laws, and IT Security.
- Develop the standards, automated procedures, and documentation for database and ETL design, including management, monitoring, upgrades, quality control, and quality assurance and maintenance. Conduct peer code reviews. Create documentation.
- Establish the strategy for optimized database performance stored procedures, ETL jobs, and related scripts in coordination with the DBA.
- Serve as a technical mentor to team members. Act as a technical project leader. Work effectively with others Mount Sinai and beyond.
- Bachelor's degree in Computer Science or a related discipline.
- Eight years minimum experience in the design and administration of relational databases and ETL processes in diverse technological environments.
- Knowledge and experience of ETL development best practices: explicit source-to-target mappings; pattern-based and parameter-driven development; and rigorous version control. Strong knowledge of relational and dimensional data modeling principles and best practices. Experience with Microsoft SSIS, Visual Studio.
- Knowledge of database administration experience: database design and configuration; DDL and DML performance tuning using indexes, partitioning, materialized views, and other methods for improving query performance.
- Strong SQL development skills: stored procedures, functions, triggers, sequences, queries with advanced SQL. Microsoft T-SQL experience is required; hands-on experience with Oracle PL/SQL and/or PostgreSQL PL/pgSQL is a strong plus.
Experience working with healthcare data (electronic health records, medical and pharmacy claims, healthcare cost accounting systems). Experience with Epic Systems Corporation's Clarity and Caboodle reporting databases is strongly preferred.
Strength Through Diversity
The Mount Sinai Health System believes that diversity is a driver for excellence. We share a common devotion to delivering exceptional patient care. Yet we're as diverse as the city we call home - culturally, ethically, in outlook, and lifestyle.
When you join us, you become a part of Mount Sinai's unrivaled record of achievement, education, and advancement as we revolutionize medicine together.
We work hard to acquire and retain the best people, and to create a welcoming, nurturing work environment where you can develop professionally.
We share the belief that all employees, regardless of job title or expertise, can make an impact on quality patient care.
-
Lead Healthcare Data Warehouse Architect
7 days ago
New York, New York, United States mountsinai Full timeJob Title: Lead Healthcare Data Warehouse ArchitectAt Mount Sinai, we are seeking a highly skilled Lead Healthcare Data Warehouse Architect to join our team. As a key member of our Scientific Computing group, you will play a critical role in designing and overseeing the implementation of our research-oriented clinical data warehouse.Responsibilities:Design...
-
Lead Data Warehouse Architect
1 week ago
New York, New York, United States mountsinai Full timeJob Title: Lead Data Warehouse ArchitectWe are seeking a highly skilled Lead Data Warehouse Architect to join our team at Mount Sinai Health System. As a key member of our Scientific Computing group, you will be responsible for designing and overseeing the implementation of a scalable, high-availability, high-performance data...
-
Lead Data Warehouse Architect
6 days ago
New York, New York, United States mountsinai Full timeJob Title: Lead Data Warehouse ArchitectWe are seeking a highly skilled Lead Data Warehouse Architect to join our team at Mount Sinai Health System. As a key member of our Scientific Computing group, you will be responsible for designing and overseeing the implementation of a scalable, high-availability, high-performance data...
-
Lead Data Warehouse Architect
2 days ago
New York, New York, United States mountsinai Full timeLead Data Warehouse ArchitectThe Mount Sinai Health System is seeking a highly skilled Lead Data Warehouse Architect to join our Scientific Computing and Data group. As a key member of our team, you will design and oversee the implementation and testing of a scalable, high-availability, high-performance data warehouse.The Mount Sinai Data Warehouse (MSDW)...
-
Data Architect Lead
6 days ago
New York, New York, United States CTI DATA Full timeJoin Our Team of Data and Analytics ExpertsWe are seeking a highly skilled and experienced Data Architect Lead to join our team at CTI Data. As a key member of our team, you will be responsible for crafting modern data and analytics solutions for our Global 2000 customers.Key ResponsibilitiesLead the development of cloud data strategies and implementation...
-
New York, New York, United States VedaInfo Full timeData Warehouse Architect Job Description **Job Summary:** We are seeking a highly skilled Data Warehouse Architect with expertise in Greenplum and other DW Appliances to lead the design and implementation of a complex Data Warehouse solution. **Key Responsibilities:** * Architect a scalable and efficient Data Warehouse implementation using Greenplum and...
-
Data Warehouse Architect
23 minutes ago
New York, New York, United States Tech Tammina Full timeJob Title:Data Warehouse ArchitectLocation:NYC, NYExperience:14+ years in the IT industry, 8+ years working with US companies, 8+ years as a Data Architect/Engineer, 5+ years in a major banking or brokerage house environment, 6+ years with Informatica and Azure, 6+ years designing and implementing ETL processes, 4+ years with AWS, 7+ years of programming...
-
Data Warehouse Architect
2 days ago
New York, New York, United States Tech Tammina Full timeJob Title:Data Warehouse ArchitectLocation:NYC, NYExperience:14+ years in the IT industry, with 8+ years working with US companies in the US, and 8+ years as a Data Architect/Engineer. Recent experience (since 2015) in a major banking or brokerage house environment, with 6+ years of experience with Informatica and Azure.Key Responsibilities:Design and...
-
New York, New York, United States VedaInfo Full timeAbout the Role:We are seeking a highly skilled Data Warehouse Architect with expertise in Greenplum and other Data Warehouse Appliances to join our team at VedaInfo. As a key member of our team, you will be responsible for architecting complex Data Warehouse implementations that meet the evolving needs of our clients.Key Responsibilities:Design and implement...
-
Data Warehouse Architect
5 days ago
New York, New York, United States Tech Tammina Full timeJob Title: Data Warehouse ArchitectLocation: NYC, NYExperience:14+ years in the IT industry.8+ years working with US companies in the US.8+ years as a Data Architect/Engineer.5+ years of recent experience (since 2015) in a major banking or brokerage house environment.6+ years with Informatica and Azure.6+ years designing and implementing ETL processes using...
-
Data Warehouse Architect
3 weeks ago
New York, New York, United States Novisync Inc Full timeJob Description**About the Role**We are seeking an experienced Data Warehouse Architect to join our team at Novisync Inc. As a key member of our data team, you will be responsible for designing and developing scalable data warehouse solutions that meet the needs of our business.Key Responsibilities:Design and implement data warehouse architectures for...
-
Data Warehouse Architect
3 weeks ago
New York, New York, United States New York State Civil Service Full timeJob SummaryWe are seeking a highly skilled Data Warehouse Architect to join our team at New York State Civil Service. As a key member of our IT department, you will be responsible for designing and building data warehouse structures to support our reporting and analytic needs.Key ResponsibilitiesDesign and develop data warehouse structures to meet business...
-
New York, New York, United States VedaInfo Full timeAbout the Role:We are seeking a highly skilled Data Warehouse Architect with expertise in Greenplum and other Data Warehouse Appliances to join our team at VedaInfo. As a key member of our team, you will be responsible for architecting complex Data Warehouse implementations that meet the evolving needs of our clients.Key Responsibilities:Design and implement...
-
Data Architect
1 day ago
New York, New York, United States Chesapeake Corporation Full timeJob Title: Data and Business Intelligence ArchitectWe are seeking a highly skilled Data and Business Intelligence Architect to join our team at Chesapeake Utilities Corporation. As a key member of our organization, you will be responsible for designing, creating, and managing our data architecture.About the Role:The Data and Business Intelligence Architect...
-
Data Architect Lead
2 weeks ago
New York, New York, United States Dexian - Signature Consultants Full timeJob SummaryDexian - Signature Consultants is seeking a highly skilled Data Architect Lead to join our team in New York, NY.This is a unique opportunity to drive the standards for Data Quality across multiple data-sets and drive for data trust across the enterprise.Key ResponsibilitiesUnderstand the data landscape and how it is used in business...
-
New York, New York, United States VedaInfo Full timeJob Summary: We are seeking a highly skilled Data Warehouse Architect with expertise in Greenplum to lead the design and implementation of complex DW solutions. The ideal candidate will have 10-12 years of experience in DW architecture and a strong understanding of DW appliances.Key Responsibilities: * Design and implement DW solutions using Greenplum *...
-
Data Architect Lead
6 days ago
New York, New York, United States Dexian - Signature Consultants Full timeJob SummaryDexian - Signature Consultants is seeking a highly skilled Data Architect Lead to join our team in New York, NY.About the RoleDevelop and maintain data architecture standards across multiple data sets to ensure data trust and quality.Collaborate with business partners to define data-driven solutions that drive business growth.Lead the evaluation...
-
Senior Data Warehouse Architect
1 week ago
New York, New York, United States Comprehensive Resources Inc Full timeJob Title: Senior Data Warehouse EngineerWe are seeking a highly skilled Senior Data Warehouse Engineer to join our team at Comprehensive Resources Inc. As a key member of our Information Technology department, you will play a vital role in designing and building an enterprise data warehouse.Key Responsibilities:Design and develop data warehouse solutions at...
-
Cloud Data Warehouse Specialist
3 weeks ago
New York, New York, United States Genesis10 Full timeAbout the RoleGenesis10 is seeking a highly skilled Snowflake Data Architect to join our team for a 3-month consulting engagement with a leading consumer finance lender firm. The ideal candidate will have a strong background in designing, developing, and maintaining data architectures, data models, and standards for various data integration and data...
-
Cloud Data Architect/Engineer
3 weeks ago
New York, New York, United States Oakridge Staffing Full timeJob Summary: Oakridge Staffing is seeking a highly skilled Senior Data Architect/Engineer to join our team and lead the development of a cloud-based data function and team. The ideal candidate will have experience in designing and implementing data pipelines, data warehousing, and data governance.About the Role: As a Senior Data Architect/Engineer, you will...
