Data Integration Engineer II — ETL & Cloud Pipelines

Weill Cornell Medicine; New York (NY); On-site; USD 130,000 - 143,000; Full time

Job summary

Weill Cornell Medicine is seeking a Data Integration Engineer II (CEMI) for a 2-year term appointment in NYC, focusing on designing, developing, and maintaining data integration pipelines across enterprise systems and cloud platforms. The role emphasizes ETL/ELT development, data modeling, and data movement to support analytics and reporting.

The position requires strong SQL skills, experience with SAP data platforms, and the ability to work across on-premise and cloud environments, including

Qualifications

• Minimum 8-10 years of hands-on experience in data integration and data engineering.
• Experience with SAP data platforms including SAP BW and/or SAP BODS.
• Experience with cloud data warehouse technologies such as Amazon Redshift.
• Experience with ETL/ELT tools such as Informatica.
• Hands-on experience in data modeling and backend data structures.
• Strong SQL development skills including queries, scripting, and stored procedures.
• Experience with job scheduling, monitoring, and batch processing.
• Exposure to multiple data environments (on-premise and cloud) preferred.

Responsibilities

• Design and develop ETL/ELT pipelines to integrate data from multiple source systems into enterprise data platforms.
• Build and maintain backend data models to support reporting, analytics, and operational use cases.
• Develop and optimize data movement processes using tools such as SAP BODS, Informatica, and cloud-native services.
• Support multiple technology stacks including SAP BW and cloud environments such as Amazon Redshift.
• Perform data transformation, cleansing, and validation to ensure data quality and integrity.
• Monitor, schedule, and troubleshoot batch jobs and data pipelines to ensure reliable system performance.
• Analyze data integration issues and implement solutions to improve performance and scalability.
• Collaborate with business analysts and developers to translate requirements into technical data solutions.
• Document data flows, data models, and technical specifications for maintainability and governance.
• Provide support for production issues and participate in system enhancements and continuous improvement initiatives.

Skills

ETL/ELT

Data modeling

SQL development

Batch processing

SAP

Education

Bachelor's Degree in Computer Science or related field

Tools

SAP BW

SAP BODS

Informatica

Amazon Redshift

Job description

Weill Cornell Medicine is seeking a Data Integration Engineer II (CEMI) for a 2-year term appointment in NYC, focusing on designing, developing, and maintaining data integration pipelines across enterprise systems and cloud platforms. The role emphasizes ETL/ELT development, data modeling, and data movement to support analytics and reporting.

The position requires strong SQL skills, experience with SAP data platforms, and the ability to work across on-premise and cloud environments, including