Manager, Data Architect

RTX

. Design and maintain scalable HR data architecture in Snowflake, including databases, schemas, data models, and semantic views .

Posted 11/10/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, with a strong focus on data governance, ETL/ELT pipeline optimization, and security policies. Proven ability to collaborate with stakeholders to deliver governed data solutions and ensure data integrity across systems.

Highest-signal resume keywords

Snowflake Data ArchitectureETL/ELT Pipeline OptimizationData 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 ArchitectureETL/ELT PipelinesSQL ServerData GovernanceMetadata ManagementData SecurityAPI IntegrationsCloud Data ServicesScripting (Python, Shell)Performance Tuning

Soft Skills

Strong CommunicationStakeholder Collaboration

Tools & Technologies

SnowflakeMatillionGitAzureHR Systems (Workday)

Certifications & Qualifications

Snowflake Certification

Industry Keywords

Data IntegrityData QualityRegulatory ComplianceDevOps PracticesCloud Platforms

Tech Stack

Tools & technologies

AzureCloudETLMatillionMicroservicesPythonSnowflakeSQL

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 for 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 ensuring 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

Requirements

What you’ll need

U.S. citizenship is required; only U.S. citizens are authorized to access information under this program/contract
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, including design, modeling, and performance
Experience with cloud data services
Experience building API integrations and ETL/ELT pipelines
Strong SQL Server skills, including design, indexing, and performance tuning
Proven 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
Snowflake or relevant cloud data services certification preferred
Scripting skills such as Python or Shell preferred
Familiarity with API integrations and microservices architecture preferred
Knowledge of cloud platforms, preferably Azure, preferred
Experience with HR systems such as Workday preferred

Benefits

Comp & perks

Medical insurance
Dental insurance
Vision insurance
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
Annual short-term and/or long-term incentive compensation programs may be available