Data Readiness Analyst (Hybrid)

Collins Aerospace; Windsor Locks (CT); Hybrid; USD 157,000 - 299,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

Three weeks of vacation

Generous 401(k) plan with matching

Tuition reimbursement

Life insurance

Disability coverage

Flexible spending accounts

Employee Assistance Program

Job summary

Collins Aerospace is seeking an Enterprise Data Management specialist to support ERP data migration and harmonization for S/4 migrations. You will collaborate with BU Data SMEs to ensure accurate mapping, cleansing and validation of legacy data, enabling reliable reporting and analytics.

You will also develop data-cleansing metrics, drive data quality improvements across the BU, and partner with DT teams to translate business rules, resolve defects, and sustain data integrity post-migration in a

Qualifications

• Typically requires a University Degree and minimum 12 years prior relevant experience or an Advanced Degree with minimum 10 years.
• Experience with ERP data migration and SAP data structures.

Responsibilities

• Data Cleansing & Validation: Collaborate with BU Functional Data SMEs and BU Data leads to perform data cleansing activities.
• Data Harmonization: Support data harmonization across the BU for standardized reporting.
• Issue Resolution: Proactively identify and resolve data-related issues during data extraction, cleansing, and migration.
• Continuous Improvement: Provide feedback on process improvements related to data management and data governance.
• Business Rules Validation: Ensure legacy data rules translate to the new S/4 system.
• Defect Resolution: Identify and resolve data issues to meet data quality standards.
• Collaboration with DT Teams: Work with BU DT Data SME and Data Migration teams.
• Ongoing Data Management: Support data accuracy and integrity post-migration.

Skills

Data cleansing

Data harmonization

Issue resolution

Continuous improvement

Business rules validation

Defect resolution

Collaboration

Data governance

Ongoing data management

Education

Bachelor's degree or higher in a related field

Tools

SAP

ABAP

Syniti

SAP MDG

SAP PLMSI

SQL

Snowflake

SQL Server

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:

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 illnessinsurance, 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.

WE ARE REDEFINING AEROSPACE.

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

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.

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.