Financial & Tax Reporting Analyst

CI Investments Inc.; Canada; Hybrid; CAD 70,000 - 95,000; Full time

Benefits offered by this job

Health insurance coverage

Wellness programs

Life and disability insurance

Retirement savings plans

Paid leave programs

Education-related programs

Paid holidays and vacation time

Volunteering time off

Job summary

CI Investments Inc. in Canada is seeking a Mutual Fund & ETF Tax Analyst to support tax operations, analysis and reporting for funds.

You will work with large data sets, perform reconciliations and develop automated solutions using Excel, Power Query, SQL, Python, and Power BI to improve accuracy and efficiency. The role collaborates with Fund Accounting, Investment Ops, Finance and Legal, requiring a strong analytical mindset and attention to detail.

Qualifications

• Bachelor's degree in accounting, finance, business, economics, computer science, data analytics or a related discipline.
• Approximately 2–5 years of relevant experience in investment management, fund accounting, fund administration, taxation or financial data analysis.
• Exposure to mutual funds or ETFs is an asset.
• CPA studies or designation or relevant tax education is an asset but not required.

Responsibilities

• Support the preparation and review of tax calculations for mutual funds and ETFs.
• Analyze investment income, capital gains and losses, distributions and expenses for tax purposes.
• Support year-end tax processes including distribution planning and investor tax information.
• Analyze tax characteristics of securities and investment transactions.
• Maintain and reconcile tax data used in fund-level calculations.
• Assist with analysis of book-to-tax differences and other tax adjustments.
• Support tax-related analysis for new funds, launches, mergers and terminations.

Skills

Excel

Power Query

SQL

Python

Power BI

Power Pivot

Power Automate

Data analysis

Education

Bachelor's degree in accounting, finance, business, economics, computer science, data analytics or a related discipline

CPA studies or designation (asset)

Tools

Fund accounting systems

Data extraction from databases

Job description

At CI, we see a great place to work as one that is a safe place for everyone to have a voice, where people are empowered to take ownership over meaningful work, where there is an opportunity to grow through stretching themselves, where they can work on innovative products and projects, and where employees are supported and engaged in doing so.

JOB OVERVIEW

The Mutual Fund & ETF Tax Analyst is responsible for supporting the tax operations, analysis and reporting requirements of mutual funds and exchange-traded funds (ETFs). The role combines fund tax/product knowledge with strong technical and data-analysis capabilities. The successful candidate will work with large volumes of financial and tax data, perform reconciliations and tax calculations, identify data anomalies, and develop efficient and automated solutions to improve the accuracy, scalability and control of fund tax processes. This position is particularly suited to an individual who is highly analytical, technically curious and interested in applying Excel, Power Query, SQL, Python, Power BI and automation tools within an investment management environment.

What you will do:

• Fund Tax Analysis Support the preparation and review of tax calculations for mutual funds and ETFs.
• Assist with the analysis of investment income, capital gains and losses, distributions, expenses and other tax-related fund activity.
• Support year-end tax processes, including distribution planning, tax reporting and investor tax information.
• Analyse tax characteristics of securities and investment transactions, including equities, fixed income, derivatives and foreign investments.
• Maintain and reconcile tax data used in fund-level calculations.
• Assist with analysis of book-to-tax differences and other tax adjustments.
• Support tax-related analysis for new funds, fund launches, mergers, terminations and other product events.

Tax Data Quality & Controls

• Reconcile tax information between fund accounting records, custodians, tax systems and other data sources.
• Investigate and resolve differences in positions, transactions, income, distributions and tax attributes.
• Perform reasonability checks and trend analysis across funds.
• Develop exception-based reporting that allows the team to focus on higher-risk items rather than manually reviewing entire datasets.
• Maintain evidence supporting tax calculations, reconciliations and reviews.
• Support internal controls over tax reporting and tax-related financial information.

Fund Tax Operations

