Manager, Data Architect
WFA Digital Insight
The demand for skilled data architects in the remote job market has surged, with companies like RTX seeking experts to design and maintain scalable HR data architecture. As the need for data-driven decision making grows, professionals with experience in Snowflake, ETL/ELT pipelines, and data governance are in high demand. With the global data analytics market expected to reach $257 billion by 2026, this role offers a unique opportunity to work with a leading aerospace and defense company. Before applying, candidates should be aware of the company's commitment to innovation and its requirement for US citizenship due to the sensitive nature of the work.
Job Description
About the Role
As a Manager, Data Architect at RTX, you will play a critical role in designing and maintaining scalable HR data architecture in Snowflake, ensuring the integrity and reliability of data across systems and workflows. You will be part of a team that pushes the boundaries of known science and finds new ways to connect and protect our world. Your expertise will be instrumental in building and optimizing ETL/ELT pipelines, defining and enforcing data governance, and implementing security policies for user views and semantic layers.The role entails collaboration with various stakeholders, including Product and Delivery, BU Consultants, and BI development teams, to translate requirements into scalable, governed data solutions. You will provide consultation and guidance on data architecture, integration, and analytics capabilities, and create comprehensive documentation for data architecture designs, processes, governance policies, and integrations.
RTX is committed to maintaining a culture of innovation, and as a data architect, you will have the opportunity to work with cutting-edge technologies and contribute to the company's mission to make a difference in the world.
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 for schemas, pipelines, and data models
- Partner with stakeholders 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
What We Are Looking For
- A University Degree or equivalent experience and minimum 8 years of prior 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
- US citizenship is required due to the sensitive nature of the work
Nice to Have
- 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
Benefits and Perks
- Opportunity to work with a leading aerospace and defense company
- Collaborative and dynamic work environment
- Professional development and growth opportunities
- Access to cutting-edge technologies and tools
- Flexible remote work arrangements
- Comprehensive benefits package
- Competitive salary and compensation package
- Recognition and reward for outstanding performance
How to Stand Out
- To stand out in your application, be sure to highlight your experience with Snowflake, ETL/ELT pipelines, and data governance.
- Familiarize yourself with RTX's commitment to innovation and its mission to make a difference in the world.
- Prepare to provide examples of your experience with data architecture, integration, and analytics capabilities.
- Be prepared to discuss your approach to data security and compliance with regulatory requirements.
- Show enthusiasm for working in a collaborative and dynamic environment, and highlight your strong communication and stakeholder collaboration skills.
- Keep your resume and cover letter concise, focusing on the most relevant experience and skills for the role.
- Research the company culture and values, and be prepared to discuss how you align with them.
This is a remote position listed on WFA Digital, the platform for professionals who work from anywhere. Browse more remote jobs across all categories.