[Hiring] Data Engineer @RTX

Role Description

We are seeking a highly skilled and motivated Data Engineer to join our dynamic team. As a Data Engineer, you will be responsible for designing and developing data solutions including data ingest and consumption workflows, transformation, modelling, and resulting analytics. You will work closely with data scientists, analysts, and other stakeholders to ensure the value, reliability, and trustworthiness of our data solutions.

• Design, develop, and maintain scalable and efficient data pipelines to process data from various sources using tools such as Matillion and Databricks.
• Collaborate with data scientists, analysts, architects and other stakeholders to understand data requirements and translate them into technical solutions.
• Develop and optimize ETL (Extract, Transform, Load) processes to ensure data quality and integrity.
• Utilize Snowflake for data warehousing, ensuring efficient data storage and retrieval.
• Perform data modeling to design and structure databases that support business requirements.
• Write and optimize SQL queries for data transformation.
• Ensure data security and compliance with industry standards and regulations.
• Adhere to and advocate established best practices and design patterns.
• Document data processes, workflows, and technical specifications.
• Conduct data analysis to support business insights and decision-making.

Qualifications

• Typically requires a University Degree or equivalent experience and minimum 8 years prior relevant experience, or An Advanced Degree in a related field and minimum 5 years' experience.
• Experiencing developing and optimizing ETL processes.
• Experience with Python for data transformation.
• Proficiency in API integration (REST) and associated exchange security patterns.
• Experience with cloud platforms, services and tools.
• The ability to obtain and maintain a U.S. government issued security clearance is required. U.S. citizenship is required, as only U.S. citizens are eligible for a security clearance.

Requirements

• Experience in the aerospace and defense industry.
• Experience using data integration tools such as Matillion.
• Experience with Snowflake for data warehousing.
• Data modeling and data architecture experience.
• Strong proficiency in SQL and experience with relational databases.
• Familiarity with data governance and data security practices.
• Experience with data analysis and generating data requirements.

Benefits

• 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.