Principal Data Engineer, Data Engineering (Remote)

Date Posted:

2023-02-05-08:00

Country:

United States of America

Location:

HTX99: Field Office - TX Remote Location, Remote City, TX, 73301 USA

Position Role Type:

Remote

Aviation connects the world and Connected Aviation Solutions (CAS) connects Aviation. Sustainably. Seamlessly. Securely. The Data Management & Data Science (DM&DS) team is tasked with the end-to-end responsibility to ensure that CAS data assets are managed with integrity and quality prior to consumption by our critical customer facing applications - whether via API’s, analytics and/or data visualizations. As a Principal data engineer on the DM&DS team, you will be responsible for the design, development and maintenance of data processes and pipelines supporting critical CAS Strategic Business Unit (SBU) Data initiatives in support of the Digital Transformation of CAS as well as for the cross-SBU Connected Ecosystem.  In this endeavor, you will be working closely with data architecture, data analytics & visualization teams leaders across CAS, SBU and Digital Technology (DT) teams to ensure the technical solutions are efficient, scalable, and meet long term Connected Ecosystem needs.

Primary Responsibilities:

• Design, develop and support the processes and pipelines for moving data throughout the CAS and cross SBU environments.
• Develop automation and monitoring processes that support the data pipelines
• Work closely with the architecture team to implement modern data repositories that support the CAS use cases (Pipelines, API’s, Data Science, Applications and Visualizations)
• 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
• Support the operation of the CAS and Digital Technology owned Data Platforms, Data Warehouse and Data Lakes with a view to leveraging capabilities and resources over-time
• Work with the CAS and DT Enterprise Data Architects to automate cloud deployments, as well as build CI/CD pipeline to support Cloud-Based workloads. Develop views, materialized views, and SQL scripts
• Work with the CAS and DT Enterprise Data Architects to recommend investments or changes in technology, resources, procedures, equipment, systems, or other assets to improve the quality of the organization’s projects.
• May travel domestically and internationally up to 15%.

Qualifications / Required Skills:

• Bachelor’s degree (typically in Science, Technology, Engineering or Mathematics (STEM)) and a minimum of 8 years of prior relevant experience unless prohibited by local laws/regulations.
• 5+ years of demonstrated engineering leadership in a relevant engineering function, such as software/service development and deployment, system design and integration, or data analytics.
• Strong in scripting/coding in Python, PySpark and SQL
• Strong Expertise in cloud computing such as AWS and/or Azure
• Experience with cloud-based data warehouse and data lake environments
• Experience with ETL and Analytics tools
• Strong experience with big data processing using DataBricks.
• Experience supporting Production applications or workloads in a cloud-based environment
• Experience in Agile development methodologies
• Experience working with structured, unstructured, and semi-structured data
• Experience building data pipelines, transformations, infrastructure, and monitoring solutions
• Experience with data quality and/or data preparation techniques
• Experience in data normalization, data modeling and streaming technologies
• Experience with infrastructure as code scripting with CloudFormation, Terraform and ARM
• Strong in DevOps concepts including automated testing, build automation, automated deployment using CI/CD pipelines
• Experience with Source Code Repository tools such as GitHub or Similar
• Excellent interpersonal (verbal and written) communication skills
• US Citizen or GC Holder

Preferred Qualifications:

• Experience with database solutions including SQL, Postgres, JSON, NoSQL, Snowflake, Synapse, and Delta as well as AWS and Azure based database technologies
• Personal GitHub repo with code and content that can be talked to during the interview process
• Experience with legacy migrations
• Experience with database solutions including Postgres, JSON, NoSQL, Snowflake, Synapse, and Delta as well as AWS and Azure based database technologies
• Experience in the operationalization of data science models
• Experience with Data Virtualization and Microservices
• Scripting/coding in C#
• Proficiency in Networking, Security, and Infrastructure
• Aerospace knowledge and experience - specifically Airlines/Business Aviation or Airports. Knowledge of ADS-B data is a plus
• Working knowledge of Collins Management System
• Knowledge of IT audit, regulatory, and compliance in the Aerospace and Defense industry
• Cloud-related certifications
• Awareness and appreciation for data governance, quality, and security principles

Connected Aviation Solutions:

Our Connected Aviation Solutions team provides advanced information management systems, products and services that enable the connected ecosystem by bringing together Collins’ unique breadth of aviation, surface transportation and critical infrastructure products with our smart digital solutions to help us enhance every aspect of the end-to-end travel experience. We help airlines, airports, business aircraft and rail operators turn data into value to streamline operations, increase efficiency and reduce cost, enhance the passenger experience and contribute to sustainable flight. By combining the best networks, connectivity and data/analytics solutions, we’re solving big problems for our customers and the world, while enhancing the security and connectivity of systems both on and off the aircraft, to help operators and passengers stay more connected and informed and create a more sustainable, efficient, reliable and enjoyable travel experience. Aviation connects the world. Our Connected Aviation Solutions team connects aviation. Sustainably. Seamlessly. Securely.

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.

We make modern flight possible for millions of travelers and our military every second.  Our major product lines are on-board virtually every aircraft flying. Be it keeping passengers safe with our emergency power generation systems or creating a positive in-flight experience through reliable cabin pressure controls and quieter engines, Power & Controls focuses on delivering a best-in-class experience to our customers. We hire the top people in the industry. Their ideas drive our performance, and their integrity keeps our customers happy. Join us as we take flight!

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.

The salary range for this role is 94,000 USD - 196,000 USD; however, Raytheon Technologies considers several factors when extending an offer, including but not limited to, the role and associated responsibilities, a candidate’s work experience, education/training, and key skills.

Raytheon Technologies 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