R

RTX

Manufactures jet engines, avionics, missiles

Manager – Data Architect

Data Management +1Updated on Nov 10
Full-timeConnecticut, USA$107.5k - $204.5k

About the Job

Requirements

  • A university degree or equivalent experience and at least 8 years of relevant experience, or an advanced degree in a related field and at least 5 years of experience.
  • At least 7 years of experience in data architecture or data engineering.
  • Hands-on experience with Snowflake design, modeling, performance, and cloud data services.
  • Experience building API integrations and ETL/ELT pipelines.
  • Strong SQL Server skills, including design, indexing, and performance tuning.
  • Experience with data governance, metadata management, and data security.
  • Experience with version control such as Git and automated deployment for data assets.
  • Strong communication and stakeholder collaboration skills.

Responsibilities

  • 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 regulatory compliance for HR data.
  • Develop and maintain data controls to ensure data integrity and reliability 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, including version control, deployment automation, and 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 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.

Desired Qualifications

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

About the Company

RTX

Manufactures jet engines, avionics, missiles

RTX operates in aerospace and defense with three main units: Pratt & Whitney jet engines, Collins Aerospace avionics and flight systems, and Raytheon defense systems. Jet engines provide thrust for commercial and military aircraft, avionics manage cockpit controls and navigation, and Raytheon builds missiles, radar, and sensing platforms. It differentiates itself by offering an integrated, end-to-end portfolio across both commercial aviation and national defense under one corporate roof, built on the legacy of Raytheon and UTC. Its goal is to help customers fly more efficiently and protect nations by advancing propulsion, electronics and defense tech for civilian and security needs.

Company size
10,001+
Company stage
IPO
Headquarters
Arlington County, VA
Founded
2022

Recently Posted Jobs

Explore more opportunities at RTX

See more jobs