Manager, Data Architect (Remote)
RTX Corporation2 days ago
Remote, United StatesStaff+
Base Salary
$108k - $205k/yr
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 for reporting, analytics, and operational needs.
- Define and enforce data governance, data quality, lineage, naming standards, and regulatory compliance for HR data.
- Develop data controls and manage security policies, role-based access, and data protection across systems and workflows.
- Manage SQL Server environments for metadata management, including performance tuning and reliability.
- Establish version control, deployment automation, and environment-promotion practices for schemas, pipelines, and data models.
- Partner with Product and Delivery, BU Consultants, and BI development teams to translate requirements into governed data solutions.
- Provide consultation on data architecture, integration, and analytics capabilities and maintain comprehensive technical and governance documentation.
- Support AI-ready and agentic use cases by organizing trusted semantics, metadata, and reusable data products.
Requirements
- A university degree or equivalent experience and at least 8 years of relevant experience, or an advanced degree in a related field and at least 5 years of experience.
- At least 7 years of experience in data architecture or data engineering.
- Strong hands-on experience with Snowflake design, data modeling, and performance, as well as cloud data services.
- Experience building API integrations and ETL/ELT pipelines.
- Strong SQL Server design, indexing, and performance-tuning skills.
- Experience with data governance, metadata management, data security, version control, and automated deployment for data assets.
- Strong communication and stakeholder collaboration skills.
- Preferred: Snowflake or relevant cloud-data certification, Python or Shell scripting, API integration and microservices familiarity, Azure knowledge, and experience with Workday or other HR systems.
Benefits
- Remote U.S.-based work, primarily offsite, with possible in-person interview steps and potential onsite presence if near an RTX location.
- Eligible benefits may include medical, dental, vision, life insurance, disability coverage, 401(k) match, flexible spending accounts, flexible work schedules, employee assistance, employee education programs, parental leave, paid time off, and holidays.
- Potential eligibility for annual short-term and/or long-term incentive compensation programs, depending on position and business unit.
About RTX Corporation
RTX Corporation builds aerospace and defense systems through its Collins Aerospace, Pratt & Whitney, and Raytheon businesses, serving commercial aviation, the U.S. government, and allied militaries. Its products range from aircraft engines and avionics to radars, missiles, and command-and-control software, sold via long-term OEM programs and defense contracts. Formed in 2020 by the Raytheon–United Technologies merger, RTX is headquartered in Arlington, Virginia and trades on the NYSE as RTX.