Data Engineer III - REMOTE, US
Role details
Job location
Tech stack
Job description
The Business Analytics team in Raytheon Digital Technology Operations, Supply Chain, and Quality is looking for a data engineer focused on the development and deployment of data-driven systems solutions designed to improve performance in the planning and execution of our business. Primary areas of focus will include analyzing source enterprise resource planning (ERP) system information, curating and developing complex datasets that achieve business objectives while meeting data engineering best-practices.
Our team collaborates closely with stakeholders and analysts within operations, supply chain, quality, and other core execution functions to identify supply and demand risks and provide recommendations through performant and trusted data products and complex data models. The role offers opportunity to participate in building various business critical solutions as well as the opportunity to solve unique business problems that arise on ad-hoc basis.
The ideal candidate needs to be passionate about proper data engineering standards with analytical mindset to drive action through facts and data, possess the ability to effectively organize and distill data, proactively ask appropriate questions to understand hypotheses and requests, and analyze and communicate complex data in a compelling manner to a variety of audiences. The candidate will have the opportunity to build strong partnerships and networks across the organization to learn the Raytheon business and grow as in a fast-paced environment.
What You Will Do
- Develop and optimize complex batch and near-real-time SQL queries to meet product requirements and business needs.
- Architect, implement, deploy, and maintain data-driven solutions in Snowflake and Databricks.
- Develop and manage data pipeline supporting multiple reports, tools, and applications.
- Conduct advanced statistical analysis to yield actionable insights, identify correlations/trends, measure performance, and visualize disparate sources of data.
- Lead and engage in requirement planning, trainings, and presentations with technical and non-technical teams
What You Will Learn
- SAP ERP/MES data sets, transactions, and backend databases
- Understanding of manufacturing and supply chain processes
- Foundational data sources and key performance metrics depended by Raytheon Operations and Supply Chain to build quality data products
- Designing, troubleshooting, and maintaining tasks, procedures, views, and ETL pipelines
Requirements
- Typically requires a University Degree or equivalent experience and minimum 5 years prior relevant experience, or An Advanced Degree in a related field and minimum 3 years of experience.
- Strong experience with Snowflake and relational SQL database design, implementation, and optimization.
- Hands-on experience with data cleansing, curation, manipulation, mining, and analysis across disparate systems.
- Practical experience with Git-based configuration control and CI/CD pipelines (GitHub Actions, Jenkins, etc.)., * Degree in a technical field (CS, engineering, math, economics) and strong SQL-based ETL/ELT expertise.
- Experience with Python (Pandas), schema/deployment tools (SchemaChange, Liquibase), and data orchestration platforms (Snowflake Tasks, ADF, Matillion, etc.).
- Knowledge of data modeling, Agile development, API-driven data solutions, and relational web app databases.
- Proficiency with analytics and visualization tools (Tableau, Power BI, advanced Excel) and statistical/ML concepts.
- Experience with manufacturing, supply chain, or operations systems; familiarity with ERP/MRP tools (SAP, Kinaxis).
Benefits & conditions
The salary range for this role is 86,800 USD - 165,200 USD. The salary range provided is a good faith estimate representative of all experience levels. RTX considers several factors when extending an offer, including but not limited to, the role, function and associated responsibilities, a candidate's work experience, location, education/training, and key skills.
Hired applicants may be eligible for benefits, including but not limited to, medical, dental, vision, 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, and holidays. Specific benefits are dependent upon the specific business unit as well as whether or not the position is covered by a collective-bargaining agreement.
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. Payments under these annual programs are not guaranteed and are dependent upon a variety of factors including, but not limited to, individual performance, business unit performance, and/or the company's performance.
This role is a U.S.-based role. If the successful candidate resides in a U.S. territory, the appropriate pay structure and benefits will apply.
RTX anticipates the application window closing approximately 40 days from the date the notice was posted. However, factors such as candidate flow and business necessity may require RTX to shorten or extend the application window.
RTX is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or veteran status, or any other applicable state or federal protected class. RTX provides affirmative action in employment for qualified Individuals with a Disability and Protected Veterans in compliance with Section 503 of the Rehabilitation Act and the Vietnam Era Veterans' Readjustment Assistance Act.
