Data Engineer

Location: US-VA-REMOTE

 Position Role Type: Remote

 U.S. Citizen, U.S. Person, or Immigration Status Requirements: 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

 Security Clearance Type: DoD Clearance: Secret

 Security Clearance Status: Active and existing security clearance required after day 1 At RTX, the world largest aerospace and defense company, 185,000 great minds are united by purpose and inspired to make a difference solving the world’s most complex problems. With our three market leading businesses, world-class operations and investments in research and development, we offer capabilities and opportunity no one else can. Together, we push the boundaries of known science and find new ways to connect and protect our world.  Raytheon brings the strength of more than 100 years of experience and renowned engineering expertise to meet the needs of today’s mission and stay ahead of tomorrow’s threat. We deliver solutions that help our nation and allies defend freedoms and deter aggression, creating a safer, more secure world. Join us and help shape the future of aerospace and defense. 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.

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.

You Must Have:   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.

We Prefer: Experience developing AI to explore, understand, and validate data. Strong proficiency in SQL experience with relational databases. Solid experience with Python for data transformation.