Analytics Manager, Pension Investments; Hybrid

Position: Analytics Manager, Pension Investments (Hybrid)
** Date Posted:
**** Country:
** United States of America
*
* Location:

** UT6: 4 Farm Springs 4 Farm Springs Road, Farmington, CT, 06032 USA
** Position Role Type:
** Hybrid
* * U.S. Citizen, U.S. Person, or Immigration Status Requirements:
** Must be authorized to work in the U.S. without the company’s immigration sponsorship now or in the future. The company will not offer immigration sponsorship for this position. The company will not seek an export authorization for this role.
** Security Clearance:
** None/Not Required

RTX Corporation 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 Systems, Pratt & Whitney, and Raytheon. Its 185,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, VA.
** The following position is to join our RTX Corporate Investments Team:
** RTX is looking for a talented Analytics Manager to support our pension investments team. In this role you will support the management of over $100 billion in corporate pension and savings plan assets by providing analytical and technical support across investment oversight and performance monitoring. You will focus on leveraging database management systems, data visualization tools, and programming skills to enhance data-driven decision-making for the pension investments team.

This is an
** individual contributor
** hybrid position located in Farmington, CT and will
** require you to be onsite at least three days a week**. This role is not relocation eligible.
*
* What You Will Do:

*** Data Analytics & Visualization
* ** Database Development & Automation:
** Support the buildout and maintenance of the Pension Investments Database, ensuring data accuracy, consistency, and scalability. Use Snowflake, Tableau, Matillion and Python to design and automate ETL pipelines that consolidate data from custodians, consultants, and investment managers.  Technical Detail:
Develop SQL queries, stored procedures, and Snowflake data models to aggregate holdings, performance, and benchmark data. Use Python (pandas, Num Py) to automate ingestion and transformation, and manage workflows through Snowflake.
* ** Visualization & Reporting:
** Design and maintain interactive dashboards in Tableau that provide transparency into asset allocation, performance, liquidity, and risk exposures across pension portfolios. Automate recurring reports and integrate live data feeds to reduce manual effort and improve timeliness.  Technical Detail:
Build Tableau dashboards connected to Snowflake or Excel extracts using live queries. Create calculated fields, parameters, and filters for interactivity, and manage publication and refresh schedules via Tableau.
* ** Analytical Insights & Decision Support:
** Perform data analysis to identify trends and support portfolio management, asset allocation, and performance evaluation. Deliver actionable insights to inform investment strategy, risk management, and monitoring of funded status.  Technical Detail:
Apply statistical and regression analysis in Python (pandas, scikit-learn, stats models). Use time-series techniques to evaluate performance and risk metrics, integrate data feeds from data providers, and apply portfolio simulation methods such as mean-variance optimization or Monte Carlo analysis.
* ** Data Governance & Quality Control:
** Maintain strong data governance by establishing validation checks, documentation standards, and reconciliation processes. Coordinate with IT, accounting, and actuarial teams to ensure accuracy and consistency across systems.  Technical Detail:
Implement automated data validation routines in SQL or Python to flag discrepancies. Use control tables and audit logs within Snowflake, maintain version control and document…