Data Engineer
RTX Corporation23 days ago
Remote, United StatesSenior
Base Salary
$108k - $205k/yr
Responsibilities
- Design, develop, optimize, and maintain scalable data workflows and pipelines in Matillion using tools such as HVR and Databricks.
- Build data ingestion, transformation, modeling, consumption, and analytics workflows from various data sources.
- Collaborate with data scientists, analysts, architects, business data owners, and other stakeholders to translate data needs into technical solutions.
- Perform data modeling and design database structures supporting business requirements.
- Write and optimize SQL queries for data analysis, transformation, and troubleshooting.
- Ensure data security, data quality, integrity, governance, and compliance with applicable standards and regulations.
- Document data processes, workflows, and technical specifications.
- Advocate established data engineering best practices and design patterns.
Requirements
- A university degree or equivalent experience with at least eight years of relevant experience, or an advanced degree with at least five years of experience.
- At least five years of experience as a data engineer performing AI-driven data analysis, data modeling, and data transformation.
- Strong experience developing and optimizing ETL/ELT processes using tools such as Matillion.
- Strong data modeling and data architecture skills.
- Experience gathering business data requirements and translating them into clear, actionable technical requirements.
- Experience with SAP HANA, BW, Multipliers, Infocubes, and OData.
- U.S. citizenship and the ability to obtain and maintain a U.S. government-issued security clearance; an active Secret DoD clearance is required after day one.
- Preferred experience includes AI-based data exploration and validation, SQL, relational databases, Python, Snowflake, SAP data warehousing, Matillion, REST API integration, cloud platforms, data catalogs, data quality protocols, and aerospace and defense.
- Preferred knowledge includes data governance, data security, FedRAMP, ITAR, and U.S. government cloud data protection requirements.
- Strong problem-solving, communication, interpersonal, and collaborative skills.
Benefits
- Remote work primarily from home, with residence and work required in one of the 50 U.S. states excluding U.S. territories; travel or occasional in-person interview steps may be required.
- Potential benefits include medical, dental, vision, life insurance, short- and long-term disability, 401(k) match, flexible spending accounts, flexible work schedules, employee assistance, parental leave, paid time off, and holidays.
- Eligible employees may receive annual short- and/or long-term incentive compensation, which is not guaranteed and depends on applicable factors.
- Candidates must complete a first-round HireVue video screening.
About RTX Corporation
RTX Corporation builds aerospace and defense systems through its Collins Aerospace, Pratt & Whitney, and Raytheon businesses, serving commercial aviation, the U.S. government, and allied militaries. Its products range from aircraft engines and avionics to radars, missiles, and command-and-control software, sold via long-term OEM programs and defense contracts. Formed in 2020 by the Raytheon–United Technologies merger, RTX is headquartered in Arlington, Virginia and trades on the NYSE as RTX.