Investment Data & Operations Analyst

Constellation Insurance, Inc.•Montgomery, OH

1d•Hybrid

About The Position

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.

Requirements

Bachelor's degree in Finance, Accounting, or a related business field
1--3 years of experience in investments, financial analytics, data-focused operations, or a similar environment (preferred)
Strong analytical foundation and solid understanding of investment data, including securities, benchmarks, pricing, and performance metrics
Advanced Excel skills, including macros and automation
Hands-on experience using Python for reporting, data transformation, or analytics
A curious mindset with a passion for improving processes and finding smarter ways to work
Excellent communication skills and confidence collaborating across teams and departments

Nice To Haves

Familiarity with SQL, data visualization tools (Power BI, Tableau), or cloud platforms is a plus
Experience with AI productivity tools--or a strong desire to learn and explore emerging technologies

Responsibilities

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
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
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
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

Benefits

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 integration.
Well-being focus: Programs to support a healthy balance between work and home life.
Community connections: Build strong relationships through virtual and in-person interactions, with resources for your growth.