Senior Data Integration & Automation Engineer

Pratt & Whitney; United States; Remote; USD 132,000 - 252,000; Full time

Benefits offered by this job

Medical, dental, vision benefits

401(k) with match

Paid time off

Job summary

RTX is seeking a Data Governance Integration & Automation Engineer to design and implement scalable integration architectures and automation solutions that advance the enterprise data governance strategy. You will balance architecture with hands-on development to deliver reusable patterns across data, metadata, governance, ETL, and data quality platforms.

You will collaborate with cross-functional teams, define integration standards, develop APIs, and automate data workflows to support

Qualifications

• Typically requires a University Degree or equivalent experience and a minimum of 10 years of prior relevant experience, or an Advanced Degree in a related field and a minimum of 7 years of experience.
• Experience with enterprise application integration, data integration, or integration engineering.
• Experience designing and developing REST APIs, OpenAPI specifications, JSON-based integrations, OAuth, and API contracts.
• Experience with Python, Java, or similar development languages.
• Experience with ETL architecture and development, SQL, and modern data platforms.
• Experience with data quality profiling, validation, rule execution, and monitoring.
• Experience with CI/CD, Git, automated testing, and deployment practices.

Responsibilities

• Collaborate with internal customers and cross-functional teams across architecture, platforms, engineering, and governance to align integration solutions with RTX’s enterprise data strategy and technical standards.
• Design reusable integration patterns across enterprise data, metadata, governance, and data quality platforms.
• Define API contracts, data mappings, ETL workflows, interface specifications, and integration standards to support scalable enterprise solutions.
• Develop APIs, integration services, automation scripts, and ETL pipelines to support data governance and data management processes.
• Automate metadata ingestion, synchronization, scanning, profiling, validation, and data quality workflows.
• Design event-driven and scheduled automation solutions for onboarding and processing new data assets.
• Establish reusable patterns for authentication, monitoring, logging, exception handling, reconciliation, and recovery.
• Develop reference implementations and reusable components that can be extended across multiple business use cases.
• Create and maintain architecture diagrams, technical designs, integration documentation, tooling guides, and operational runbooks.
• Conduct technical design and code reviews, providing guidance and technical direction to other engineers.
• Apply engineering best practices, including CI/CD, Git, automated testing, deployment, and operational support.
• Translate business requirements into scalable, maintainable technical solutions while balancing strategic architecture with hands-on development and delivery.

Skills

REST APIs

OpenAPI specifications

JSON-based integrations

OAuth

Python

Java

CI/CD

Git

ETL

SQL

Education

University Degree or equivalent experience

Advanced Degree in a related field

Tools

ETL

APIs

Job description

RTX is seeking a Data Governance Integration & Automation Engineer to design and implement scalable integration architectures and automation solutions that advance the enterprise data governance strategy. You will balance architecture with hands-on development to deliver reusable patterns across data, metadata, governance, ETL, and data quality platforms.

You will collaborate with cross-functional teams, define integration standards, develop APIs, and automate data workflows to support