Manager, Data Architect

🕒 3 days ago

🦌 Connecticut – Remote

🦌 Connecticut – Remote

💵 $107.5k - $204.5k / year

⏰ Full Time

🟠 Senior

🔴 Lead

🚰 Data Engineer

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

🎯 Requirements

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

🏖️ Benefits

• 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