RTX · 1 month ago
Analytics Manager, Pension Investments (Hybrid)
UT6: 4 Farm Springs 4 Farm Springs Road, Farmington, CT, 06032 USA
Full-time
Hybrid
Senior Level
$101K/yr - $203K/yr
5+ years expRTX Corporation is an Aerospace and Defense company that provides advanced systems and services for commercial, military and government customers worldwide. They are seeking an Analytics Manager to support their pension investments team, focusing on analytical and technical support across investment oversight and performance monitoring.
AerospaceManufacturingSecuritySensorTelecommunications
No H1B
Responsibilities
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, NumPy) 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, statsmodels). 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 data processes in shared repositories or data catalogs
Innovation & Process Improvement: Evaluate and implement new tools and techniques to enhance data analytics, visualization, and automation capabilities. Contribute to ongoing efforts to modernize investment operations and improve efficiency. Technical Detail: Prototype solutions using tools such as Tableau or Python. Integrate APIs from external providers into existing data infrastructure, and document enhancements to support scalability and reusability
AI and Advanced Analytics Integration: Support the future implementation of artificial intelligence and machine-learning tools to enhance data-driven decision-making and operational efficiency. Identify use cases such as predictive analytics, anomaly detection, and natural-language querying of investment data, contracts, and investment memos. Technical Detail: Collaborate with internal data science and IT teams to evaluate AI platforms
Qualification
Required
Typically requires a degree in Science, Technology, Engineering or Mathematics (STEM) and minimum 8 years prior relevant experience or an Advanced Degree in a related field and minimum 5 years of experience or in absence of a degree, 12 years of relevant experience
Strong curiosity for investment management; experience a plus
Strong technical skills with experience using Snowflake (or other database management systems), Tableau (or other visualization tools), and Python (or other programming languages)
Advanced proficiency in Excel and PowerPoint
Strong analytical and problem-solving skills with an attention to detail
Excellent written and verbal communication skills
Highly motivated self-starter with the ability to manage multiple priorities and deadlines
Benefits
Medical, dental, and vision insurance
Three weeks of vacation for newly hired employees
Generous 401(k) plan that includes employer matching funds and separate employer retirement contribution, including a Lifetime Income Strategy option
Tuition reimbursement program
Student Loan Repayment Program
Life insurance and disability coverage
Optional coverages you can buy pet insurance, home and auto insurance, additional life and accident insurance, critical illness insurance, group legal, ID theft protection
Birth, adoption, parental leave benefits
Ovia Health, fertility, and family planning
Adoption Assistance
Autism Benefit
Employee Assistance Plan, including up to 10 free counseling sessions
Healthy You Incentives, wellness rewards program
Doctor on Demand, virtual doctor visits
Bright Horizons, child and elder care services
Teladoc Medical Experts, second opinion program
And more!
Company
RTX
RTX is comprised of three market-leading businesses – Collins Aerospace, Pratt & Whitney and Raytheon – working as one to answer the biggest questions and solve the hardest problems in aerospace and defense.
10001+ employees
Funding
Current Stage
Public CompanyTotal Funding
$3.2MKey Investors
LIFT Ecosystem Accelerator
2024-02-22Grant· $0.2M
2019-06-09Acquired
2010-01-14Grant· $3M
Leadership Team
Daniel Conroy
Chief Technology Officer - Digital
Kevin DaSilva
Corporate Vice President & Treasurer
Recent News
Business Insider
2026-01-09
Morningstar.com
2026-01-08
2026-01-08
Company data provided by crunchbase