• Work with Fund Accounting, Investment Operations, Finance, Product, Legal and external service providers to support fund tax requirements.
• Coordinate with fund administrators, custodians and external tax advisers to investigate tax-related issues and data discrepancies.
• Assist with requests from auditors and other internal or external stakeholders.
• Support the implementation and testing of system changes affecting tax calculations or tax data.
• Participate in projects designed to improve the fund tax operating model and increase automation.

What you will bring:

• The ideal candidate will have experience with several of the following:
• Core Microsoft Excel, advanced level Power Query PivotTables and advanced formulas
• Large dataset manipulation and reconciliation
• Data validation and exception reporting
• Highly desirable SQL Python, particularly pandas or similar data-analysis libraries
• Power BI
• Power Pivot / data modelling
• Microsoft Power Automate
• Additional assets
• Experience working with fund accounting, portfolio accounting, custody or investment management systems
• Experience extracting data from databases or data warehouses
• Understanding of APIs or structured data formats
• Experience designing automated workflows and controls
• Familiarity with artificial intelligence and Copilot-enabled productivity tools

Qualifications

Bachelor's degree in accounting, finance, business, economics, computer science, data analytics or a related discipline. Approximately 2-5 years of relevant experience in investment management, fund accounting, fund administration, taxation, finance or financial data analysis preferred. Exposure to mutual funds or ETFs would be an asset. Canadian investment fund tax knowledge would be an asset, but candidates with strong financial data and technical skills who demonstrate an ability to learn fund taxation should also be considered. CPA studies, CPA designation or relevant tax education would be an asset but are not necessarily required.

Key Competencies

Strong analytical and problem-solving abilities. Exceptional comfort working with data and technology. Ability to understand complex calculations and translate them into structured, repeatable processes. Strong attention to detail and ability to identify unusual results or data inconsistencies. Ability to investigate issues independently and determine root causes. Strong documentation and control mindset. Ability to communicate technical or tax concepts clearly to non-tax stakeholders. Interest in continually improving and automating processes.

This role follows our in-office work model and requires employees to be onsite four days per week to support collaboration and business needs.

This opportunity is for an existing vacancy with the company.

The anticipated base salary range for this position is $70,000 to $95,000.

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.

• health insurance coverage
• wellness programs
• life and disability insurance
• retirement savings plans
• paid leave programs
• education-related programs
• paid holidays and vacation time
• many others

Many of these benefits are subsidized or fully paid for by the company.

CI Financial is an independent company offering global wealth management and asset management advisory services through diverse financial services firms. Since 1965, we have consistently anticipated and responded to the changing needs of investors.

We are driven by a commitment to provide individuals and institutions with the highest-quality investments and advice. Our commitment to the highest levels of performance means that whatever their position, CI employees must be comfortable in a fast-paced environment that will stretch them to tap into their highest potential.

Employees with a healthy dose of ambition, a desire to commit to a curious mindset for continuous learning, and a willingness to go the extra mile thrive at CI.

CI Financial offers an in-office environment, competitive benefits, and a supportive workplace to help our employees thrive both personally and professionally.

We offer a modern HQ location within walking distance from Union Station, training reimbursement, paid professional designations, employee savings plan (ESP), corporate discount program, enhanced group benefits, parental leave, top-up program, and paid time off for volunteering.

We are focused on building a diverse and inclusive workforce.

CI Financial Corp. and all of our affiliates ("CI") are committed to fair and accessible employment practices and provide reasonable accommodations for persons with disabilities. If you require accommodations in order to apply for any job opportunities, require this posting in an additional format, or require accommodation at any stage of the recruitment process please contact us at [e-mail], or call 416-364-1145 ext. 4747.

CI Financial is an independent company offering global wealth management and asset management advisory services. Since 1965, we have consistently anticipated and responded to the changing needs of investors. We are driven by a commitment to provide individuals and institutions with the highest-quality investments and advice.