Manager, Data Architect (Remote)

RTX; Farmington (CT); On-site; USD 107,500 - 204,500; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) match

Flexible work schedules

Job summary

RTX in Farmington, Connecticut is seeking an experienced data architect to design and maintain scalable HR data architecture using Snowflake. The role involves building and optimizing ETL/ELT pipelines, ensuring data governance, and collaborating with various stakeholders.

Qualified candidates will have 8+ years of relevant experience, proficiency in Snowflake, and strong SQL Server skills. The compensation ranges from $107,500 to $204,500 USD, with additional benefits including medical, dental, and paid time off.

Qualifications

• 8+ years of relevant 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.

Responsibilities

• Design and maintain scalable HR data architecture.
• Build and optimize ETL/ELT pipelines using Matillion and Snowflake.
• Define and enforce data governance and data quality.

Skills

Data architecture

Snowflake

ETL/ELT pipelines

SQL Server

Data governance

Communication

Education

University Degree or equivalent experience

Tools

Snowflake

Matillion

Git

Job description

What You Will Do

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

Qualifications You Must Have

• Typically requires: A University Degree or equivalent experience and minimum 8 years of relevant experience, or an Advanced Degree in a related field and minimum 5 years of 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.

Preferred Qualifications

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

Compensation

Salary range: $107,500 – $204,500 USD. Additional compensation may include annual incentive programs.

Benefits

Hired applicants may be eligible for benefits, including 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, and other standard benefits. Benefit eligibility depends on the business unit and collective‑bargaining agreement.

RTX is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or veteran status, or any other applicable state or federal protected class. RTX provides affirmative action in employment for qualified individuals with a disability and protected veterans in compliance with Section 503 of the Rehabilitation Act and the Vietnam Era Veterans’ Readjustment Assistance Act.