Data Integration Engineer II- SAP BW (CEMI)- 2 Year Term Appointment
Designs, builds, and maintains ETL/ELT data pipelines, backend data models, and batch jobs supporting analytics and reporting at Weill Cornell's Business Intelligence unit, working with SAP BW/BODS, Informatica, SQL, and Amazon Redshift. On-site Midtown NYC role offered as a 2-year term appointment through Fall 2028.
- Compensation
- $130.3K–$143.3K / yr
- Location
- New York, US
- Work setup
- Not specified
- Seniority
- Middle
- Employment
- Not specified
- Experience
- 2+ years
- Category
- Software engineering
- Posted
Skills
Must have
- 8–10 years 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
- Strong analytical and problem-solving skills; ability to troubleshoot complex data issues
- Ability to work independently while managing multiple priorities
- Solid understanding of data integration concepts, ETL/ELT processes, and data lifecycle management
- Effective communication skills for collaborating with 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
- Ability to work off-hours/weekends for go-lives, testing, emergencies, and travel between NYC office locations
Nice to have
- Exposure to multiple data environments (on-premise and cloud)
- Bachelor's Degree in Computer Science or related field, or equivalent work experience
Full description
Title: Data Integration Engineer II- SAP BW (CEMI)- 2 Year Term Appointment
Location: Midtown
Org Unit: Business Intelligence
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