Data Engineer (Hybrid)

Prattwhitney; Cedar Rapids (IA); Hybrid; USD 87,000 - 165,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

3 weeks vacation

401(k) with match

Job summary

Collins Aerospace is seeking an experienced data engineer to design and maintain data pipelines for structured and unstructured data. You will implement access controls and data protection across hybrid cloud environments, collaborating with cross-functional teams to meet security requirements.

Ideal candidates have 5+ years in data engineering, strong Python/SQL skills, and hands-on experience with Spark, Databricks, and cloud data services.

Qualifications

• Typically requires a University Degree and minimum 5 years prior relevant experience or an Advanced Degree in a related field and minimum 3 years of experience.
• Must be a U.S. Citizen.
• Experience in engineering pipelines that handle both structured and unstructured data sources, including enterprise content repositories and file systems.
• Demonstrated ability to segment, classify, or secure data sets based on business, legal, or compliance requirements.
• Proficiency in Python, SQL, and data processing frameworks (Spark, PySpark, Databricks, EMR, Glue, or similar).
• Experience with cloud platforms (AWS, Azure, or GCP) and their native data services.
• Strong understanding of ETL/ELT, distributed systems, data modeling, and secure data architecture principles.
• Ability to work effectively in Agile teams and collaborate across technical and business functions.

Responsibilities

• Design, build, and maintain data pipelines that ingest, transform, and deliver structured and unstructured data.
• Engineer data solutions that segment data domains based on business rules and security boundaries.
• Implement data access controls, classification rules, and data protection mechanisms.
• Build scalable architectures for analytics, AI/ML, and data-driven decisions in partitioned data landscapes.
• Partner with stakeholders to translate requirements into reliable data engineering solutions.
• Optimize data workflows for performance, observability, and resiliency across cloud and hybrid platforms.
• Develop reusable data patterns, automation, and governance-aligned frameworks.
• Support production data systems with data integrity, lineage, and access auditability.

Skills

Python

SQL

Spark

PySpark

Databricks

EMR

Glue

AWS

Azure

GCP

ETL/ELT

Distributed systems

Data modeling

Secure data architecture

Agile

Education

University Degree

Tools

Terraform

CloudFormation

GitHub Actions

Jenkins

Job description

Job Details

Date Posted: 2026-08-12 Country: United States of America Location: US-IA-CEDAR RAPIDS-193 ~ 1120 Collins Rd NE BLDG193 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

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-based position at one of Collins’ major facilities. **

Responsibilities

• Design, build, and maintain data pipelines that ingest, transform, and deliver structured data (databases, ERP/CRM systems, operational systems) and unstructured data such as file shares, SharePoint repositories, images, documents, logs, and engineering artifacts.
• Engineer data solutions that can logically and physically segment data domains based on business rules, regulatory requirements, and security boundaries.
• Implement strict data access controls, classification rules, and data protection mechanisms to support secure data separation across environments.
• Build scalable architectures that support analytics, AI/ML, digital products, and data-driven decision making within sensitive or highly partitioned data landscapes.
• Partner with cross-functional stakeholders to translate complex business and compliance requirements into reliable, secure data engineering solutions.
• Optimize data workflows for performance, observability, and resiliency across cloud and hybrid platforms.
• Develop reusable patterns, automation, and governance-aligned data frameworks that accelerate secure data enablement across the organization.
• Support production data systems with strong attention to data integrity, lineage, and access auditability.

What You Will Learn

• How Collins business processes, systems, and data domains operate across engineering, operations, supply chain, quality, and enterprise functions.
• Industry-specific constraints and expectations within the Aerospace & Defense sector related to data security, compliance, and controlled information.
• How sensitive or segregated data sources—file shares, SharePoint, images, engineering documents, operational logs—flow through the business and how they must be protected.
• How to interpret and apply business rules, legal requirements, and security considerations to design data boundaries and manage data movement responsibly.
• Cross-functional coordination practices with program teams, cybersecurity, legal/compliance, DT, engineering, and enterprise operations, enabling tight alignment between business needs and secure data operations.

Must Have

• Typically requires a University Degree and minimum 5 years prior relevant experience or an Advanced Degree in a related field and minimum 3 years of experience.
• Must be a U.S. Citizen.
• Experience in engineering pipelines that handle both structured and unstructured data sources, including enterprise content repositories and file systems.
• Demonstrated ability to segment, classify, or secure data sets based on business, legal, or compliance requirements.
• Proficiency in Python, SQL, and data processing frameworks (Spark, PySpark, Databricks, EMR, Glue, or similar).
• Experience with cloud platforms (AWS, Azure, or GCP) and their native data services.
• Strong understanding of ETL/ELT, distributed systems, data modeling, and secure data architecture principles.
• Ability to work effectively in Agile teams and collaborate across technical and business functions.

We Prefer

• Experience designing data environments where strict security boundaries, data separation, or access controls are essential.
• Familiarity with document processing, OCR, text extraction, image handling, or large unstructured content repositories.
• Background with data governance, lineage, auditability, and automated policy enforcement.
• Experience integrating data from SharePoint, network file shares, and legacy content systems.
• Knowledge of AI/ML data preparation, feature pipelines, or working with high-sensitivity data sets.
• Experience with DevOps and IaC tools such as Terraform, CloudFormation, GitHub Actions, or Jenkins.
• Prior experience in aerospace, defense, manufacturing, or other regulated industries.

Salary

The salary range for this role is 86,800 USD - 165,200 USD.

Benefits

• 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 illnessinsurance, 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!

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.

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.

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.

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.