Investment Data & Operations Analyst

Investment Data & Operations Analyst Constellation - 3.1 Cincinnati, OH Job Details $75,000 a year 1 day ago Benefits Paid parental leave Health insurance Dental insurance Adoption assistance Parental leave Vision insurance 401(k) matching Life insurance Qualifications Business financial process improvement Accounting systems Power BI Data visualization software proficiency Financial data reconciliation Automation Technical documentation Financial reporting Bachelor's degree in finance Regulatory compliance Process improvement Data reporting Research Mid-level Tableau Financial analysis Finance SQL Analysis skills Bachelor's degree Data quality monitoring Equities Macros Accounting and finance experience VBA Financial regulatory compliance Derivatives Data validation 1 year Root cause analysis Bachelor's degree in accounting AI Data transformation Cross-functional collaboration Financial acumen Accounting Communication skills Python Regulatory compliance management Cloud services Cross-functional communication Excel data analysis Database software proficiency Full Job Description 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 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.

Requirements:

What sets you up for success 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 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 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

Compensation:

$75k