Data Analytics & BI Tool Architect

Fidelity Canada; Mississauga; Hybrid; CAD 105,000 - 152,000; Full time

Benefits offered by this job

Remote work options

Hybrid/onsite options

RRSP contributions

Comprehensive health benefits

Parental leave top‑up

Home office equipment allowance

Volunteer days

Training and development opportunities

Job summary

Fidelity Canada is seeking a Data Analyst and Reporting Tools Developer to support executives and business units with advanced reporting and analytics. You will design, develop, and deploy new reporting tools and enhance existing databases, using SQL, VBA, Excel, and BI platforms.

The role emphasizes data integrity, efficiency, and collaboration with cross‑functional teams. Hybrid/remote options are available, with the work location transitioning from Toronto to Mississauga later in 2026.

Qualifications

• University Degree in computer Science, finance or equivalent experience.
• 4+ years of experience working with relational or multidimensional databases and SQL coding.
• Experience performing complex business analysis, including data flow analysis and modeling.
• Strong skills in VBA programming, Access and Excel.
• Experience in the financial services industry is an asset.
• Experience with current enterprise reporting applications (e.g., Business Objects, OBIEE, PowerBI, Snowflake, Tableau) is an asset.

Responsibilities

• Research and analyze current reporting and business data needs.
• Provide ongoing status reports and prepare detailed documentation of tools and reporting procedures.
• Devise and implement tools to automate and streamline processes that achieve efficiency for both business and finance users.
• Design and implement reporting databases and applications utilizing data from relational databases and flat file sources.
• Design and perform testing for data integrity and application performance.
• Maintain and re-engineer existing Business Intelligence, Access and Excel based reports.
• Perform data cleansing and manipulation, working with multiple disparate data sources.

Skills

Strong analytical abilities

Excellent communication skills

Independent worker

Project management

Process redesign/re-engineering

Education

University Degree in computer Science, finance or equivalent experience

Tools

SQL

VBA

Access

Excel

PowerBI

Snowflake

Tableau

Business Objects

OBIEE

Job description

Fidelity Canada is seeking a Data Analyst and Reporting Tools Developer to support executives and business units with advanced reporting and analytics. You will design, develop, and deploy new reporting tools and enhance existing databases, using SQL, VBA, Excel, and BI platforms.

The role emphasizes data integrity, efficiency, and collaboration with cross‑functional teams. Hybrid/remote options are available, with the work location transitioning from Toronto to Mississauga later in 2026.