Data Readiness Analyst (Hybrid)

Prattwhitney; Charlotte (NC); Hybrid; USD 157,000 - 299,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

Three weeks of vacation

401(k) with company match

Job summary

Collins Aerospace in Charlotte, NC, is seeking a senior ERP data specialist to lead data cleansing, harmonization, and validation for upcoming S/4 migrations. You will collaborate with BU Data SMEs and DT teams to map, cleanse, and validate legacy data, ensuring quality and consistency for enterprise reporting.

The role emphasizes SAP MDG and SQL expertise, with responsibilities spanning issue resolution, governance, and ongoing data management in the post-migration environment.

Qualifications

• Typically requires a University Degree and extensive ERP data migration experience.
• Must be authorized to work in the U.S. without sponsorship.
• SAP data structures and MDG experience strongly preferred.

Responsibilities

• Collaborate with BU Data SMEs to perform data cleansing for migration.
• Support data harmonization across the BU for consistent reporting.
• Identify and resolve data-related issues during extraction and migration.
• Provide input on process improvements for data governance and quality.
• Ensure business rules are reflected in the S/4 system.

Skills

Data cleansing

Data validation

Data harmonization

Data governance

Problem solving

Education

University degree with 12+ years experience

Tools

SAP MDG

SQL

ABAP

Syniti

Job description

Date Posted: 2026-09-09 Country: United States of America Location: US-NC-CHARLOTTE-2730 ~ 2730 W Tyvola Rd ~ TYVOLA

Position Role Type: Hybrid

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 with SAP MDG (Master Data Governance) configuration and use.
• Experience with SAP PLMSI (PLM System Integration) tool.

What We Offer:

• 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!

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.

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.

Hybrid: Employees who are working in Hybrid roles will work regularly both onsite and offsite. Ratio of time working onsite will be determined in partnership with your leader. 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.

RTX is an aerospace and defense company that provides advanced systems and services for commercial, military and government customers worldwide. It comprises three industry‑leading businesses – Collins Aerospace, Pratt & Whitney, and Raytheon. Its 195,000 employees enable the company to operate at the edge of known science as they imagine and deliver solutions that push the boundaries in quantum physics, electric propulsion, directed energy, hypersonics, avionics and cybersecurity. The company, formed in 2020 through the combination of Raytheon Company and the United Technologies Corporation aerospace businesses, is headquartered in Arlington, Virginia.