Common Data Model Lead (Hybrid)

Prattwhitney; Richardson (TX); Hybrid; USD 108,000 - 205,000; Full time

Benefits offered by this job

Medical benefits

401(k) plan

Tuition reimbursement

Paid time off

Life insurance

Job summary

RTX is seeking a senior data modeling Architect for Collins Aerospace facilities in the United States. The role leads the enterprise data model across conceptual, logical, and physical layers, driving standards and metadata conventions.

You will resolve semantic conflicts, improve interoperability across ERP, PLM, MES, MRO, IoT, analytics, and AI platforms, and mentor a team of data modelers. Preferred candidates have strong Snowflake experience, deep data modeling and ontology knowledge, and

Qualifications

• Typically requires a University Degree and minimum 8 years experience or an Advanced Degree with 5+ years of related work.
• Experience with Snowflake and data modeling, data architecture, or ontology/knowledge graph development.
• Expertise in conceptual, logical, and physical modeling and canonical data design.
• Proficiency with ER/Studio, PowerDesigner, Hackolade, or similar tools.
• Strong skills in SQL, SPARQL, Cypher, and relational/NoSQL databases.
• Experience integrating data across ERP, PLM, MES, MRO, IoT, analytics, or AI systems.

Responsibilities

• Lead the enterprise common data model across conceptual, logical, and physical layers.
• Define and enforce modeling standards, metadata conventions, and canonical entities.
• Resolve semantic and definitional conflicts across business units and systems.
• Improve interoperability across ERP, PLM, MES, MRO, IoT, analytics, and AI platforms.
• Ensure compliance with enterprise, regulatory, and security requirements.
• Mentor data modelers and architects to improve modeling maturity.
• Collaborate with architects, engineers, and business SMEs to align business concepts with enterprise models.
• Communicate modeling strategy and recommendations to all levels, including executives.

Skills

Snowflake

Data modeling

Data architecture

Ontology/Knowledge graph

SQL

SPARQL

Cypher

NoSQL databases

ERP/PLM/MES/MRO/IoT/AI systems

Education

University Degree in a related field

Tools

ER/Studio

PowerDesigner

Hackolade

Job description

Date Posted: 2026-09-15 Country: United States of America Location: US-TX-RICHARDSON-461 ~ 3200 E Renner Rd ~ RENNER BLDG 461 Position Role Type: Hybrid 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. Collins Aerospace is a leader in technologically advanced, intelligent solutions that help redefine the aerospace and defense industry. With a comprehensive portfolio and deep technical expertise, we help customers meet the demands of the global market. Join us and help shape the future of aerospace and defense.

This is a hybrid position, at one of Collins major facilities

What You Will Do

• Lead the enterprise common data model across conceptual, logical, and physical layers.
• Define and enforce modeling standards, metadata conventions, and canonical entities.
• Resolve semantic and definitional conflicts across business units and systems.
• Improve interoperability across ERP, PLM, MES, MRO, IoT, analytics, and AI platforms.
• Ensure compliance with enterprise, regulatory, and security requirements.
• Mentor data modelers and architects to improve modeling maturity.
• Collaborate with architects, engineers, and business SMEs to align business concepts with enterprise models.
• Communicate modeling strategy and recommendations to all levels, including executives.

What YOU will Learn

• How to scale a unified data model across a large, highly regulated enterprise.
• How data modeling enables digital thread, digital twin, AI/ML, and automation initiatives.
• How enterprise data architecture drives interoperability and decision-making.
• How to influence adoption of data standards across complex technical and business environments.

Qualifications - You Must Have

• Typically requires a University Degree and minimum 8 years prior relevant experience or an Advanced Degree in a related field and minimum 5 years of experience U.S. citizenship is required, as only U.S. citizens are authorized to access information under this program/contract.
• Experience with Snowflake.
• Experience in data modeling, data architecture, or ontology/knowledge graph development.
• Expertise in conceptual, logical, and physical modeling and canonical data design.
• Proficiency with ER/Studio, PowerDesigner, Hackolade, or similar tools.
• Strong skills in SQL, SPARQL, Cypher, and relational/NoSQL databases.
• Experience integrating data across ERP, PLM, MES, MRO, IoT, analytics, or AI systems.
• Ability to enforce standards, resolve semantic conflicts, and influence stakeholders.
• Strong skills in communication, and building out program artifacts.

Qualifications - We Prefer

• Experience in aerospace, defense, or other regulated industries.
• Familiarity with ITAR, DFARS, ISO, or similar compliance frameworks.
• Experience with data fabric, data mesh, Lakehouse architectures, and cloud platforms (Azure, AWS).
• Background supporting digital thread, digital twin, and AI/ML programs.
• Experience mentoring or leading data modeling teams.

The salary range for this role is 107,500 USD - 204,500 USD.

What We Offer: Some of our competitive benefits packages include:

• Medical, dental, and vision insurance.
• Three weeks of vacation for newly hired employees.
• Generous 401(k) plan that includes employer matching funds and separate. employer retirement contribution, including a Lifetime Income Strategy option.
• Tuition reimbursement program.
• Student Loan Repayment Program.
• Life insurance and disability coverage.
• Optional coverages you can buy pet insurance, home and auto insurance, additional life and accident insurance, critical illness insurance, group legal, ID theft protection.
• Birth, adoption, parental leave benefits.
• Ovia Health, fertility, and family planning.
• Adoption Assistance.
• Autism Benefit.
• Employee Assistance Plan, including up to 10 free counseling sessions.
• Healthy You Incentives, wellness rewards program.
• Doctor on Demand, virtual doctor visits.
• Bright Horizons, child, and elder care services.
• Teladoc Medical Experts, second opinion program.
• And more!

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.

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.