Collins Aerospace

Data Engineer (Remote)

Job description

Collins Aerospace is continuing to grow our Business Intelligence and Data Services to meet current and future business needs. The Data Services team has an immediate need for a Data Engineer to support activities in our Cloud Data Warehouse environment for use across the enterprise to drive the digital transformation of the business. The position will provide well rounded exposure to data warehouse architecture, software engineering, data management, data storage, data compute, distributed systems, modeling, and analysis. This assignment will require the candidate to work seamlessly with members of the Data & Platforms organization and our business partners. As part of the Digital Technologies Data Services team, you'll help drive digital transformation by contributing to our growing Cloud initiative. This initiative is a key component to the enablement of our portfolio of aerospace digital products.

This individual can sit at any Collins Aerospace domestic location or remote.

Primary Responsibilities:

  • Support the operation of the Cloud Data Warehouse (Snowflake, Redshift, Postgres) and Data Lake in a global environment.

  • Develop views, materialized views, and SQL scripts

  • Design, and deliver cloud-native, hybrid, and multi-cloud workloads

  • Migrate enterprise workloads to Snowflake using industry-standard as well as proprietary methodologies

  • Work with internal business customers and software development teams to gather and document requirements for data publishing and data consumption via data warehouse, data lake, and analytics solutions.

  • Automate cloud deployments, as well as build CI/CD pipeline to support Cloud-Based workloads

  • Coordination on migration, architecture, and platform decisions with the digital technology team

  • Work as a team member across the complete life cycle of delivery including architecture, design, development, test, and document integration solutions, custom development, and data migration elements of business applications

  • Define and clearly communicate requirements to all stakeholders

  • Must be able to perform duties with moderate to low supervision

Basic Qualifications:

  • Bachelor’s degree and 8 years of prior relevant experience OR

  • Advanced Degree in a related field and minimum 5 years of experience OR

  • In absence of a degree, 12 years of relevant experience is required

  • Must be a U.S. Person/Permanent Resident “Green Card” holder

  • Must be willing and able to travel 10% of the time

  • Snowflake is a must have

  • Experience with ETL tools such as Informatica, Talend, or Matillion

  • Strong SQL skills

Preferred Qualifications:

  • Hands-on development experience with SnowSql and Snowflake utilities

  • Experience in Snowpipe for handling Streaming data is a plus

  • Experience with cloud-based data warehousing methodologies and modeling techniques

  • Project experience implementing core infrastructure, networking, and cloud-based services for business teams or consumers

  • Experience with legacy migrations to Snowflake

  • Good knowledge of cloud computing

  • Experience migrating and deploying cloud-based solutions

  • Experience supporting Production applications or workloads in a cloud-based environment

  • Useful to have experience with API management and integration (e.g. Apigee)

  • Experience with any one of the data Virtualization tools like Trino, Starburst, Denodo, Data Virtuality, etc. is a big plus

  • Experience in Agile development methodologies

  • Excellent interpersonal (verbal and written) communication skills

Collins Aerospace, a Raytheon Technologies company, is a leader in technologically advanced and intelligent solutions for the global aerospace and defense industry. Collins Aerospace has the capabilities, comprehensive portfolio, and expertise to solve customers’ toughest challenges and to meet the demands of a rapidly evolving global market.

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!

Collins Aerospace Diversity & Inclusion Statement:

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.

WE ARE REDEFINING AEROSPACE.

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

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.

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.

Remote: Employees who are working in Remote roles will work primarily offsite (from home). An employee may be expected to travel to the site location as needed.

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.

Some of our competitive benefits package includes:

  • 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

  • And more!

Nothing matters more to Collins Aerospace than our strong ethical and safety commitments. As such, all U.S. positions require a background check, which may include a drug screen.

Note:

  • Background check and drug screen required (every external new hire in the U.S.)

  • Drug Screen only performed on re-hires who have been gone for more than 1 year

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.

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.