Senior Manager - RTX ES Kinaxis Data Transformation

Role Description

The Senior Manager - RTX ES Kinaxis Data Transformation role will primarily focus on the data integrations between SAP (Legacy ECC and to-be S4) and Kinaxis, first building out the transformations design and then supporting ongoing maintenance throughout the S/4 implementations journey. This role will also support the SIOP process data integrations between Kinaxis and SAP IBP, which is the anticipated “to-be” state tool for the RTX Aftermarket Planning teams to use in their daily activities. The primary tool which will be leveraged for the data transformation build work will be Talend. Finally, the Data Transformation role will build out and maintain the closed loop connectivity outbound from Kinaxis Maestro back to SAP (ECC & S4).

• Build Data Transformation logic in Talend to marry legacy SAP ECC extracts with the to-be S4 extracts and feed the Kinaxis Maestro instances with a harmonized set of extracts.
• Build outbound closed loop file from Kinaxis Maestro to SAP.
• Support ongoing legacy ECC extract maintenance.
• Post “Go-Live” for each S4 site, ongoing maintenance of S4 extracts.
• Fulfill all RTX employee training requirements.
• Obtain RTX CORE Champion certification.
• Support PST (SAP S4/ SAP IBP) implementation timelines and various corresponding Integration Test Cycles.
• Modify/Update the Data Transformations design and build as ongoing data needs dictate.
• Monitor and adjust data extract and transformation maintenance to ensure system data updates occur.
• Prepare project status update reports as requested in support of PST project.
• Drive continuous improvement in data update efficiency.
• Participate in Quarterly Product Increment (PI) Planning events to identify following quarter focus activities.

Qualifications

• Bachelor’s in Computer Science, Software Engineering, Information Systems or a related quantitative field with 10 years of related experience.
• Cloud data engineering certification or related work experience >5 years.
• ETL & Data Integrations certification or related work experience >7 years – preferably with Qlik/Talend.
• General Data management certification (CDMP) or related work experience >10 years.
• Previous experience working with Kinaxis RapidResponse / Kinaxis Maestro in data integration role.
• SQL proficiency — specifically the ability to explore unfamiliar database schemas and write extraction queries.
• Direct experience working with customer or client IT teams to negotiate and establish data access.
• Expertise in data integration tools and platforms (e.g. Informatica, Talend) with proficiency in big data platforms and analytics tools (Power BI, Tableau).

Requirements

• U.S. citizenship is required, as only U.S. citizens are authorized to access certain necessary systems.
• Remote work location.

Benefits

• Medical, dental, vision, life insurance.
• Short-term disability, long-term disability.
• 401(k) match.
• Flexible spending accounts.
• Flexible work schedules.
• Employee assistance program.
• Employee Scholar Program.
• Parental leave.
• Paid time off and holidays.