Data Readiness Analyst

Collins Aerospace; Madison (WI); Remote; USD 157,000 - 299,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) plan

Tuition reimbursement

Student Loan Repayment

Job summary

Collins Aerospace is seeking an Enterprise Data Management Team member to support ERP data migration and harmonization, focusing on data mapping, cleansing and validation for the upcoming S/4 migrations.

You will collaborate with BU Data SMEs and DT Data SMEs, drive data quality improvements, define data-cleansing metrics, and ensure compliant, accurate data for enterprise reporting and analytics during the migration journey.

Qualifications

• Requires university degree and extensive experience in ERP data management (minimum 10–12 years).
• Experience with SAP modules MM, SD, FI/CO and SAP data structures is essential.
• Proven ability to map, cleanse, and validate data for SAP S/4 migrations.

Responsibilities

• Data cleansing & validation across BU data sources for migration readiness.
• Support data harmonization to standardize data structures and enable accurate reporting.
• Identify and resolve data-related issues during extraction, cleansing, and migration phases.
• Provide feedback to improve data management processes and governance.
• Ensure legacy data rules are correctly translated to the S/4 system.
• Collaborate with DT Data SMEs and BU Data SMEs to align on data requirements.

Skills

Data cleansing

Data validation

Data harmonization

Issue resolution

Data governance

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 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. Join Collins Aerospace to help us revolutionize the aerospace industry today! WE ARE REDEFINING AEROSPACE.

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.

Privacy Policy and Terms: