Senior Investment Systems & Operations Associate

Constellation Insurance, Inc.; Cincinnati (OH); Hybrid; USD 110,000 - 150,000; Full time

Benefits offered by this job

Healthcare coverage

Life insurance

401(k) plan

Parental leave

Flexible work options

Dress for your day

Diversity and inclusion

Job summary

Constellation Investments seeks a Senior Investment Systems & Operations Associate to design, build, and maintain automation across investment workflows. You will develop AI-powered applications, integrate systems, and deliver automated reporting for senior management, while collaborating with investment, tech, finance, and operations teams to ensure scalable, compliant solutions.

The role emphasizes cross-team collaboration, strong SQL skills, and experience with complex investments, aiming to

Qualifications

• Bachelor's degree in Computer Science, Software Engineering, Information Systems, or a related technical field.
• 3-5 years of experience developing software solutions, automation tools, AI-powered applications, or data-driven business solutions.
• Strong SQL and relational database experience.
• Experience developing integrations using APIs, databases, and other data exchange technologies.
• Knowledge of complex investments including private placements, derivatives, fixed income, mortgage loans, real estate, and equity securities.
• Experience developing, testing, deploying, and maintaining reliable software solutions.
• Strong analytical, problem-solving, and communication skills.
• Ability to manage multiple priorities and thrive in a fast-paced environment.

Responsibilities

• Design, develop, and maintain automation solutions for key investment operations workflows.
• Create and deploy software solutions, integrations, and AI-powered applications to improve efficiency.
• Create automated reporting and dashboards for senior management.
• Develop user interfaces for trade order management and asset transfers.
• Collaborate with investment, technology, finance, and operations teams to translate requirements into technical solutions.
• Lead and contribute to special projects with internal and external stakeholders.
• Ensure compliance with company policies and regulatory requirements.
• Support investment operations including funding transactions, trade processing, FX conversions, and cash reconciliations.
• Oversee a growing portfolio of asset types with portfolio managers, banks, custodians, and external asset managers.
• Deliver timely and accurate data to support financial reporting and treasury operations.

Skills

SQL

Problem-solving

Communication

Multi-tasking

Education

Bachelor's degree in Computer Science or related

Tools

APIs

Relational databases

Bloomberg

Morningstar Direct

Job description

As the Senior Investment Systems & Operations Associate, you will play a critical role in developing automation and AI-driven solutions that enhance efficiency, accuracy, and scalability across investment workflows, which supporting investment operations. If you enjoy solving complex business challenges, collaborating across teams, and leveraging technology to drive operational excellence, this is an exciting opportunity to make a meaningful impact.

About Constellation Investments

We are a fast-growing asset management firm with $35 billion in assets under management. We invest in a broad range of sophisticated asset classes including public markets, private credit, asset backed securities, direct lending, mortgages, private equity, and derivatives. But people are our biggest assets and we are foremost invested in the growth and development of our associates.

Your role and impact

Here’s a glimpse of your responsibilities and the meaningful impact you’ll create as the Senior Investment Systems & Operations Associate:

• Design, develop, and maintain automation solutions for key investment operations workflows, including reconciliations, pricing updates, tracking cash movement, and custody account management.
• Create and deploy software solutions, integrations, and AI-powered applications that improve operational efficiency and strengthen business processes.
• Create automated reporting and dashboards for senior management
• Create and maintain key user interfaces such as for trade order management and asset transfers
• Collaborate with investment, technology, finance, and operations teams to translate business and operational requirements into effective technical solutions.
• Lead and contribute to special projects while building strong partnerships with both internal and external stakeholders.
• Ensure compliance with company policies and regulatory requirements.
• Support investment operations, including funding transactions, trade processing, foreign exchange conversions, and cash reconciliations.
• Oversee a growing portfolio of broad asset types while coordinating with portfolio managers, banks, custodians, and external asset managers.
• Support financial reporting, treasury operations, and accounting processes by delivering timely and accurate data.

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

What sets you up for success

Required Qualifications

• Bachelor's degree in Computer Science, Software Engineering, Information Systems, or a related technical field.
• 3-5 years of experience developing software solutions, automation tools, AI-powered applications, or data-driven business solutions.
• Strong SQL and relational database experience.
• Experience developing integrations using APIs, databases, and other data exchange technologies.
• Knowledge of complex investments, including private placements, derivatives, fixed income, mortgage loans, real estate, and equity securities.
• Experience developing, testing, deploying, and maintaining reliable software solutions.
• Strong analytical, problem-solving, and communication skills.
• Ability to manage multiple priorities and thrive in a fast-paced environment.

Preferred Qualifications

• Experience in investments, financial services, insurance, or other transaction-intensive industries.
• Experience building workflow automation, data pipelines, reconciliation processes, or operational applications.
• Experience developing AI-powered solutions and using generative AI tools to improve business processes.
• Familiarity with investment technology platforms such as Bloomberg, Morningstar Direct, investment accounting systems, or similar tools.