Note: The job is a remote job and is open to candidates in USA. RTX is the world largest aerospace and defense company, and they are seeking a highly skilled and motivated Data Engineer to join their Digital Technology, Data, Analytics & AI (DAAI) team. The role involves designing and developing data solutions, collaborating with various stakeholders, and ensuring the reliability and trustworthiness of data solutions to drive business impact decision-making.
Responsibilities
- Design, develop, and maintain scalable and efficient data pipelines to process data from various sources using tools such as Matillion, HVR and Databricks
- Collaborate with data scientists, analysts, architects and other stakeholders to understand and document 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, design patterns, and data governance mandates
- Document data processes, workflows, and technical specifications
- Conduct data analysis to support business insights and decision-making
Skills
- Typically requires a University degree or equivalent experience and a minimum of 5 years of prior relevant experience or an Advanced Degree in a related field and minimum 3 years experience
- Experience with Snowflake data warehousing and ETL transformation tools
- Experience with SQL and Python coding
- 3 years experience with Data modeling methodologies (Data Vault 2.0) and using Erwin or similar 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
- Proficiency in data integration tools such as Matillion
- Proficiency in API integration (REST) and associated exchange security patterns
- Strong data modeling skills and experience with data architecture
- Familiarity with data governance and data security practices
- Experience with data analysis and generating data requirements
- Strong problem-solving skills and the ability to work in a fast-paced, collaborative environment
- Experience in the aerospace and defense industry
- Experience with cloud platforms, services and tools
- Excellent communication and interpersonal skills
- Experience with PowerBI dashboard development
Benefits
- 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.
- 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.
Company Overview