Senior Manager - RTX ES Kinaxis Data Transformation
About The Position
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. This role will involve building out the transformations design and then supporting ongoing maintenance throughout the S/4 implementations journey. Additionally, this role will 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. The primary tool for 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.)
Requirements
- 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 with knowledge of data integration patterns, ETL/ELT, APIs, and messaging protocols (REST, SOAP, OPC).
- SQL proficiency — specifically the ability to explore unfamiliar database schemas and write extraction queries with little or no documentation.
- Direct experience working with customer or client IT teams to negotiate and establish data access (firewall rules, VPN connectivity, service accounts, API credentials).
- Expertise in data integration tools and platforms (e.g. Informatica, Talend) with proficiency in big data platforms and analytics tools (Power BI, Tableau) and a familiarity with DevOps tools and practices.
Responsibilities
- Build Data Transformation logic in Talend to marry legacy SAP ECC extracts with to-be S4 extracts and feed Kinaxis Maestro instances with a harmonized set of extracts.
- Build outbound closed loop file from Kinaxis Maestro to SAP, ensuring the outbound file meets SAP S4 specifications.
- Support ongoing legacy ECC extract maintenance.
- Provide ongoing maintenance of S4 extracts post “Go-Live” for each S4 site.
- 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 Data Transformations design and build as ongoing data needs dictate to support each successive S4 / IBP implementation cycle.
- Monitor and adjust data extract and transformation maintenance to ensure system data updates occur to drive System uptime and availability.
- 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.
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
- holidays
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Manager
