Senior Manager, Data & AI Architect (Remote)

Prattwhitney; Connecticut; Hybrid; USD 132,000 - 252,000; Full time

Job summary

RTX is seeking an experienced Data & AI Architect to design, develop, and govern scalable data architectures that support BI, analytics, AI, and operations. You will work with business stakeholders, data engineers, and security teams to establish data standards and platforms enabling reliable data access across the organization.

The ideal candidate has hands-on Databricks Lakehouse experience, a deep understanding of the Medallion Architecture (Bronze/Silver/Gold), and experience migrating SAP

Qualifications

• Bachelor's degree in Computer Science, IT, Data Engineering, or related field with 10+ years of experience; OR an Advanced Degree with 7+ years of experience.
• 7+ years in data architecture, data engineering, or related discipline.
• Strong experience with modern data architectures and Lakehouse solutions.
• Hands-on experience with Databricks and the Databricks Data Intelligence Platform.

Responsibilities

• Design and implement scalable enterprise data architectures using Databricks and Lakehouse technologies.
• Define and implement Medallion Architecture patterns (Bronze, Silver, Gold).
• Architect semantic layers for enterprise metrics and analytics across heterogeneous systems.
• Collaborate with SAP experts to integrate ECC and S/4HANA data models and governance.
• Develop data models and data pipelines (ETL/ELT) aligned with business needs.
• Ensure security, privacy, governance, and data quality across platforms.

Skills

Databricks

Lakehouse

Medallion Architecture

SQL

Spark

Data Modeling

Cloud Platforms

Stakeholder Management

Education

Bachelor's degree in Computer Science, IT, Data Engineering (or related)

Advanced degree

Tools

Delta Lake

Unity Catalog

Databricks platforms

Job description

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.

Pratt & Whitney is a world leader in the design, manufacture and service of aircraft engines and auxiliary power systems and has been revolutionizing modern flight for over 100 years. Join us and help shape the future of aerospace and defense.

Senior Manager, Data & AI Architect

What You Will Do:

We are seeking an experienced Data & AI Architect to design, develop, and govern scalable, secure, and high-performing data architectures that support business intelligence, analytics, artificial intelligence, and operational needs. The Data Architect will work closely with business stakeholders, data engineers, application teams, security teams, and leadership to establish data strategies, standards, models, and platforms that enable reliable and accessible data across the organization. The ideal candidate has hands‑on experience designing Databricks-based Lakehouse architectures, a strong understanding of the Medallion Architecture, including Bronze, Silver, and Gold data layers and experience architecting data solutions for SAP ECC to SAP S/4HANA migrations.

Key Responsibilities:

• Design and implement scalable enterprise data architectures using Databricks and modern Lakehouse technologies.
• Define and implement Medallion Architecture patterns, including Bronze Layer, Silver Layer and Gold Layer.
• Architect and implement semantic layers that enable consistent enterprise metrics, business definitions, and analytics across heterogeneous systems.
• Design data models that blend ECC and S/4HANA structures into unified, analytics‑ready data products.
• Partner with SAP functional experts, data engineers, and business stakeholders to define data requirements, lineage, and transformation logic.
• Develop conceptual, logical, and physical data models aligned with business and technical requirements.
• Design scalable data lake, Lakehouse, and data warehouse architectures.
• Establish data architecture standards, principles, patterns, and best practices.
• Ensure alignment with enterprise governance, VAULTIS principles, and data quality standards.
• Design data ingestion and integration strategies for batch and streaming workloads.
• Partner with data engineers to develop efficient ETL/ELT pipelines using Databricks, Apache Spark, and SQL.
• Define approaches for data quality, lineage, metadata management, governance, and observability across the data platform.
• Design architectures that support analytics, business intelligence, machine learning, and generative AI use cases.
• Develop data migration and modernization strategies for legacy platforms.
• Ensure data architectures meet security, privacy, compliance, scalability, availability, and performance requirements.
• Collaborate with enterprise architects, application teams, data engineers, analysts, data scientists, and business stakeholders.
• Create architecture documentation, data-flow diagrams, reference architectures, and technical standards.
• Identify opportunities to improve data platform performance, reliability, scalability, and cost efficiency.
• Provide technical leadership and mentorship to data engineering and analytics teams.
• Collaborate with AI/ML teams to prepare, model, and structure SAP data for intelligent applications, including feature engineering and model‑ready datasets.

Qualifications You Must Have:

• Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related field with 10+ years of applicable work experience; OR an Advanced Degree with 7+ years of applicable work experience.
• 7+ years of experience in data architecture, data engineering, database architecture, or a related discipline.
• Strong experience designing and implementing modern data architectures and Lakehouse solutions.
• Hands‑on experience with Databricks and the Databricks Data Intelligence Platform.
• Strong understanding of Medallion Architecture, including Bronze, Silver, and Gold data layers.
• Strong knowledge of Apache Spark, PySpark, and SQL.
• Experience designing data warehouses, data lakes, and/or Lakehouse architectures.
• Strong knowledge of data modeling, including dimensional, relational, and analytical data models.
• Experience designing ETL/ELT pipelines and data integration solutions.
• Experience with at least one major cloud platform such as AWS, Microsoft Azure, or Google Cloud.
• Understanding of data governance, data quality, metadata, data lineage, security, and privacy.
• Demonstrated ability to design and implement enterprise‑scale data and AI/ML architecture solutions.
• Strong communication and stakeholder-management skills.

Qualifications We Prefer:

• Experience with Delta Lake and Delta Live Tables/Lakeflow Declarative Pipelines.
• Experience with Unity Catalog for data governance, access control, discovery, and lineage.
• Experience with Databricks, Delta Lake, Matillion, HVR, or other modern data engineering platforms.
• Deep knowledge of SAP modules (MM, SD, FI/CO, PP, PM) and related master data structures.
• Experience supporting large‑scale SAP modernization or digital core transformation programs.
• Experience with batch and real‑time/streaming data architectures.
• Knowledge of data mesh, data fabric, domain‑driven data architecture, and event‑driven architectures.
• Experience with cloud services supporting data ingestion, storage, processing, and analytics.
• Experience designing data platforms for AI/ML and Generative AI workloads.
• Familiarity with data catalog, data quality, data observability, and master data management solutions.
• Databricks, cloud, or data architecture certifications are a plus.

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. Candidates will learn more about role type and current site status throughout the recruiting process. For onsite and hybrid roles, commuting to and from the assigned site is the employee’s personal responsibility.

* This requisition is eligible for an employee referral award. ALL eligibility requirements must be met to receive the referral award. 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 132,400 USD - 251,600 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: RTX is an aerospace and defense company that provides advanced systems and services for commercial, military and government customers worldwide. It comprises three industry‑leading businesses – Collins Aerospace, Pratt & Whitney, and Raytheon. Its 195,000 employees enable the company to operate at the edge of known science as they imagine and deliver solutions that push the boundaries in quantum physics, electric propulsion, directed energy, hypersonics, avionics and cybersecurity. The company, formed in 2020 through the combination of Raytheon Company and the United Technologies Corporation aerospace businesses, is headquartered in Arlington, Virginia.