RTX-posted 4 days ago
Full-time • Manager
Hybrid • Farmington, CT
5,001-10,000 employees

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.

  • 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.
  • 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.
  • 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.
  • 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!
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service