Qualifications
Responsibilities
Benefits
While broad expertise is not required, candidates must demonstrate strong proficiency in SQL and data fundamentals, along with credible depth in investment analytics or quantitative/risk foundations (ideally both). This is a hands‑on role involving large-scale data, analytical production, and close partnership with both investment and technology teams.
Key Responsibilities
Deliver Decision‑Useful Insights
Partner with Portfolio Managers and investment stakeholders to translate analytical questions into structured analyses that directly inform investment decisions.
Investigate performance and risk outcomes; identify key drivers, notable shifts, anomalies, and emerging themes across funds and portfolios.
Own the Data-to-Insight Workflow
Use advanced SQL to extract, join, transform, and validate large datasets across holdings, performance, risk, and reference/security data.
Build analysis-ready datasets and reusable outputs that enhance consistency, efficiency, and scalability.
Performance & Risk Reporting & Dashboarding
Develop and maintain recurring performance, risk, product, and portfolio analytics reports for investment leadership.
Support competitive and peer analysis to inform portfolio construction and product positioning.
Enable Automation and Scalable Analytics
Contribute to automation initiatives and tooling that enhance the efficiency and sustainability of analytics and reporting workflows.
Support the evolution toward more technology-enabled, self‑serve analytics for investment and product teams.
Strengthen Data Quality and Platform Foundations
Collaborate with data engineering and technology partners to define business logic, document requirements, validate implementations, and drive consistency in business rules and definitions.
Contribute to data quality checks, controls, and metadata/lineage improvements across analytics processes.
Conduct Targeted and Strategic Analysis
Execute ad hoc deep‑dive analyses to support strategic initiatives, or address questions from senior investment and product leadership.
Communicate findings clearly, with emphasis on assumptions, logic, and decision relevance.
Communicate and Document with Precision
Produce clear, structured documentation that is testable and implementable by data engineering teams.
Present analytical outcomes in concise, stakeholder‑friendly language.
Required
Bachelor’s degree in a relevant discipline (e.g., Finance, Economics, Mathematics, Statistics, Data Science, Data Engineering) or equivalent practical experience.
7 years of relevant experience in investment analytics, portfolio analytics, performance/risk analytics, or data-driven investment support—preferably within an asset manager or asset owner environment.
Advanced SQL proficiency with the ability to independently manage large relational datasets and complex joins.
Familiarity with market/investment data platforms.
Strong quantitative reasoning and comfort working with imperfect or incomplete data while maintaining analytical rigor.
Excellent attention to detail, strong business logic, and a high standard for accuracy and consistency.
Strong written and verbal communication skills; effective when working across investment, product, and technology teams.
Assets (Nice-to-Haves)
Experience with Snowflake or other modern data platforms; knowledge of data warehousing concepts.
Familiarity with factor-based risk platforms.
Experience with Tableau or similar visualization tools.
Programming skills (eg, Python) for analytics, automation, or prototyping.
Exposure to data architecture, data modeling, metadata, lineage, or data engineering workflows.
Progress toward or completion of CFA or FRM.
This opportunity is for an existing vacancy with the company. The anticipated base salary range for this position is $69,500 - $119,500. Exact salary depends on several factors such as experience, skills, education, and budget. Salary range may vary based on geographic location. In addition to base salary, this position is eligible for participation in a bonus program. In addition, The Company offers a variety of benefits to eligible employees, including health insurance coverage, wellness programs, life and disability insurance, retirement savings plans, paid leave programs, education-related programs, paid holidays and vacation time, and many others. Many of these benefits are subsidized or fully paid for by the company.
About CI Financial
Similar Jobs

More Jobs at CI Financial





More Finance & Insurance Jobs
