Logo of Huzzle

Business Systems Data & Reporting Analyst

image

Fidelity Canada

Nov 2, 2024

  • Job
    Full-time
    Mid Level
  • Data
    IT & Cybersecurity
  • Toronto
  • Quick Apply

AI generated summary

  • You need a university degree or equivalent, 3-4+ years in SQL/DBs, strong VBA, Access, Excel skills, plus experience in enterprise reporting tools. Financial industry experience is a plus.
  • You will analyze reporting needs, streamline processes, design databases, test data integrity, maintain BI reports, and clean data from various sources to enhance business efficiency.

Requirements

  • Current work authorization for Canada is required for all openings.
  • University Degree (computer science, information science, management information systems, business administration, or finance), or equivalent work experience
  • 3 - 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, Excel, RPA applications
  • Experience with current enterprise reporting applications (e.g., Business Objects, OBIEE, PowerBI, Snowflake, Tableau) is an asset
  • Experience working within the financial industry and/or the custody and clearing business 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

FAQs

What is the work arrangement for this position?

The position offers a flexible hybrid schedule as part of Fidelity’s dynamic working arrangement.

What are the required qualifications for this role?

A university degree in computer science, information science, management information systems, business administration, finance, or equivalent work experience is required.

How many years of experience are necessary for this position?

Candidates should have 3 to 4+ years of experience working with relational or multidimensional databases and SQL coding.

What key skills are desired for this role?

Strong analytical and multitasking skills, solid communication skills, excellent problem-solving abilities, project management skills, and knowledge of MS Access, Excel reporting techniques, and VBA programming are desired.

Is prior experience in the financial industry required?

While it is not required, experience working within the financial industry and/or the custody and clearing business is considered an asset.

What tools and technologies should candidates be familiar with?

Candidates should have experience with MS Access, Excel, RPA applications, and familiarity with enterprise reporting applications such as Business Objects, OBIEE, PowerBI, Snowflake, and Tableau is an asset.

Does Fidelity Canada offer accommodations during the application process?

Yes, accommodations are available upon request for candidates taking part in the selection process.

Is this position open to remote applicants within Canada?

Yes, current work authorization for Canada is required for all openings.

Does Fidelity emphasize diversity and inclusion?

Yes, Fidelity Canada is committed to fostering a diverse and inclusive workplace and welcomes applications from all qualified individuals regardless of various protected grounds.

Are there any specific awards or recognitions that Fidelity Canada has received?

Yes, Fidelity Canada has received numerous recognitions including Canada’s Top 100 Employers, Best Workplaces for Inclusion, and Great Place To Work® Certification, among others.

Finance
Industry
1001-5000
Employees
1987
Founded Year

Mission & Purpose

Fidelity Canada provides investment management services, offering a wide range of mutual funds, ETFs, and other financial products to help individuals and institutions achieve their financial goals. Their mission is to build better financial futures by delivering superior investment solutions, backed by in-depth research and expert management. Fidelity is committed to supporting investors with innovative strategies and personalized service, ensuring they can navigate complex markets and grow their wealth with confidence.