Senior Manager, Data & AI Architect (Remote)

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., 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., 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. 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., Senior Data Modeler / Data Architect Berlin, CT (Onsite) 15+ Years Must Must-Have Skills Data Modeling & Data Architecture SQL & Relational Databases ER Modeling …
• 1 month ago +

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.

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: Click on this to read the Policy and Terms

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. Our Pratt & Whitney Digital Technology team has an exciting new remote job opportunity for a Senior Manager, Data & AI Architect.