Note: The job is a remote job and is open to candidates in USA. RTX is an aerospace and defense company developing technologies and solutions for complex national security and aviation challenges. Raytheon is seeking a Data Engineer to design and develop data ingestion, transformation, modeling, and analytics solutions while collaborating with data scientists, analysts, architects, and other stakeholders. The role focuses on scalable data pipelines, data quality, security, compliance, and governance.
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 andDatabricks
- 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. U.S. citizenship is required, as only U.S. citizens are eligible for a security clearance
- 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
- 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.
- Remote work arrangement; employees working in remote roles will work primarily offsite (from home).
Company Overview