Remote Manager, Workforce Intelligence Data Architect

Pratt & Whitney; United States; Remote; USD 108,000 - 205,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Life insurance

Disability insurance

401(k) match

Flexible spending accounts

Flexible work schedules

Employee Scholar Program

Parental leave

Paid time off

Holidays

Job summary

RTX is seeking a skilled Manager, Workforce Intelligence (Data Architect) to design and oversee scalable HR data architecture using Snowflake. You will lead ETL/ELT pipelines with Matillion, enforce governance and security, and coordinate cross-functional teams to deliver trusted data products.

The role emphasizes collaboration with Product, Delivery, and BI teams, plus DevOps for data assets. Candidates require 7+ years in data architecture/engineering and strong SQL Server expertise.

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.

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 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.

Skills

Data architecture

Data engineering

SQL

Stakeholder collaboration

Education

University degree or equivalent

Advanced degree in related field

Tools

Snowflake

Matillion

Git

SQL Server

Job description

RTX is seeking a skilled Manager, Workforce Intelligence (Data Architect) to design and oversee scalable HR data architecture using Snowflake. You will lead ETL/ELT pipelines with Matillion, enforce governance and security, and coordinate cross-functional teams to deliver trusted data products.

The role emphasizes collaboration with Product, Delivery, and BI teams, plus DevOps for data assets. Candidates require 7+ years in data architecture/engineering and strong SQL Server expertise.