Jobs and Careers
CO

Investment Data & Operations Analyst

Constellation Insurance, Inc.
Cincinnati, United Statesfull_timeVerifiedPosted 16 Apr 2026

About the role

As the Investment Data & Operations Analyst you will play a key role in advancing the quality, automation, and accessibility of investment data and reporting across the organization. You'll act as a vital connector between the Investment, Operations, and Technology teams, enhancing data integrity, streamlining workflows, and developing analytics that drive smarter decision-making.

You will also provide back-office investment operations support, ensuring accurate and timely accounting and administration of a complex investment portfolio in accordance with regulatory standards and company policies. In this role, you'll combine strong financial acumen with technical expertise, leveraging advanced Excel, Python, and emerging technologies to improve efficiency, reduce risk, and help scale investment processes as the business continues to grow and modernize.

Your role and impact

Here's a glimpse of your responsibilities and the meaningful impact you'll create as the Investment Data & Operations Analyst:

Data Management & Reporting

  • Maintain, validate, and enhance investment data accuracy across systems and reporting workflows
  • Investigate and resolve data discrepancies at the source
  • Develop and maintain clear documentation to support scalable, repeatable data processes

Automation, Process Optimization & Technology Improvement

  • Build automated solutions using advanced Excel functions, VBA, Python, and emerging AI tools
  • Identify opportunities to streamline manual processes, reduce operational friction, and accelerate reporting
  • Support ongoing improvements to processes across trading, operations, and asset management teams
  • Conduct root cause analysis and recommend control and efficiency enhancements

Investment Operations

  • Process daily investment activity in the accounting system (PAM for Investments), including fixed income, derivatives, and equities
  • Research and reconcile differences between internal records and custodial data
  • Ensure investment accounting data shared with internal and external stakeholders is complete and accurate
  • Prepare reporting for internal leadership and regulatory authorities

Collaboration, Governance & Compliance Support

  • Partner with teams across the organization to understand data and reporting needs
  • Support compliance and audit initiatives through accurate, well-controlled data and reporting processes
  • Contribute to forums focused on data governance, workflow improvement, and operational excellence

What's in it for you

  • Competitive pay: Fair compensation for your hard work.
  • Healthcare coverage: Comprehensive medical, dental, and vision from day one.
  • Life insurance: Company-paid coverage for you and your loved ones.
  • 401(k) plan: Matching contributions to help secure your financial future.
  • Family support: Paid parental leave and reimbursement for adoption and surrogacy expenses.
  • Work-life balance: Flexible time-off policy to recharge and pursue passions.
  • Dress for your day: Express your style comfortably at work.
  • Inclusion and Culture: A respectful environment that values unique contributions.
  • Flexible work options: Remote, hybrid, and onsite opportunities at various locations across the U.S. for better work-life integrati

Apply for this role

Generate a tailored application kit with a matched cover letter, interview prep, and CV highlights — in under 60 seconds.

Apply Now →Generate Application Kit

Free account required — sign up in 30s

Company

Constellation Insurance, Inc.

View company profile →