Manager, Data Architect

RTX

Manager, Data Architect overseeing HR data architecture and ETL processes at RTX. Collaboration with cross-functional teams to implement data governance and integrity standards.

Posted 7/30/2026full-timeRemote • Connecticut • 🇺🇸 United StatesSeniorLead💰 $107,500 - $204,500 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and maintaining scalable HR data architecture using Snowflake, while ensuring data governance, quality, and security. Proficient in building ETL/ELT pipelines and managing SQL Server environments to support analytics and operational needs.

Highest-signal resume keywords

Snowflake Data ArchitectureETL/ELT Pipeline DevelopmentData Governance and SecuritySQL Server Performance TuningVersion Control and Deployment Automation

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data ArchitectureData EngineeringETL/ELTSQL ServerSnowflakeAPI IntegrationData GovernanceMetadata ManagementPerformance TuningData Security

Soft Skills

CommunicationStakeholder Collaboration

Tools & Technologies

MatillionGitCloud Data Services

Industry Keywords

Data QualityData LineageComplianceDevOps PracticesDocumentation

Tech Stack

Tools & technologies

CloudETLMatillionSQL

About the role

Key responsibilities & impact

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.

Requirements

What you’ll need

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.

Benefits

Comp & perks

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
holidays