Manager, Data Architect

🕒 July 29

🦌 Connecticut – Remote

🦌 Connecticut – Remote

💵 $107.5k - $204.5k / year

⏰ Full Time

🟠 Senior

🔴 Lead

🚰 Data Engineer

👻 Ghost score 40%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

RTX

WebsiteLinkedInAll Job Openings

10,000+ employees

Founded 2020

🏭 Manufacturing

💼 Consulting

📦 Logistics

Manufacturing • Consulting • Logistics

RTX is a globally recognized aerospace and defense company dedicated to transformative technologies and era-defining innovation. It operates through various businesses, including Collins Aerospace, Pratt & Whitney, and Raytheon, with a focus on sustainable, connected flight and smarter defense systems. RTX is committed to diversity, equity, and inclusion across the company and aims to solve the world’s most complex problems with cutting-edge technology and talent. Additionally, RTX is involved in significant projects like upgrading the F135 Engine Core and developing missile-defense systems. The company emphasizes corporate responsibility and sustainable practices.

📋 Description

• 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, quality, consistency, lineage, naming standards, and regulatory compliance for HR data • Develop and maintain data controls to ensure 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

• 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 Integration 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 • U.S. citizenship required; only U.S. citizens are authorized to access information under the program/contract • 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

• 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, depending on position level and collective-bargaining coverage • Remote work from home • Potential flexible pay structure and benefits for U.S. territory residents