Date Posted:

2025-08-06

Country:

United States of America

Location:

UT6: 4 Farm Springs 4 Farm Springs Road, Farmington, CT, 06032 USA

Position Role Type:

Hybrid

U.S. Citizen, U.S. Person, or Immigration Status Requirements:

The company will offer immigration sponsorship for this position, if needed.​ The company will not seek an export authorization for this role.

Security Clearance:

None/Not Required

RTX Corporation 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 Systems, Pratt & Whitney, and Raytheon. Its 185,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, VA.

The following position is to join the RTX Corporate Team:

We are looking for a highly skilled Lead ETL Developer to join our data engineering team. This role is responsible for building and maintaining robust data integration solutions to support enterprise data warehousing, reporting, and analytics initiatives. The ideal candidate will have expertise in modern cloud data platforms, strong ETL design capabilities, and a deep understanding of dimensional modeling using the Kimball methodology.

What You Will Do

Conduct meetings and workshops with business teams to gather, clarify, and validate data and reporting requirements.Analyze business information needs and perform thorough source data profiling and gap analysis.Identify and document business transformation rules and logic required for data integration.Collaborate with business stakeholders and data architects to translate requirements into functional and technical specifications.Work closely with Subject Matter Experts (SMEs) from systems including ADP Enterprise, Workday, SAP ERP, and SuccessFactors to extract and map data in the required formats.Design and implement scalable, cloud-native ETL pipelines using Matillion, integrating data into the Snowflake data warehouse.Create and manage Snowflake databases, warehouses, schemas, and objects such as tables and views.Design and develop dimensional data models based on the Kimball methodology in collaboration with Business Analysts and stakeholders.Build orchestration workflows and transformation mappings to enable efficient ETL loads.Monitor, troubleshoot, and debug ETL jobs to ensure high data quality, performance, and reliability.Design and implement secure data pipelines, ensuring compliance with data governance, access controls, and quality standards.Document ETL processes and data models to support knowledge sharing and future maintenance.Work closely with BI, Data Science, and IT teams to ensure solutions meet business data consumption needs.Support quality assurance efforts by participating in test plan creation, execution, and issue resolution.Coordinate User Acceptance Testing (UAT) and production deployment activities.Oversee and monitor production data loads, ensuring timely data delivery for downstream systems and users.Provide leadership to offshore resources by assigning tasks, tracking progress, and ensuring timely deliverables.

Qualifications You Must Have

Typically requires: A University Degree or equivalent experience and minimum 8 years prior relevant experience, or An Advanced Degree in a related field and minimum 5 years experience.Experience in the following:​-Cloud Platforms: Microsoft Azure, AWS (S3)-Data Warehousing: Snowflake-ETL / Orchestration Tools: Matillion-Databases: Oracle 19c, Azure SQL Server-Languages & Scripting: SQL, Python-Modeling & BI Tools: SQL Data Modeler, Qlik Sense

Qualifications We Prefer

Proven experience with Snowflake and Matillion in cloud-based data environments.Strong knowledge of ETL/ELT best practices, data warehousing principles, and data modeling.Excellent SQL and scripting skills for data processing and transformation.Strong understanding of data governance, access control, and data quality principles.Ability to work effectively with cross-functional and geographically distributed teams.Excellent communication, documentation, and problem-solving skills.

What We Offer

Whether you’re just starting out on your career journey or are an experienced professional, we offer a robust total rewards package with compensation; healthcare, wellness, retirement and work/life benefits; career development and recognition programs. Some of the benefits we offer include parental (including paternal) leave, flexible work schedules, achievement awards, educational assistance and child/adult backup care.

The salary range for this role is 101,000 USD - 203,000 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:

Click on this link to read the Policy and Terms