Reporting & Analytics Consultant

Role Overview

We are seeking a highly analytical and proactive Reporting & Analytics Consultant for a 12-month contract based in Downtown Toronto. This role serves as a critical bridge between business stakeholders and IT, responsible for translating complex reporting requirements into robust data solutions. You will lead the end-to-end delivery of reporting initiatives, from initial requirement gathering and SQL development to final implementation and technical support.

Key Responsibilities

• Requirement Documentation & Analysis: Collaborate with business partners to identify, document, and align reporting requirements with organisational objectives, managing multiple stakeholder priorities simultaneously.
• SQL Development & Deployment: Develop robust SQL scripts (T-SQL, PL/SQL) and work closely with IT teams to deploy reports into production environments.
• Testing & Quality Assurance: Conduct Business Acceptance Testing (BAT) and Post Implementation Verification (PIV) to ensure data accuracy and system integrity.
• Technical Support & Administration: Provide technical support for Tableau implementations and manage ad hoc reporting requests and custom analysis.
• Process Improvement: Lead analysis for application enhancements and identify role-based inefficiencies to improve workflows in collaboration with IT.

What program/technology/software knowledge is essential for this role? Describe in what capacity the selected candidate will be using it:

Proficiency required (daily or near-daily use):

·        Tableau Desktop and Server Administration

·        Microsoft SQL Server Management Studio (or equivalent SQL IDE), Microsoft Access

·        Microsoft Office/365/Copilot

·        Atlassian Confluence and Jira

May be helpful but not required:

·        Python scripting

SAP BusinessObjects (BOBJ) / BusinessObjects Enterprise (BOE)

Must-have Skills/Experiences and/or Education, certifications, qualifications, designations:

·        Minimum five years of relevant experience with proven success managing initiatives and juggling multiple stakeholder priorities simultaneously.

·        Exceptional analytical and problem-solving capabilities with a logical, data-driven mindset and inherent sense of ownership and initiative.

·        Degree in Economics, Accounting, Finance, Computer Science, or a related quantitative field.

·        Experience profiling data within an RDBMS (Sybase, MS SQL) using SQL

·        Very strong analytical and problem-solving skills, with a logical mind-set

·        Excellent communication – clear and concise oral, written and presentation skills

·        Proven ability to collaborate and maintain/build relationships

·        Some experience in a Business Analyst or Data Analyst type role.

**** 

Nice-to-have Skills/Experience and/or Education, certifications, qualifications, designations:

·        An understanding of corporate lending processes

·        A love of innovation and technology

·        Degree with a focus in Economics, Accounting, Finance, Computer Science, or other quantitative fields

 

Soft skills:

·        Proactive team player with a can-do attitude, a will to excel, an ability to work independently without being micromanaged.

·        A desire to learn and grow.

·        Inherent sense of ownership and initiative.

·        Skilled in understanding end-user needs (vs. wants) and translating them into actionable requirements.

·        A proven team player who works well in cross-functional environments.

·        Comfortable with managing ambiguity and motivating progress despite ambiguity

·        Accurate and concise communication.