Data Engineer - Snowflake (Remote)

Date Posted:

2024-12-10

Country:

United States of America

Location:

HNC99: Field Office - NC Remote Location, Remote City, NC, 27601 USA

Position Role Type:

Remote

We are seeking a skilled and highly motivated Data Engineer to join our Data & Analytics team in Collins Aerospace. In this role, you will be responsible for designing, developing, and maintaining robust data pipelines and infrastructure using latest technologies. You will work closely with cross-functional teams to support and contribute to the evolution of our data platform and capabilities.

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

What YOU will do:

• Data Engineering: Design, develop, and maintain data pipelines and ETL processes to support data analytics and reporting needs.

• Snowflake: Utilize Snowflake to manage data warehousing, including data modeling, schema design, and optimization.

• Matillion: Implement ETL processes using Matillion to integrate, transform, and load data from various sources into Snowflake.

• SQL: Write complex SQL queries for data retrieval, analysis, and reporting. Optimize queries for performance and efficiency.

• Data Quality: Ensure data quality and integrity by developing and implementing data validation and cleansing procedures.

• Collaboration: Work closely with data engineers, analysts, and business teams to understand data requirements and deliver solutions.

• Troubleshooting and Debugging: Investigate and resolve data issues, performance bottlenecks, and other technical challenges.

• Documentation: Create and maintain documentation for data processes, workflows, and architecture.

Qualifications you must have:

• Must be authorized to work in the U.S. without sponsorship now or in the future. RTX will not offer sponsorship for this position (U.S. Citizen or Green Card Holder).

• 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 or in absence of a degree, 9 years of relevant experience.

• About 3+ years of experience in data engineering role, with proficiency in designing, implementing, and optimizing data pipelines and ETL processes.

• Experience: Proven experience as a Data Engineer with a background in Snowflake, Matillion, Alteryx, and Tableau or relevant ETL and RDBMS technologies.

• SQL Proficiency: Strong SQL skills, including experience with complex queries, joins, and aggregations.

• Data Visualization: Experience developing dashboards and visualizations using Tableau.

• ETL Expertise: Strong understanding of ETL processes and best practices, with hands-on experience using Matillion or relevant tools.

• Problem-Solving: Strong analytical and problem-solving skills, with the ability to troubleshoot and resolve data-related issues.

• Communication: Excellent written and verbal communication skills, with the ability to work effectively with cross-functional teams.

• Time Management: Strong organizational and time-management skills, with the ability to prioritize tasks and meet deadlines.

• Adaptability: Comfortable working in a fast-paced, dynamic environment with changing priorities.

What We Offer:

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! 

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.

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.

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. 

*This position is remote; however, if you live within a reasonable commute of a Collins site with other colleagues you interact with, your manager will discuss whether there is a degree of onsite presence associated with this role.

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.

                                                                                                

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

The salary range for this role is 77,000 USD - 163,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