Data Engineer

Raytheon is dedicated to helping the nation and allies defend freedoms and deter aggression. They are seeking a highly skilled and motivated Data Engineer responsible for designing and developing data solutions, ensuring data quality and integrity, and collaborating with various stakeholders to leverage data for business decision-making.

Responsibilities:

• 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

Requirements:

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