Principal Specialist, FP&A

Prattwhitney; El Segundo (CA); Hybrid; USD 95,000 - 170,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

RTX's Finance Business Process team is seeking a motivated professional to design and maintain automated data ingestion, transformation, and validation pipelines to support finance use cases.

You will develop high-quality datasets and analytics using SQL, Python, and Snowflake, partner with SAP, BW, and other owners, and drive continuous improvement through Agile practices.

Qualifications

• Bachelor's degree with 5+ years of relevant experience, or an Advanced Degree with 3+ years.
• Experience with BI tools (PowerBI/Tableau).
• Experience with Snowflake, Alteryx, GitHub, Atlassian Suite, Azure Data Factory, or similar ETL/ELT tools.
• Experience with SQL and Python.
• U.S. citizenship is required.

Responsibilities

• Design, build, and maintain automated data pipelines for Finance use cases.
• Develop datasets, financial models, and analytics using SQL, Python, and Snowflake.
• Collaborate with system owners (PRISM, APEX, SAP, BW) to map data and troubleshoot issues.
• Perform data quality assessments and remediation to improve data trustworthiness.
• Document data flows, governance, and transformation logic; drive Agile sprints in Jira.
• Translate complex outputs into clear insights for Finance leadership.
• Support key Finance processes and bridge gaps with automation and technology.

Skills

SQL

Python

Analytics

Statistical modeling

Education

Bachelor's degree in a relevant field

Advanced degree in a relevant field

Tools

PowerBI

Tableau

Snowflake

Alteryx

GitHub

Atlassian Suite

Azure Data Factory

SAP BW

Job description

Date Posted: 2026-09-14 Country: United States of America Location: US-CA-EL SEGUNDO-E02 ~ 2002 E El Segundo Blvd ~ BLDG E02 Position Role Type: Hybrid U.S. Citizen, U.S. Person, or Immigration Status Requirements: U.S. citizenship is required, as only U.S. citizens are authorized to access information under this program/contract. Security Clearance Type: None/Not Required Security Clearance Status: Not Required

At RTX, the world's 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 Finance Business Process team is looking for a highly motivated individual interested in supporting Raytheon Finance systems and processes. This role requires the ability to lead and develop complex process improvement initiatives. Candidate will be a change agent who drives process harmonization and continuous improvement across Finance. This high-visibility position offers the opportunity to work with modern business intelligence and analytics tools, while partnering with technical and non-technical stakeholders from the Raytheon Business including Digital Technologies, Enterprise Services, Finance and other Functions.

Hybrid: Employees who are working in Hybrid roles will work regularly both onsite and offsite. Ratio of time working onsite will be determined in partnership with your leader. As part of our commitment to maintaining a secure hiring process, candidates may be asked to attend select steps of the interview process in-person at one of our office locations, regardless of whether the role is designated as on-site, hybrid or remote.

What You Will Do

Design, build, and maintain automated data ingestion, transformation, and validation pipelines to support Finance use cases. Develop high-quality datasets, financial models, and analytics solutions using SQL, Python, and Snowflake. Partner with PRISM, APEX, SAP, BW, and other system owners to map data, troubleshoot issues, and ensure accurate and timely delivery of financial data. Perform root-cause analysis, data quality assessments, and remediation work to improve data trustworthiness and accessibility. Document data flows, business rules, and transformation logic in alignment with Data Governance requirements. Collaborate cross-functionally with Finance, Digital Technology, and Program teams to understand requirements and ensure alignment of data products. Manage your work in Agile sprints and maintain work visibility through Jira/Atlassian tools. Drive continuous improvement efforts to streamline workflows, reduce manual touchpoints, and accelerate delivery timelines. Translate complex technical outputs into clear, actionable insights for Finance leadership. Support key business processes that affect the entirety of Raytheon Finance. Collaborates with a team that delivers standardized Big-Data reporting, dashboarding, as well as bridging critical process gaps with automation and technology. Partner with SAP core teams, Digital Technologies, and Enterprise Services groups to drive enhancements to business processes.

Qualifications

You Must Have Typically requires a Bachelor's and a minimum of 5 years prior relevant experience, or an Advanced Degree and a minimum of 3 years’ experience.

• Experience with business intelligence tools, such as PowerBI or Tableau.
• Experience with analytics and/or statistical modeling.
• Experience with Snowflake, Alteryx, GitHub, Atlassian Suite, Azure Data Factory, or similar ETL/ELT tools.
• Experience with skills like SQL and Python.
• U.S. citizenship is required, as only U.S. citizens are authorized to access information under this program/contract.

Qualifications We Prefer Ability to meet critical deadlines while managing a diverse workload. Proven ability to influence, lead, and work cross-functionally to achieve results. Effective communication skills to include ability to summarize, package, and present information to all levels of management. Has Tech-Stack (Snowflake, Matillion, Alteryx, Immuta, Github/Bitbucket, Jira/Dev_Ops, Azure/AWS, Microsoft BPEs, Visio, Python, C#, SQL, Atlassian Suite) Intermediate to proficient with either SQL, Python, {M}, DAX, VBA, or JSON. Strong understanding of Data Governance and Agile Methodology. Practical Raytheon Finance experience with any of the following: Program Controls, FP&A, Eng Finance, OSC Finance, E&P, or any other Functional Finance Proven ability to independently lead complex efforts and drive results on accelerated timeframes. Professional focus and experience with Continuous Improvement (CORE, Six Sigma, etc). Experience with PRISM and APEX (SAP), Business Warehouse (BW), Rplan, NGW/PM Tools, or similar financial systems. Experience in large dataset analysis, developing financial models, and understanding financial baseline performance metrics. Intermediate to proficient skill set with Power Query M, DAX, VBA, or JSON

What We Offer

Our values drive our actions, behaviors, and performance with a vision for a safer, more connected world. At RTX we value: Trust, Respect, Accountability, Collaboration, and Innovation.

The salary range for this role is 95,500 USD – 181,700 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.

RTX is an aerospace and defense company that provides advanced systems and services for commercial, military and government customers worldwide. It comprises three industry-leading businesses – Collins Aerospace, Pratt & Whitney, and Raytheon. Its 195,000 employees enable the company to operate at the edge of known science as they imagine and deliver solutions that push the boundaries in quantum physics, electric propulsion, directed energy, hypersonics, avionics and cybersecurity. The company, formed in 2020 through the combination of Raytheon Company and the United Technologies Corporation aerospace businesses, is headquartered in Arlington, Virginia.