Data Analyst And Reporting Tools Developer

You will be working on a flexible hybrid schedule as part of Fidelity’s dynamic working arrangement.
Who We Are
At Fidelity, we’ve been helping Canadian investors build better financial futures for over 35 years. We offer individuals and institutions a range of trusted investment portfolios and services - and we’re constantly seeking to find new and better ways to help our clients. As a privately owned company, we boldly embrace innovation in all areas as we continue to grow our business into the future.
Working with us means you’ll be part of a diverse and dedicated group of people who make a real difference for our clients and communities every day. You’ll have a wide range of opportunities to grow and develop your career in an inclusive environment where you’ll feel valued and supported to be your best - both personally and professionally.
What You’ll Do
Part of the Finance Department Business Performance Management and Analytics Team, the Data Analyst and Reporting Tools Developer provides analysis and guidance to the members of the Fidelity Senior Executive Team and the business units they manage. Our team works very closely with these client groups and strives to
provide value added analysis that helps advance the business of the groups we support.
The Data Analyst and Reporting Tools Developer reports to the Manager, Business Performance Management and is responsible for the planning, design, development, and deployment of new
reporting database tools as well as the enhancement of existing reports and database reporting
applications. These tools are utilized by business users help make data exploration easier supporting their need to make decisions given different scenarios and changing business conditions.

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

What We’re Looking For

• VBA programming and MS Access and Excel
• Familiar with ETL tools such as Informatica
• Experience with enterprise reporting and dashboard applications (Business Objects is an asset, Tableau, PowerBI)
• Previous experience performing complex business analysis, including data flow analysis and modelling
• Experience in the financial services or mutual fund industry would be an asset
• Experience with cloud technologies (i.e. Snowflake, AWS)
• 4 years’ experience working with relational / multidimensional databases and SQL coding
• Completed University degree (preferably in computer science, information science, management information systems, business administration or finance) or equivalent working experience

The Expertise You Bring

• Excellent problem solver demonstrating the ability to work independently
• Solid communication skills
• Knowledge of VBA programming in both MS Access and Excel
• Innovative thinker with an aptitude for creativity in data visualizations
• Strong analytical and multitasking skills
• Knowledge of MS Access and Excel reporting techniques
• Strong project management skills
• Strong technical capabilities across numerous technologies (i.e. Snowflake, Informatica, Tableau, PowerBI)
• Skilled in process re-design and re-engineering

Current work authorization for Canada is required for all openings.
Fidelity Canada is an equal opportunity employer
Fidelity Canada is committed to fostering a diverse and inclusive workplace. We will consider all qualified applicants for employment regardless of race, color, religion, sex, sexual orientation, gender identity or expression, national or ethnic origin, age, disability, family status, protected veterans’ status, Aboriginal/Native American status or any other legally-protected ground.
Accommodation during the application process
Fidelity Canada welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in the selection process. If you require an accommodation, please email us at [email protected].
No telephone inquiries or agencies please. We thank all applicants for their interest, please be advised that only those selected for an interview will be contacted.
Why Work at Fidelity?
We are proud to be recipients of the following
Awards

• Canada's Top 100 Employers 2023 (7th consecutive year)
• Canada's Top Employers for Young People 2023
• Greater Toronto's Top Employers 2023 (10th consecutive year)
• HRDC Best Places to Work 2022
• Canada's Top Family-Friendly Employers 2023 (7th consecutive year)
• Venngo Healthy Workplaces Award Workplace Benefits Awards – Health and Wellness Program

Designations

• Great Place to Work (Dec 2022 - Nov 2023)
• A Canadian Compassionate Company
• Best Workplaces for Women 2023 by Great Place to Work