Data Engineer

RTX•US-AZ-REMOTE, AZ

20h•$86,800 - $165,200•Remote

About The Position

Raytheon is seeking a highly skilled and motivated Data Engineer to join our Digital Technology, Data, Analytics & AI (DAAI) 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. Your expertise as a data engineer will help us leverage data to drive business impact decision-making and enhance our aerospace and defense capabilities.

Requirements

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.

Nice To Haves

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

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.