Data Engineer (Puerto Rico)

RTX•Aguadilla, PR

1d•Hybrid

About The Position

Collins Aerospace is seeking a Data Engineer to join our Digital Technology team. 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 position in Puerto Rico. Our Digital Technology team is driving business efficiencies and a better customer experience by connecting technologies, people, information and processes. From making aircraft more electric, intelligent and integrated to building new software platforms such as Internet of Things, big data, artificial intelligence, and blockchain, there’s no better place to be right now than in digital. If you’re an agile thinker who enjoys utilizing modern technology to make big improvements, then you’re a perfect fit for this team. Join Collins Aerospace to help us revolutionize the aerospace industry today!

Requirements

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 operations, supply chain, data engineering, and/or data analytics.
Experience using MRP, ERP, and MES systems (SAP preferred).
Experience in design, implementations, and optimization in relational SQL databases.
Experience with data cleansing, curation, mining, manipulation, and analysis from disparate systems (SQL, Python preferred).

Nice To Haves

Knowledge of Data Extract, Transform and Load (ETL) processes using SQL as the foundation
Ability to understand complex systems and processes and translate business needs to requirements
Knowledge of database structures, modeling implementation such as third normal form.
Experience with Python and related libraries such as Pandas for advanced data analytics.
Experience with configuration control (GitHub preferred) and DataDevOps practices using GitHub Actions, Jenkins or other deployment pipelines that provide Continuous Integration and Continuous Delivery (CI/CD).
Experience with Snowflake Streams, Stages and Snowpipes for data ingestion.
Experience with VS Code and GitHub Desktop for integrated development
Experience with web application relational database models and APIs.
Knowledge of statistical modeling and machine learning methods.
Knowledge of data visualization tools such as Tableau or Power BI.
Experience with Manufacturing, Operations, and/or Supply Chain process and systems.

Responsibilities

Effectively plan and collaborate with technical and non-technical teams supporting multiple key business initiatives.
Develop and manage data-driven solutions and architectures supporting multiple reports, tools, and systems.
Conduct advanced statistical analysis to yield actionable insights, identify trends, measure performance, and visualize disparate sources of data.
Turn ideas from proof-of-concepts to product while working with engineering teams to optimize factory productivity, customer satisfaction, and attainment of financial targets given a set of constantly changing supply constraints.
Engagement in data governance council to define, develop, and review standards, guidelines, and data models to promote data quality and best practices.