Senior Investment Data Analyst

Posted Yesterday
Be an Early Applicant
West Chester, PA, USA
In-Office
Senior level
Insurance
The Role
Advance investment data, reporting, and technology capabilities by designing scalable data pipelines, monitoring and resolving data exceptions, building reports and dashboards, supporting product management and UAT, improving automation and governance, and partnering cross-functionally to maintain data quality and documentation.
Summary Generated by Built In
The Investment Data Senior Analyst will play a critical role in advancing Venerable's investment data, reporting, and technology capabilities. This position combines investment data expertise with strong analytical and technical skills to design, enhance, and support data-driven solutions that improve scalability, efficiency, and decision-making. Investment data encompasses the full spectrum of information supporting the investment lifecycle, including security reference data, positions, transactions, valuations, risk analytics, and related reporting data. The analyst will work across investment data management, databases, reporting, automation, governance, and operational workflows to deliver high-quality solutions that support business objectives. This position resides within the Investments, Derivatives, and Risk Operations team in Venerable’s Risk department.Venerable is currently working in a hybrid work model, in the office 3 days/week and remote 2 days/week. This role is based in our West Chester, PA office.
Please note this position is not eligible to consider candidates who require current or future visa sponsorship or visa transfer to maintain US work authorization.
Primary Responsibilities:
  • Monitor and troubleshoot data flows from internal and external sources, investigate and resolve investment data exceptions and discrepancies, perform root cause analysis, and implement improvements to strengthen data quality and operational efficiency.
  • Design and implement scalable investment data processes, including data ingestion, pipelines, validation, transformation, reconciliation, and downstream integrations, with a focus on data quality, operational efficiency, and support for analysis and reporting.
  • Support the evolution of investment data solutions through requirements gathering, testing, production support, and issue resolution. Participate in product planning and roadmap discussions to align data capabilities with business objectives.
  • Develop and maintain reports and dashboards to support oversight, financial modeling, risk analysis, and strategic decision-making.
  • Identify opportunities to apply technology, automation, and process redesign to reduce manual effort, improve timeliness, enhance controls, and support future scalability.
  • Serve as a subject matter expert on investment data processes and systems, providing guidance to team members, stakeholders, and project partners.
  • Partner with cross-functional stakeholders (Investment Management, Risk, Operations, Financial Risk Management, Accounting, Treasury, Audit, Hedging, Valuation, and Technology) and external vendors (e.g., risk analytics platforms, investment accounting provider) to support investment-related data initiatives.
  • Advance investment data governance by maintaining data dictionaries, metadata, and process documentation to promote consistency, transparency, and reusability.
The candidate must possess the following skills and experiences:
  • 5+ years of experience in financial services, including direct experience with investment data management and solution design.
  • Demonstrated ability to design and optimize business processes and tools to improve workflow efficiency, reduce manual effort, and mitigate risk.
  • Proficiency in SQL, with a strong preference for experience working with large datasets and database design.
  • Proven ability to support product management processes, including requirements gathering and user acceptance testing (UAT).
  • Experience with data transmission, loading, reconciliation, reporting, and downstream integration.
  • Advanced Microsoft Excel skills, including experience with complex formulas, pivot tables, and data analysis tools.
  • Familiarity with investment instruments and financial markets, particularly fixed income and risk analytics.
  • Undergraduate degree in Finance, Economics, Mathematics, Information Systems, Computer Science, Data Science, or a related field.
  • Strong analytical, critical thinking, and problem-solving skills with a high level of attention to detail.
  • Ability to work independently and collaboratively in a cross-functional, fast-paced environment.
  • Ability to manage competing priorities and meet deadlines.
The following are preferred skills and qualifications:
  • Experience with data pipeline architecture, data warehousing, cloud platforms, or modern data environments, particularly Amazon Web Services, or similar platforms.
  • Experience with data visualization and reporting tools, particularly Power BI.
  • Programming experience in Python, R, or similar languages.
  • Experience with analytics, risk, investment accounting, or investment management platforms such as Blackrock Aladdin, Factset, Clearwater, or similar systems.
  • Familiarity with Agile methodologies and product ownership concepts.
  • Experience documenting data definitions, business rules, data mappings, metadata, lineage, controls, and process documentation.
  • CFA designation, progress toward the CFA, or other relevant finance, data, cloud, or technology certification.
