Sr. Data Engineer, Supply Chain (*Onsite)

Date Posted:

2024-06-28

Country:

United States of America

Location:

HIA32: Cedar Rapids, IA 400 Collins Rd NE , Cedar Rapids, IA, 52498-0505 USA

Position Role Type:

Onsite

The Operations and Supply Chain Data Engineer at Collins Aerospace will play a pivotal role in designing, maintaining, and optimizing the data infrastructure for the Supply Chain Analytics team. This team is responsible for delivering highly accurate and reliable data to a diverse range of clients, from individual contributors handling day-to-day tasks to executive leaders shaping our strategic direction across the enterprise.

As the Data Engineer for the team, you will be responsible for designing, developing, and maintaining our data pipelines, databases, and analytical systems. This role involves collaborating with cross-functional teams to gather requirements, implement data solutions, and ensure the reliability and efficiency of our data infrastructure. You will not only work on optimizing the current landscape but also design and propose the next generation of data infrastructure.

***This position is classified as onsite; however, if you live within a reasonable commute of a Collins Aerospace location within your region, you may work onsite from the following locations:  

Salt Lake City, UT; West Valley City, UT; Cedar Rapids, IA; Coralville, IA; Rockford, IL; Fort Wayne, IN; Binghamton, NY; Mountainhome, PA; Vergennes, VT; Hampton, NH; Marlborough, MA; Chesire, CT; Windsor Locks, CT; Medford, NY; Fulton, MD; Aberdeen Proving Ground, MD; Annapolis Junction, MD; Sterling, VA; Simpsonville, SC; Largo, FL; St. Petersburg, FL; Houston, TX; Richardson, TX; Dallas, TX; McKinney, TX; Colorado Springs, CO; Sand Diego, CA; Carlsbad, CA; Anaheim, CA;

Collaboration and innovation are critical to our business and you will have access to digital tools so you can work with colleagues around the world – and access to Collins sites when your work requires in-person meetings. 

What You Will Do:

• Build and maintain data warehouses, data pipelines, and other storage solutions to support Supply Chain Business Intelligence, reporting, and analytics needs.
• Design, implement, and maintain scalable data pipelines for extracting, transforming, and loading (ETL) data from various sources into our data warehouse.
• Work with data analysts to understand data requirements and implement solutions for data modeling, analysis, and visualization.
• Monitor data pipeline and system performance, troubleshoot issues, and implement optimizations to improve reliability, scalability, and efficiency.
• Support leadership in identifying, designing, and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes.
• Stay up to date with emerging technologies and industry trends in data engineering and contribute ideas for continuous improvement of data infrastructure and processes.
• Work with peers to optimize performance/efficiency in reporting and analytics for supply chain and operations.

Qualifications You Must Have:

• Typically requires a degree in Science, Technology, Engineering or Mathematics (STEM) unless prohibited by local laws/regulations and minimum 8 years prior relevant experience or an Advanced Degree in a related field and minimum 5 years of experience or in absence of a degree, 12 years of relevant experience
• U.S. citizenship is required, as only U.S. citizens are authorized to access information under this program/contract 
• Proven experience in building and maintaining data pipelines with an understanding of data modeling, schema design, and data architecture and data validation.  Solid understanding of ETL processes and tools like SSIS.
• Hands-on experience with data mining, data exploration, data analysis and visualization tools (Tableau, Power BI, etc.) and the creation of supporting documentation. 
• Familiarity with Python, and other technologies relevant to data science and analytics.  Proficiency in T-SQL experience with Snowflake is a plus.
• Ability to prepare data for descriptive, prescriptive, and predictive modeling.

Qualifications We Prefer:

• Comprehensive quantitative skills, familiarity with statistical modeling, and forecasting.
• Knowledge and understanding of Supply Chain Management Principles
• Programming skills in Python, C# and .NET/MVC, Web Architecture is a plus.  Experience with SAP, Artificial Intelligence (AI) is a bonus.
• The ability and willingness to coach and mentor junior team members on principles of Data Engineering.
• The ability to accurately estimate project tasks and timelines with excellent communication skills and ability to present to senior leadership.

What We Offer:

• This position may be eligible for relocation

• Medical, dental, and vision insurance  

• Three weeks of vacation for newly hired employees  

• Generous 401(k) plan that includes employer matching funds and separate employer retirement contribution, including a Lifetime Income Strategy option  

