[Remote] Data Engineer

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