Data Readiness Analyst

Pratt & Whitney; United States; Remote; USD 157,000 - 299,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

401(k) plan

Job summary

Collins Aerospace seeks an Enterprise Data Management team member to support ERP data migration and harmonization initiatives for the S/4 migration. You will apply deep expertise in BU systems, data structures, and processes to ensure accurate mapping, cleansing, and validation, while developing harmonized data for reporting and analytics.

The role oversees data‑cleansing metrics and collaborates with BU data leads to drive data quality improvements pre- and post-migration.

Qualifications

• University degree with 12+ years of experience, or advanced degree with 10+ years.
• Must be authorized to work in the U.S. without company sponsorship.
• Strong SAP knowledge across MM/SD/FI/CO modules and data structures.

Responsibilities

• Data Cleansing & Validation: collaborate with BU Data SMEs to cleanse data for migration on schedule.
• Data Harmonization: support data harmonization across BU for standardized reporting post-ERP.
• Issue Resolution: identify and resolve data-related issues during extraction, cleansing and migration.
• Continuous Improvement: provide feedback to improve data management, integration, and governance.
• Business Rules Validation: ensure legacy rules are translated correctly into the S/4 system.
• Defect Resolution: identify and fix data defects during cleansing and migration.
• Collaboration with DT Teams: work with BU DT Data SMEs and Migration teams to align data requirements.
• Ongoing Data Management: maintain data accuracy post-migration for consistency with processes.

Skills

SAP modules MM/SD/FI/CO

SAP data structures

Education

University Degree

Advanced Degree

Tools

SQL

ABAP

Syniti

Job description

Date Posted: 2026-10-22

Country: United States of America

Location: US-WI-REMOTE

Position Role Type: Remote

U.S. Citizen, U.S. Person, or Immigration Status Requirements: Must be authorized to work in the U.S. without the company’s immigration sponsorship now or in the future. The company will not offer immigration sponsorship for this position. The company will not seek an export authorization for this role.

Security Clearance Type: None/Not Required

Security Clearance Status: Not Required

The Enterprise Data Management Team member is responsible for supporting ERP data migration and harmonization initiatives by applying deep expertise in Business Unit (BU) systems, data structures, and operational processes. This role works collaboratively with DT Data SMEs and BU Functional Data SMEs to ensure accurate and timely data mapping, cleansing, and validation, while contributing to the development of harmonized data for enterprise reporting and analytics. The position also oversees the creation of data‑cleansing metrics and reports and partners with BU data leads to drive business‑level data quality improvements in preparation for upcoming S/4 migrations.

What will you Do:

• Data Cleansing & Validation: Collaborate with BU Functional Data SMEs and BU Data leads to perform data cleansing activities, ensuring all data is prepared for migration according to project timelines.
• Data Harmonization: Support data harmonization across the BU, ensuring that the data is standardized and structured for effective reporting and analytics post-ERP implementation.
• Issue Resolution: Proactively identify and resolve data-related issues during the data extraction, cleansing, and migration phases.
• Continuous Improvement: Provide feedback on process improvements related to data management, system integration, and data governance.
• Business Rules Validation: Ensure that business rules applied to the legacy data are correctly translated and reflected in the new S/4 system.
• Defect Resolution: Identify and work to resolve any data issues that arise during the cleansing and migration processes, ensuring that data quality standards are met.
• Collaboration with DT Teams: Work closely with the BU DT Data SME and Data Migration teams to ensure alignment on data requirements, mapping, and quality expectations.
• Ongoing Data Management: Continue to support data accuracy and integrity efforts in the S/4 system post-migration to ensure consistency with business processes and reporting needs.

Qualifications you must have:

• Typically requires a University Degree and minimum 12 years prior relevant experience or an Advanced Degree in a related field and minimum 10 years of experience.
• Must be authorized to work in the U.S. without the company’s immigration sponsorship now or in the future (US. Citizen or Green Card Holder).
• Strong understanding of core modules like MM (Material Management), SD (Sales & Distribution), or FI/CO (Financial/Controlling).
• Strong understanding of SAP data structures, relationships, and source tables that will be part of the ERP migration.
• SAP deployment experience with a clear understanding of object relationships and the ability to anticipate and address potential issues early.

