RTX Logo

RTX

Manager, Data Architect (Remote)

Posted 2 Days Ago
In-Office or Remote
Hiring Remotely in Farmington, CT
108K-205K Annually
Senior level
In-Office or Remote
Hiring Remotely in Farmington, CT
108K-205K Annually
Senior level
Design and maintain scalable HR data architecture in Snowflake, build and optimize ETL/ELT pipelines (Matillion), enforce data governance and security, implement DevOps for data assets, manage SQL Server metadata environments, partner with stakeholders, and document solutions to support reporting, analytics, and AI-ready data products.
The summary above was generated by AI

Date Posted:

2026-06-17

Country:

United States of America

Location:

US-CT-FARMINGTON-0004 ~ 4 Farm Springs Rd ~ 4 FARM SPRINGS

Position Role Type:

Remote

U.S. Citizen, U.S. Person, or Immigration Status Requirements:

U.S. citizenship is required, as only U.S. citizens are authorized to access information under this program/contract.

Security Clearance Type:

None/Not Required

Security Clearance Status:

Not Required

At RTX, the world's largest aerospace and defense company, 185,000 great minds are united by purpose and inspired to make a difference solving the world’s most complex problems. With our three market leading businesses, world-class operations and investments in research and development, we offer capabilities and opportunity no one else can. Together, we push the boundaries of known science and find new ways to connect and protect our world. Join us and help shape the future of aerospace and defense.

RTX is seeking a skilled and experienced Manager, Workforce Intelligence (Data Architect) to join our team.

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

Qualifications We Prefer

  • 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

Please ensure the role type defined below is appropriate for your needs before applying to this role. This position is classified as:

Remote: Employees who are working in Remote roles will work primarily offsite (from home). If you live within a reasonable commute of an RTX site with other colleagues you interact with, your manager will discuss whether there is a degree of onsite presence associated with this role.

As part of our commitment to maintaining a secure hiring process, candidates may be asked to attend select steps of the interview process in-person at one of our office locations, regardless of whether the role is designated as on-site, hybrid or remote.

The salary range for this role is 107,500 USD - 204,500 USD. The salary range provided is a good faith estimate representative of all experience levels. RTX considers several factors when extending an offer, including but not limited to, the role, function and associated responsibilities, a candidate’s work experience, location, education/training, and key skills.

Hired applicants may be eligible for benefits, including but not limited to, 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, and holidays. Specific benefits are dependent upon the specific business unit as well as whether or not the position is covered by a collective-bargaining agreement.

Hired applicants may be eligible for annual short-term and/or long-term incentive compensation programs depending on the level of the position and whether or not it is covered by a collective-bargaining agreement. Payments under these annual programs are not guaranteed and are dependent upon a variety of factors including, but not limited to, individual performance, business unit performance, and/or the company’s performance.

This role is a U.S.-based role. If the successful candidate resides in a U.S. territory, the appropriate pay structure and benefits will apply.

RTX anticipates the application window closing approximately 40 days from the date the notice was posted. However, factors such as candidate flow and business necessity may require RTX to shorten or extend the application window.

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.

Privacy Policy and Terms:

Click on this link to read the Policy and Terms

Similar Jobs

23 Minutes Ago
Remote
United States
82K-112K Annually
Senior level
82K-112K Annually
Senior level
Big Data • Transportation • Analytics • Big Data Analytics
Perform inside sales development to set meetings and drive prospect attendance at Arity events. Execute email and phone campaigns, coordinate with field sales on pipeline and account penetration strategies, use Salesforce to track activity, participate in pipeline reviews and account strategy sessions, and develop campaign and lead generation tactics.
Top Skills: Salesforce
2 Hours Ago
Remote or Hybrid
United States
50K-50K Annually
Junior
50K-50K Annually
Junior
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Sell and manage group benefits (life, disability, dental, vision, voluntary) in the Utah market. Build broker and client relationships, develop strategic sales plans, grow renewals and new business for 2,000–4,999 life groups, coordinate cross-functionally for implementation, and track pipeline and sales activity to meet territory goals.
2 Hours Ago
Remote or Hybrid
United States
42K-42K Annually
Junior
42K-42K Annually
Junior
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Provide phone and digital customer support for insurance policy, coverage, billing, and service inquiries. Use AI-guided tools and CRM systems to resolve complex issues, validate call summaries, document interactions, escalate as needed, and contribute to process improvements. Participate in paid training and ongoing development.
Top Skills: Ai-Powered ToolsAutomated SummarizationCopilotCRMCustomer Communication SystemsGuided Decision WorkflowsKnowledge Bases

What you need to know about the NYC Tech Scene

As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.

Key Facts About NYC Tech

  • Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
  • Key Industries: Artificial intelligence, Fintech
  • Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
  • Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account