Manager, Data Architect (Remote)

RTX Corporation; Farmington (CT); Remote; USD 107,500 - 204,500; Full time

Benefits offered by this job

Medical, dental, vision coverage

401(k) match

Paid time off & holidays

Competitive incentive programs

Job summary

RTX is seeking an experienced Data Architect/Data Engineer to design and maintain scalable HR data architecture in Snowflake, and to build robust ETL/ELT pipelines using Matillion. You will enforce governance, data quality, lineage, and security across metadata systems while collaborating with product, delivery, and BI teams to deliver data solutions.

The role requires strong SQL Server skills, DevOps practices, and experience with data governance, metadata management, and secure data access.

Qualifications

• University degree or equivalent experience, with at least 8 years in data architecture/engineering.
• 7+ years of experience in data architecture or data engineering.
• Strong Snowflake design, modeling, and performance experience.
• Experience with API integrations and ETL/ELT pipelines.
• Strong SQL Server skills and performance tuning.
• Experience with governance, metadata management and data security.
• Git version control and automated deployment for data assets.

Responsibilities

• Design and maintain scalable HR data architecture in Snowflake.
• Build and optimize ETL/ELT pipelines with Matillion.
• Define data governance, quality, lineage, and naming standards.
• Develop data controls to ensure data integrity.
• Implement security policies for user views and semantic layers.
• Manage SQL Server environments used for metadata management.
• Establish DevOps for schemas, pipelines and data models.
• Collaborate with product, delivery, and BI teams to turn requirements into scalable data solutions.
• Provide guidance on data architecture, integration, and analytics.
• Create documentation for data architectures, governance, and integrations.

Job description

At RTX, the world's largest aerospace and defense company, 185,000 great minds are united by purpose and inspired to make a difference solving the world's most complex problems. With our three market leading businesses, world-class operations and investments in research and development, we offer capabilities and opportunity no one else can. Together, we push the boundaries of known science and find new ways to connect and protect our world. Join us and help shape the future of aerospace and defense.

Location: US-CT-FARMINGTON-0004 ~ 4 Farm Springs Rd ~ 4 FARM SPRINGS

Position Role Type: Remote U.S. Citizen, U.S. Person, or Immigration Status Requirements: U.S. citizenship is required, as only U.S. citizens are authorized to access information under this program/contract.

Security Clearance Type: None/Not Required

Security Clearance Status: Not Required

What You Will Do:

• Design and maintain scalable HR data architecture in Snowflake, including databases, schemas, data models and semantic views.
• Build and optimize ETL/ELT pipelines using Matillion and Snowflake to support reporting, analytics and operational needs.
• Define and enforce data governance, data quality, consistency, lineage, naming standards and compliance with regulatory requirements for HR data.
• Develop and maintain data controls to ensure the integrity and reliability of data across systems and workflows.
• Implement and manage security policies for user views and semantic layers, including role-based access and data protection.
• Manage SQL Server environments used for metadata management, including performance tuning and reliability.
• Establish DevOps practices (version control, deployment automation, environment promotion) for schemas, pipelines and data models.
• Partner with Product and Delivery, BU Consultants and BI development teams to translate requirements into scalable, governed data solutions.
• Provide consultation and guidance on data architecture, integration and analytics capabilities.
• Create and maintain comprehensive documentation for data architecture designs, processes, governance policies, and integrations.
• Support AI-ready and agentic use cases by organizing trusted semantics, metadata and reusable data products.

Qualifications:

• 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
• 7+ years of experience in data architecture or data engineering.
• Strong hands-on experience with Snowflake (design, modeling, performance) and cloud data services.
• Experience building API Integration, ETL/ELT pipelines.
• Strong SQL Server skills (design, indexing, performance tuning).
• Proven experience with data governance, metadata management and data security.
• Experience with version control (e.g., Git) and automated deployment for data assets.
• Strong communication and stakeholder collaboration skills.

Preferred Qualifications:

• Excellent communication and coordination skills to work effectively with technical and non-technical stakeholders.
• Certification in Snowflake or relevant cloud data services.
• Scripting skills (e.g., Python, Shell) for automation.
• Familiarity with API integrations and microservices architecture.
• Knowledge of cloud platforms (Preferably Azure).
• Experience with HR systems such as Workday

Benefits:

• 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.
• 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.
• The salary range for this role is 107,500 USD - 204,500 USD.
• The 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.

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.