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.
