Financial & Tax Reporting Analyst

CI Financial; Toronto; On-site; CAD 70,000 - 95,000; Full time

Benefits offered by this job

Modern HQ location

Training Reimbursement

Paid Professional Designations

Employee Savings Plan (ESP)

Corporate Discount Program

Enhanced group benefits

Parental Leave Top-up

Paid time off for Volunteering

Job summary

CI Financial is seeking a Tax Analyst to support fund tax operations and data quality for mutual funds and ETFs in an in-office environment. You will apply Excel, Power Query, SQL, Python and Power BI to reconcile data, perform tax calculations and support year-end tax processes.

The role emphasizes analytical rigor, data integrity and collaboration with multiple teams to improve automation and controls in fund tax workflows.

Qualifications

• Bachelor's degree in accounting, finance, business, economics, computer science, data analytics.
• 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 helpful but not required.
• Strong analytical and problem-solving abilities with attention to detail.
• Ability to translate complex calculations into repeatable data processes.

Responsibilities

• Support tax calculations for mutual funds and ETFs.
• Analyze investment income, capital gains, distributions and expenses.
• Assist with year-end tax processes, reporting and investor tax information.
• Reconcile tax data across fund accounting, custodians and tax systems.
• Develop automated exception-based reporting to focus on high-risk items.

Skills

Excel (advanced)

Power Query

PivotTables

Large datasets

Data validation

Education

Bachelor's degree in accounting, finance, business, economics, computer science, data analytics

Tools

SQL

Python (pandas)

Power BI

Power Pivot / data modelling

Power Automate

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:

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. Theanticipatedbase salary range for this position is $70,000to $95,000. Exactsalary 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.

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.

A Supportive Environment for Success

We offer an in‑office environment, competitive benefits, and a supportive workplace to help our employees thrive both personally and professionally.

WHAT WE OFFER

• 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
• Paid time off for Volunteering

We are focused on building a diverse and inclusive workforce.

Only qualified candidates selected for an interview will be contacted. 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 [e-mail], or call 416-364-1145 ext. 4747.