• Tuition reimbursement program 

• Student Loan Repayment Program  

• Life insurance and disability coverage  

• Optional coverages you can buy pet insurance, home and auto insurance, additional life and accident insurance, critical illness insurance, group legal, ID theft protection 

• Birth, adoption, parental leave benefits 

• Ovia Health, fertility, and family planning  

• Adoption Assistance           

• Autism Benefit  

• Employee Assistance Plan, including up to 10 free counseling sessions  

• Healthy You Incentives, wellness rewards program 

• Doctor on Demand, virtual doctor visits  

• Bright Horizons, child and elder care services 

• Teladoc Medical Experts, second opinion program  

• This position may be eligible for relocation

• And more!  

Learn More & Apply Now!

Diversity drives innovation; inclusion drives success. We believe a multitude of approaches and ideas enable us to deliver the best results for our workforce, workplace, and customers. We are committed to fostering a culture where all employees can share their passions and ideas so we can tackle the toughest challenges in our industry and pave new paths to limitless possibility.  

#reempowerprogram 

This role is also eligible for the Re-Empower Program.  The Re-Empower Program helps support talented and committed professionals as they rebuild their capabilities, enhance leadership skills, and continue their professional journey.  Over the course of the 14-week program, experienced professionals will gain paid, on-the-job experience, have an opportunity to participate in sessions with leadership, develop personalized plans for success and receive coaching to guide their return-to-work experience.  Upon completion of the program, based on performance and contributions participants will be eligible for a career at RTX.  

Minimum Program Qualifications: 

• Be on a career break of one or more year at time of application 

• Have prior experience in functional area of interest 

• Have interest in returning in either a full-time or part-time position 

Do you want to be a part of something bigger? A team whose impact stretches across the world, and even beyond? At Collins Aerospace, our Mission Systems team helps civilian, military and government customers complete their most complex missions — whatever and wherever they may be. Our customers depend on us for intelligent and secure communications, missionized systems for specialized aircraft and spacecraft and collaborative space solutions. By joining our team, you’ll have your own critical part to play in ensuring our customer succeeds today while anticipating their needs for tomorrow. ​

Are you up for the challenge? Join our mission today. https://www.youtube.com/watch?v=dUId2ps4pB0

Operations, Supply Chain and EH&S: 

The next chapter of our future as an aerospace company is here, and we are excited about what this means for our employees and customers! Get onboard the Collins Aerospace Operations team and play a part in managing our innovative products from inception to delivery. The Operations team continues to grow and aims to strengthen the connection of Manufacturing Operations, Supply Chain and Environment, Health & Safety (EH&S) across Collins Aerospace. In this dynamic environment, you will have the opportunity to network across our businesses and functions, all while improving the productivity, quality and efficiency of our operations worldwide.

Onsite: Employees who are working in Onsite roles will work primarily onsite. This includes all production and maintenance employees, as they are essential to the development of our products. 

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.  

Apply now and be part of the team that’s redefining aerospace, every day.

The salary range for this role is 96,000 USD – 200,000 USD. The salary range provided is a good faith estimate representative of all experience levels. RTX considers several factors when extending an offer, including but not limited to, the role, function and associated responsibilities, a candidate’s work experience, location, education/training, and key skills.

Hired applicants may be eligible for benefits, including but not limited to, medical, dental, vision, life insurance, short-term disability, long-term disability, 401(k) match, flexible spending accounts, flexible work schedules, employee assistance program, Employee Scholar Program, parental leave, paid time off, and holidays. Specific benefits are dependent upon the specific business unit as well as whether or not the position is covered by a collective-bargaining agreement.

Hired applicants may be eligible for annual short-term and/or long-term incentive compensation programs depending on the level of the position and whether or not it is covered by a collective-bargaining agreement. Payments under these annual programs are not guaranteed and are dependent upon a variety of factors including, but not limited to, individual performance, business unit performance, and/or the company’s performance.

This role is a U.S.-based role. If the successful candidate resides in a U.S. territory, the appropriate pay structure and benefits will apply.

RTX anticipates the application window closing approximately 40 days from the date the notice was posted. However, factors such as candidate flow and business necessity may require RTX to shorten or extend the application window.

RTX is An Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status, age or any other federally protected class.

Privacy Policy and Terms:

Click on this link to read the Policy and Terms