#LI-MB1

Venerable Values: 

Every position at Venerable has responsibility for living out the company's values as described here:

We are Courageous - We think critically, ask "why?" and seek out creative solutions.

We are Curious  - We take calculated risks, learn from out failures, and challenge traditional ways of thinking.

We are Connected - We are connected to each other, our customers and our community.

Please note: The use of AI tools (such as ChatGPT or similar platforms) during interviews is not permitted without the prior approval of Venerable, as the use of such tools may interfere with company confidentiality, misrepresent a candidate’s skills and experience or otherwise conflict with Venerable’s hiring policies. If you are selected for an interview and a reasonable accommodation is needed, please notify the Venerable Human Resources recruiter aligned to the open position in which you are interviewing for.

 

If Venerable, in its sole discretion, determines that AI is being used during an interview without prior approval, Venerable reserves the right to end the interview early and/or disqualify a candidate.

Skills Required

  • 5+ years of experience in financial services, including investment data management and solution design.
  • Demonstrated ability to design and optimize business processes and tools to improve efficiency and mitigate risk.
  • Proficiency in SQL and experience working with large datasets and database design.
  • Proven ability to support product management processes including requirements gathering and user acceptance testing (UAT).
  • Experience with data transmission, loading, reconciliation, reporting, and downstream integration.
  • Advanced Microsoft Excel skills (complex formulas, pivot tables, data analysis).
  • Familiarity with investment instruments and financial markets, particularly fixed income and risk analytics.
  • Undergraduate degree in Finance, Economics, Mathematics, Information Systems, Computer Science, Data Science, or related field.
  • Strong analytical, critical thinking, and problem-solving skills with high attention to detail.
  • Ability to work independently and collaboratively in a cross-functional, fast-paced environment.
  • Ability to manage competing priorities and meet deadlines.
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: West Chester, PA
297 Employees
Year Founded: 2018

What We Do

Venerable is a privately held company with business operations based in West Chester, Pennsylvania and Des Moines, Iowa. Venerable owns and manages legacy variable annuity business acquired from other entities. Created by an investor group led by affiliates of Apollo Global Management, LLC, Crestview Partners, Reverence Capital Partners, and Athene Holdings, Ltd., Venerable is a business with well-established, strategic investors, experienced in successfully building and growing insurance businesses with patient, long-term capital. Growth through acquisition is long storied at Venerable. While we have the nimbleness and flexibility of a start-up, our beginnings are a result of a series of small business ventures by ING Group, who later evolved to Voya Financial, and which began nearly five decades ago. We are led by a highly trusted and experienced team, a significant portion of whom transitioned from Voya at the time of the transaction. With unparalleled knowledge and expertise, the organization remains primed to carry on the tradition of growth. From day one, leaders at Venerable have prioritized the employee experience by focusing on a strong culture. One where employees feel highly engaged, are encouraged to offer feedback often, are supported by a strong management structure, and can collaborate with colleagues without roadblocks. Opportunity awaits for individuals who think critically, ask why, and seek out creative solutions.

Similar Jobs

Milestone Systems Logo Milestone Systems

Software Engineer

Artificial Intelligence • Security • Software • Analytics • Big Data Analytics
Remote or Hybrid
2 Locations
1500 Employees
175K-195K Annually

CrowdStrike Logo CrowdStrike

Manager, Platform Professional Resident Services (Remote)

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
2 Locations
11000 Employees
140K-195K Annually

CoreWeave Logo CoreWeave

Counsel

Cloud • Information Technology • Machine Learning
In-Office
4 Locations
1450 Employees
198K-264K Annually

Immersive Logo Immersive

Enterprise Account Manager

Enterprise Web • HR Tech • Information Technology • Software • Cybersecurity
Remote or Hybrid
United States
330 Employees
130K-160K Annually

Similar Companies Hiring

Globe Life Thumbnail
Insurance • Financial Services
McKinney, TX
3000 Employees
MassMutual India Thumbnail
Big Data • Fintech • Information Technology • Insurance • Financial Services
Hyderabad, Telangana
Granted Thumbnail
Artificial Intelligence • Healthtech • Insurance • Mobile • Financial Services
New York, New York
23 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account