Data Integration Engineer II - AWS & Redshift

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 to design, develop, and maintain data integration pipelines across enterprise systems and cloud platforms. You will work on ETL/ELT development, data modeling, and data movement to support analytics and reporting, with exposure to SAP and Redshift environments.

The role is a term position anticipated through Fall 2028, with responsibilities spanning data transformation, quality, and governance.

Qualifications

• Bachelor's degree in computer science or related field preferred.
• Equivalent work experience will be considered.
• 8–10 years of hands-on data integration/engineering experience preferred.
• Experience with SAP data platforms including SAP BW and SAP BODS.
• Experience with cloud data warehouses such as Amazon Redshift.
• Strong SQL development and data modeling skills.

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 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

SQL development

Data modeling

Data pipelines

Analytical skills

Education

Bachelor's Degree in Computer Science

Equivalent work experience

Tools

SAP BW

SAP BODS

Informatica

Amazon Redshift

Job description

Weill Cornell Medicine is seeking a Data Integration Engineer II to design, develop, and maintain data integration pipelines across enterprise systems and cloud platforms. You will work on ETL/ELT development, data modeling, and data movement to support analytics and reporting, with exposure to SAP and Redshift environments.

The role is a term position anticipated through Fall 2028, with responsibilities spanning data transformation, quality, and governance.