Analytics Manager, Pension Investments (Hybrid) at RTX

Date Posted:Country: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 companys 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 185000 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 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 controland 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 experienceStrong curiosity for investment management; experience a plusStrong 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 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 insuranceThree weeks of vacation for newly hired employeesGenerous 401(k) plan that includes employer matching funds and separate employer retirement contribution including a Lifetime Income Strategy optionTuition reimbursement programStudent Loan Repayment ProgramLife insurance and disability coverageOptional coverages you can buy pet insurance home and auto insurance additional life and accident insurancecritical illnessinsurance group legal ID theft protectionBirth adoption parental leave benefitsOvia Health fertility and family planningAdoption Assistance Autism BenefitEmployee Assistance Plan including up to 10 free counseling sessionsHealthy You Incentives wellness rewards programDoctor on Demand virtual doctor visitsBright Horizons child and elder care servicesTeladoc Medical Experts second opinion programAnd more!Learn More & Apply Now!Please 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 attendselect 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 101000 USD - 203000 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 candidates 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 companys 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 TermsRequired Experience:Manager Key Skills Adobe Analytics,Data Analytics,SQL,Attribution Modeling,Power BI,R,Regression Analysis,Data Visualization,Tableau,Data Mining,SAS,Analytics Employment Type : Full-Time Experience: years Vacancy: 1 Monthly Salary Salary: 203000 - 203000