Jr. Data Engineer (Puerto Rico)

Relha LLC; Santa Isabel (PR); Hybrid; USD 60,000 - 90,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Vacation time

401(k) plan

ESP program

Life insurance

Disability coverage

EAP

Job summary

Collins Aerospace is seeking a Junior Data Engineer to join our Digital Technology team in Puerto Rico. This hybrid role requires residency in Puerto Rico. You will plan with diverse teams, develop and manage data-driven solutions, and perform advanced analyses to yield actionable insights.

You will work on ETL pipelines, data governance, and data quality initiatives while collaborating to improve manufacturing and supply chain metrics and drive performance in a dynamic environment.

Qualifications

• University degree and 2+ years of relevant data engineering experience.
• Experience with SQL databases and data integration pipelines.
• Familiarity with data governance and data quality practices.

Responsibilities

• 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.

Skills

SQL

Python

ETL

Data governance

Snowflake

Git

Pandas

Tableau/Power BI

Education

Bachelor's degree in CS or related field

Job description

U.S. Citizen, U.S. Person, or Immigration Status Requirements:

Security Clearance:

None/Not Required

Collins Aerospace is seeking a Junior 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, candidate must reside in Puerto Rico**

What YOU will do:

• 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.

What You Will Learn.

• Understanding of manufacturing and supply chain processes.
• Data-driven-product planning, design, implementation, deployment, and sustainment in a matrixed organization
• Foundational data sources and key performance metrics depended by Raytheon Operations and Supply Chain to build quality data products.
• Designing, troubleshooting, and maintaining tasks, procedures, views, and ETL pipelines.

Qualifications YOU Must Have:

• Typically requires a University Degree and minimum 2 years of prior relevant experience or an Advanced Degree.
• Must be a U.S. Citizen.
• 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).

Qualifications We Prefer:

• 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.
• Working knowledge of Agile software development methodologies.
• Self-motivated and proactive problem solver with demonstrated creative and critical thinking capabilities.
• 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..
• Knowledge of advanced Excel, pivot tables, Power Query.
• Experience with Manufacturing, Operations, and/or Supply Chain process and systems.

What We Offer:

Some of our competitive benefits packages include:

• Medical, dental, and vision insurance
• Three weeks of vacation for newly hired employees
• Generous 401(k) plan that includes employer matching funds
• Participation in the Employee Scholar Program (ESP)
• Life insurance and disability coverage
• Employee Assistance Plan, including up to 8 free counseling sessions
• And more!

Do you want to be part of a new, exciting initiative to combine foundational IT with new digital technologies? 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!

* Please consider the following role type definitions as you apply for this role.

Hybrid: Employees who are working in Hybrid roles will work regularly both onsite and offsite. Ratio of time working onsite will be determined in partnership with your leader.

Regardless of your role type, collaboration and innovation are critical to our business and all employees will have access to digital tools so they can work with colleagues around the world – and access to Collins sites when their work requires in-person meetings.

At Collins, the paths we pave together lead to limitless possibility. And the bonds we form – with our customers and with each other -- propel us all higher, again and again.

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.