Data Engineer II - Onsite

RTX•Oklahoma City, OK

22h•Onsite

About The Position

This role is for a Data Engineer II at Pratt & Whitney, a world leader in the design, manufacture, and service of aircraft engines and auxiliary power systems, which is part of RTX, the world's largest aerospace and defense company. The position is within Pratt & Whitney’s Military Engines (ME) Sustainment Operational Excellence, Digital Transformation and Analytics (DT&A), Data Engineering & Analytics team. This team supports the aftermarket maintenance and overhaul of modules/engines for the F117, F119, and F135 programs across the Pratt & Whitney Global Depot Network (GDO). The Data Engineer II will be an integral part of advancing the digital and data capability of the Military Engines Global Depot Network organization, working with exciting new technologies like cloud and open-source tools. The primary responsibility will be cleaning, standardizing, transforming, and configuring data products within an emerging data mesh.

Requirements

A Bachelor’ Degree in Science, Technology, Engineering or Mathematics (STEM).
2+ years of experience in the use of SQL and/or Python to transform, clean, and integrate data from a variety of source pipelines.
U.S. citizenship is required, as only U.S. citizens are authorized to access information under this program/contract.
Ability to travel up to 10% domestic and international.

Nice To Haves

Experience with transformation tools such as dbt, Databricks pipelines, or relevant tools such as SSIS, ADF, or Matillion.
Demonstrated experience with Git/GitHub.
Experience working in cloud data warehouses like Databricks.
Familiarity with agile methodologies and Kanban boards.
Self-motivated, team player with good communication skills and the ability to focus on results and successfully manage multiple tasks/projects.
An astute individual, with the ability to build strong cross-functional relationships.
Excited at the prospect of developing and implementing new data products that add organizational value & improve decision making capabilities.
Business experience with Aerospace or other heavy manufacturing industry.
Demonstrated understanding of data mesh design principles and data engineering best practices.
Understanding of ER Diagrams for data modeling.

Responsibilities

Create and maintain scripts written in Spark SQL or Pyspark in Databricks Notebooks.
Work with SMEs to understand complex datasets for next generation data products and data visualizations to create data mesh tables.
Develop scalable and sustainable data product transformations that curate, clean and store data efficiently.
Perform statistical analysis to quantify completeness and validity.
Perform bug fixes and apply enhancements to the models when the need arises.
Ensure high performance and reliability of data transformation processes and pipelines.
Collaborate cross-functionally to gather insights, refine requirements, and ensure alignment between product goals and team efforts.
Document data processes, logic, and data sources to ensure transparency and knowledge sharing.
Support the overall team with any ad-hoc data related tasks.
Work to convert our existing data visualizations in Power BI to use Databricks instead of Azure Synapse.
Keep up to date with technologies and use advanced cloud data warehouse and data transformation techniques to build innovative solutions.