Qualifications we prefer:

• Experience with SQL (Oracle, Snowflake, SQL Server).
• Experience with ABAP programming and debugging.
• Familiarity with Syniti or related data profiling and migration tools.
• Experience leading a technical cutover

What We Offer:

Some of our competitive benefits packages include:

• Medical, dental, and vision insurance.
• Three weeks of vacation for newly hired employees.
• Generous 401(k) plan that includes employer matching funds and separate. employer retirement contribution, including a Lifetime Income Strategy option.
• Tuition reimbursement program.
• Student Loan Repayment Program.
• Life insurance and disability coverage.
• Optional coverages you can buy pet insurance, home and auto insurance, additional life and accident insurance, critical illness insurance, group legal, ID theft protection.
• Birth, adoption, parental leave benefits.
• Ovia Health, fertility, and family planning.
• Adoption Assistance.
• Autism Benefit.
• Employee Assistance Plan, including up to 10 free counseling sessions.
• Healthy You Incentives, wellness rewards program.
• Doctor on Demand, virtual doctor visits.
• Bright Horizons, child, and elder care services.
• Teladoc Medical Experts, second opinion program.
• And more!

Do you want to be part of a new, exciting initiative to combine foundational IT with new digital technologies? Our Digital Technology team is driving business efficiencies and a better customer experience by connecting technologies, people, information and processes. From making aircraft more electric, intelligent and integrated to building new software platforms such as Internet of Things, big data, artificial intelligence, and blockchain, there’s no better place to be right now than in digital. If you’re an agile thinker who enjoys utilizing modern technology to make big improvements, then you’re a perfect fit for this team. Join Collins Aerospace to help us revolutionize the aerospace industry today!

WE ARE REDEFINING AEROSPACE.

* Please consider the following role type definitions as you apply for this role.

Remote: Employees who are working in Remote roles will work primarily offsite (from home). If you live within a reasonable commute of an RTX site with other colleagues you interact with, your manager will discuss whether there is a degree of onsite presence associated with this role.

Regardless of your role type, collaboration and innovation are critical to our business and all employees will have access to digital tools so they can work with colleagues around the world – and access to Collins sites when their work requires in-person meetings.

At Collins, the paths we pave together lead to limitless possibility. And the bonds we form – with our customers and with each other -- propel us all higher, again and again.

As part of our commitment to maintaining a secure hiring process, candidates may be asked to attend select steps of the interview process in-person at one of our office locations, regardless of whether the role is designated as on-site, hybrid or remote.

The salary range for this role is 157,200 USD - 298,800 USD. The salary range provided is a good faith estimate representative of all experience levels. RTX considers several factors when extending an offer, including but not limited to, the role, function and associated responsibilities, a candidate’s work experience, location, education/training, and key skills.

Hired applicants may be eligible for benefits, including but not limited to, 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. Specific benefits are dependent upon the specific business unit as well as whether or not the position is covered by a collective-bargaining agreement.Hired applicants may be eligible for annual short-term and/or long-term incentive compensation programs depending on the level of the position and whether or not it is covered by a collective-bargaining agreement. Payments under these annual programs are not guaranteed and are dependent upon a variety of factors including, but not limited to, individual performance, business unit performance, and/or the company’s performance.

This role is a U.S.-based role. If the successful candidate resides in a U.S. territory, the appropriate pay structure and benefits will apply.

RTX anticipates the application window closing approximately 40 days from the date the notice was posted. However, factors such as candidate flow and business necessity may require RTX to shorten or extend the application window.

RTX is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or veteran status, or any other applicable state or federal protected class. RTX provides affirmative action in employment for qualified Individuals with a Disability and Protected Veterans in compliance with Section 503 of the Rehabilitation Act and the Vietnam Era Veterans’ Readjustment Assistance Act.