Lead Data Architect - Workforce Intelligence (Remote)

RTX; United States; Remote; USD 108,000 - 205,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) match

Paid time off

Job summary

RTX seeks a Manager, Workforce Intelligence (Data Architect) to design and maintain scalable HR data architecture in Snowflake and to build ETL/ELT pipelines for analytics. You will define governance, security, and data quality standards while coordinating with product and BI teams to deliver governed data products across the organization.

The role requires 7+ years in data architecture, strong Snowflake and SQL Server skills, and experience with Git and deployment automation.

Qualifications

• Typically requires a university degree or equivalent experience with 8+ years in relevant work
• 7+ years of experience in data architecture or data engineering
• Strong hands-on experience with Snowflake and cloud data services
• Experience building API integration and ETL/ELT pipelines
• Strong SQL Server skills and performance tuning
• Proven data governance, metadata management and data security experience
• Experience with version control 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 and data models
• Build and optimize ETL/ELT pipelines to support reporting and analytics
• Define and enforce data governance, lineage, naming standards and compliance
• Develop and maintain data controls for data integrity across systems
• Implement and manage security policies for data views and semantic layers
• Establish DevOps practices for schemas, pipelines and data models
• Partner with Product, Delivery and BI teams to translate requirements into data solutions
• Provide consultation on data architecture, integration and analytics capabilities
• Create comprehensive documentation for architectures and integrations

Skills

Snowflake

ETL/ELT pipelines

Data governance

Data security

SQL Server

Git/version control

Stakeholder communication

Cross-functional collaboration

Education

University degree or equivalent experience

Advanced degree (related field)

Tools

Matillion

Git

Snowflake

SQL Server

Job description

RTX seeks a Manager, Workforce Intelligence (Data Architect) to design and maintain scalable HR data architecture in Snowflake and to build ETL/ELT pipelines for analytics. You will define governance, security, and data quality standards while coordinating with product and BI teams to deliver governed data products across the organization.

The role requires 7+ years in data architecture, strong Snowflake and SQL Server skills, and experience with Git and deployment automation.