Data Engineer II; Onsite

Data Engineer II (Onsite) at Pratt & Whitney

Date Posted:

Country: United States of America

Location: PW147: PW OKC Campus 8120 S. Air Depot Blvd, Oklahoma City, OK, 73135 USA

Position Role Type: Onsite

U.S. Citizenship Requirement: U.S. citizenship is required, as only U.S. citizens are authorized to access information under this program/contract.

Security Clearance: None/Not Required

Pratt & Whitney is working to once again transform the future of flight—designing, building and servicing engines unlike any the world has ever seen. And because transformation begins from within, we’re seeking the people to drive it. So, calling all curious.

Come ready to explore and you’ll find a place where your talent takes flight—beyond the borders of title, a country or your comfort zone. Bring your passion and commitment and we’ll welcome you into a tight-knit team that takes our mission personally. Channel your drive to make a difference into shaping an organization and an industry that’s evolving fast to the future.

At Pratt & Whitney, the difference you make is on display every day. Just look up. Are you ready to go beyond?

You will be an integral part of Pratt & Whitney’s Sustainment Operational Excellence Data Engineering & Analytics team. This team supports the global aftermarket maintenance and overhaul of engines for the F117, F119, and F135 programs.

We are looking for a Data Engineer II to advance the digital and data capability of the Military Engines Global Depot Network organization. You will be working on exciting new technologies like cloud and open-source tools among others, and be responsible for cleaning, standardizing, transforming, and configuring data products within our emerging data mesh.

• Create and maintain scripts written in Spark SQL or Pyspark in Databricks Notebooks. Also, 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 as well as 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.

• A degree in Science, Technology, Engineering or Mathematics (STEM) with 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.

• Experience with transformation tools such as dbt, Databricks pipelines, or relevant tools such as SSIS, ADF, or Matillion.
• Demonstrated experience with Git/Git Hub; experience working in cloud data warehouses like Databricks.
• Familiarity with agile methodologies and Kanban boards.
• Self-motivated, team player with good communication skills. 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.
• An understanding of ER Diagrams for data modeling.
• Demonstrated understanding of data mesh design principles and data engineering best practices.

In addition to transforming the future of flight, we are also…