Note: The job is a remote job and is open to candidates in USA. Raytheon is an aerospace and defense company seeking a Data Engineer to join its Digital Technology, Data, Analytics & AI team. The role designs, develops, optimizes, and maintains data workflows, pipelines, models, and analytics solutions while collaborating with data scientists, analysts, architects, and business stakeholders.
Responsibilities
- Design, develop, optimize and maintain scalable and efficient data workflows and pipelines in Matillion leveraging AI-driven automation 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 data requirements and translate them into technical solutions
- Perform data modeling to design and structure databases that support business requirements
- Write and optimize SQL queries for data analysis, transformation and troubleshooting
- 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
Skills
- • Typically requires a University Degree or equivalent experience and a minimum of 8 years of prior relevant experience, or an Advanced Degree in a related field and minimum 5 years experience
- • 5+ years experience as a data engineer performing AI driven data analysis, data modeling, data transformations
- • Strong experience developing and optimizing ETL/ELT (Extract, Transform, Load) processes to ensure data quality and integrity with tools such as Matillion
- • Strong data modeling and architecture skills
- • Experience collaborating with business data owners to understand their business data needs and translate them into clear, actionable, and detailed data requirements
- • Experience with SAP Hana, BW, Multipliers, Infocubes, and OData
- • U.S. Citizen - 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
- The ability to obtain and maintain a U.S. government issued security clearance is required
- Active and existing security clearance required after day 1
- The successful candidate for this role will be required to reside and work from one of the 50 U.S. states (excluding U.S. territories)
- 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
- Engineering/Other Technical Positions: Typically requires a degree in Science, Technology, Engineering or Mathematics (STEM) and a minimum of 8 years of prior relevant experience unless prohibited by local laws/regulations
- • Experience developing AI to explore, understand, and validate data
- • Strong proficiency in SQL experience with relational databases
- • Solid experience with Python for data transformation
- • Experience with Snowflake and SAP for data warehousing
- • Proficiency in data integration tools such as Matillion
- • Proficiency in API integration (REST) and associated exchange security patterns
- • Familiarity with data governance and data security practices
- • 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
- • Familiarity with data catalogs and data quality protocols
- • Demonstrated ability to design and implement data solutions that meet strict security, compliance, and governance standards
- • Understanding of data protection requirements in U.S. government cloud environments (FedRAMP, ITAR, etc.)
Benefits
- Medical insurance
- Dental insurance
- Vision insurance
- 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
- Holidays
- Annual short-term and/or long-term incentive compensation programs for eligible hired applicants, depending on the level of the position and whether or not it is covered by a collective-bargaining agreement
- Remote work primarily offsite (from home) for employees in remote roles
Company Overview