Analytics Manager, Pension Investments

Date Posted:2025-12-11Country:United States of AmericaLocation:UT6: 4 Farm Springs 4 Farm Springs Road, Farmington, CT, 06032 USAPosition Role Type:HybridU.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 RequiredRTX 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: 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. 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. 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. 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. 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. 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. Collaborate with internal data science and IT teams to evaluate AI platforms. Qualifications You Must Have: 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. What We Offer:Some of our competitive benefits package includes: 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 Learn More & Apply NowPlease consider the following role type definitions as you apply for this role: 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. Preferred Location: Farmington CT. Relocation is not available for this position. 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.The salary range for this role is 101,000 USD - 203,000 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.Privacy Policy and Terms:Click on this link to read the Policy and Terms