Data Integration Engineer II- SAP BW (CEMI)- 2 Year Term Appointment

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

Job summary

Weill Cornell Medicine-Qatar is seeking an Data Integration Engineer II specializing in SAP BW to design, develop, and maintain backend data pipelines across enterprise systems and cloud platforms. You will focus on ETL/ELT development, data modeling, and data movement to support analytics and reporting.

The role requires 8–10 years of hands-on data integration experience, working with SAP BW/BODS and cloud warehouses like Amazon Redshift.

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 or data engineering experience.
• 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.
• 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 for reliability.
• Analyze data integration issues and implement scalable improvements.
• 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 production support and participate in system enhancements.

Skills

SQL development

Data modeling

ETL/ELT concepts

Analytical thinking

Communication skills

Education

Bachelor's degree in CS/related field

Tools

SAP BW

SAP BODS

Informatica

Amazon Redshift

Job description

Title: Data Integration Engineer II- SAP BW (CEMI)- 2 Year Term Appointment

Location: Midtown

Work Days:

Weekly Hours:35.00

Exemption Status:Exempt

Salary Range:$130,300.00-$143,300.00

*As required under NYC Human Rights Law Int 1208-2018 - Salary range for this role when Hired for NYC Offices

Position Summary

The Data Integration Engineer II is responsible for designing, developing, and maintaining data integration solutions and backend data pipelines across enterprise systems and cloud platforms. This role focuses on ETL/ELT development, data modeling, and data movement to support analytics and reporting. The position works independently on moderately complex tasks and supports multiple technologies including SAP and cloud data warehouses.

This is a term position anticipated to be needed through Fall 2028 but may be ended or extended based on organizational needs, funding availability, and performance.

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

Education

• Bachelor's Degree in Computer Science or related field preferred
• equivalent work experience will be considered.

Experience

• Minimum of 8-10 years of hands-on experience in data integration, data engineering, or related field
• 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

Knowledge, Skills and Abilities

• Strong analytical and problem-solving skills with ability to troubleshoot complex data issues.
• Ability to work independently while managing multiple priorities in a fast-paced environment.
• Solid understanding of data integration concepts, ETL/ELT processes, and data lifecycle management.
• Effective communication skills to collaborate with both technical and business stakeholders.
• Working knowledge of data modeling techniques and database design principles.
• Ability to learn and adapt to new technologies and evolving data platforms.
• Strong attention to detail to ensure data accuracy, quality, and consistency.

Working Conditions/Physical Demands

Position requires working in an office environment where there some physical discomforts such as dust, dirt, noise, and the like are present. Ability to work off-hours and weekends for go-lives, testing and emergencies, as well as travel between office locations, primarily within NYC is required. Occasional meetings or clinical staff interactions in typical patient care areas may be required though direct patient exposure is not expected. Occasional moving of computer equipment or similar objects up to approximately 50lbs may be required to expedite projects.

Cornellwelcomes students, faculty, and staff with diverse backgrounds from across the globe to pursue world-class education and career opportunities, to further the founding principle of "any person, any study." No person shall be denied employment on the basis of any legally protected status or subjected to prohibited discrimination involving, but not limited to, such factors as race, ethnic or national origin, citizenship and immigration status, color, sex, pregnancy or pregnancy-related conditions, age, creed, religion, actual or perceived disability (including persons associated with such a person), arrest and/or conviction record, military or veteran status, sexual orientation, gender expression and/or identity, an individual's genetic information, domestic violence victim status, familial status, marital status or any other characteristic protected by applicable federal, state, or local law.

Cornell University embraces diversity in its workforce and seeksjob candidates who will contribute to a climate that supports students, faculty, and staff of all identities and backgrounds. Wehire based on merit, andencourage people from historically underrepresented and/or marginalized identities to apply.Consistent with federal law, Cornell engages in affirmative action in employment for qualified protected veterans as defined in the Vietnam Era Veterans' Readjustment Assistance Act (VEVRRA) and qualified individuals with disabilities under Section 503 of the Rehabilitation Act. We also recognize a lawful preference in employment practices for Native Americans living on or near Indian reservations in accordance with applicable law.