Talent.com
Flexstaf IT
Sr. Reporting Business Intelligence AnalystFlexstaf IT • Toronto, ON, Canada
Sr. Reporting Business Intelligence Analyst

Sr. Reporting Business Intelligence Analyst

Flexstaf IT • Toronto, ON, Canada
6 hours ago
Job type
  • Full-time
  • Quick Apply
Job description

Position Overview

Reporting directly to the Controller, the Sr. Reporting Business Intelligence Analyst bridges Finance and IT to drive enterprise-wide data analysis, KPI tracking, and business intelligence reporting. In this role, you will be responsible for building and maintaining robust reporting packages, optimizing data integration pipelines, and modernizing business intelligence tools. You will ensure high data accuracy, security, and service delivery while serving as a trusted analytical partner to leadership.

Key Responsibilities

  • BI & Report Development: Author, optimize, and deploy operational and analytical reports using SQL Server Reporting Services (SSRS).
  • ETL & Data Integration: Design, build, and maintain SQL Server Integration Services (SSIS) packages for data extraction, transformation, loading, and batch processes.
  • Financial & Operational Reporting: Generate core financial reconciliation documents for banking and Finance, as well as specialized financial output (e.g., benefit check runs, Explanation of Benefits reports).
  • Data Engineering & Analysis: Write complex T-SQL queries, views, stored procedures, and ad-hoc data loads to support end-user requests across cross-functional departments.
  • System & BI Modernization: Evaluate and recommend modern BI suites, software, and analytics techniques to elevate reporting architecture.
  • Cross-Functional Collaboration: Partner closely with IT and business units to translate complex operational needs into actionable technical recommendations.

Qualifications & Requirements

  • Experience: 3+ years of dedicated BI, data analysis, and KPI-tracking experience.
  • Reporting & ETL Stack: Hands-on mastery of SSRS (report design, matrix layout, subscriptions) and SSIS (ETL pipeline creation, deployment, scheduling).
  • Database & SQL: Advanced proficiency with Microsoft SQL Server, SSMS, T-SQL query optimization, and Visual Studio.
  • Advanced Excel: Expert-level skills in MS Excel, including dynamic formulas, macros/VBA, pivot tables, and complex data modeling.
  • Infrastructure: 3+ years of experience working with Windows Server environments (Win Server 2012/2016+).
  • Industry & Tools: Familiarity with health/medical benefit plans, financial reporting standards, or ERP/reporting systems (e.g., Crystal Reports, IIS, Dynamics GP/Great Plains) is strongly preferred.
  • Education: Bachelor's degree in Computer Science, Information Technology, Business Administration, or a related quantitative field.

Core Competencies & Soft Skills

  • Analytical & Critical Thinking: Exceptional mathematical and problem-solving skills to interpret complex datasets and turn them into clear business insights.
  • Detail-Oriented & Meticulous: High precision in verifying financial and operational data integrity.
  • Proactive Self-Starter: Ability to take ownership of projects and work independently in a fast-paced environment.
  • Communication & Collaboration: Strong written and verbal English communication skills to partner effectively with both technical developers and business executives.
Create a job alert for this search

Sr. Reporting Business Intelligence Analyst • Toronto, ON, Canada

Similar jobs

Business Intelligence Specialist – Senior (OBIEE experience)

BevertecToronto, Ontario, Canada
Full-time

Job Role: Business Intelligence Specialist – Senior (OBIEE experience) Location: Toronto, ON/Onsite Position Type: Contract Role Start Date 2026-02-09 End Date 2026-12-31 The candidate is required ... Show more

 • Promoted

Float Business Intelligence Data Analyst

FloatToronto, ON, CA
Full-time

Drive insights at Float as a Business Intelligence Data Analyst in Toronto, focusing on building a data-driven strategy for decision-making.You'll create frameworks and dashboards that empower team... Show more

 • Promoted

Sr. Analyst, Portfolio Performance & Insights

SE HealthMarkham, ON, CA
Full-time

At SE Health, our people are everything—and our Home Office is an important part of that culture.When you choose to join SE Health, you become part of a caring, purpose-driven team that’s making a ... Show more

 • Promoted

Sr. Analyst, Quantitative Investment Solutions

Hillsdale Investment Management Inc.Toronto, ON, CA
Full-time

Senior Analyst, Quantitative Investment Solutions.Hillsdale Investment Management Inc.Institutional Investment Services Team (IIS) as a Senior Analyst, Quantitative Investment Solutions.Reporting t... Show more

 • Promoted

RQ09972 -Business Analyst-Artificial Intelligence (AI)

A.T. Consulting & Recruiting Inc.Toronto, ON, CA
Full-time

RQ09972 - Business Analyst-Artificial Intelligence (AI).Direct message the job poster from A.Strong analytical skills to translate business objectives into actionable AI strategies.Experience in pr... Show more

 • Promoted

Business Intelligence Analyst III

TD SecuritiesToronto, ON, CA
Full-time

Business Intelligence Analyst III.Work Location: Toronto, Ontario, Canada.The Compliance Data Enablement & Transformation (CDET) team supports the effective and sustainable implementation and execu... Show more

 • Promoted

Data Analyst - Business Intelligence

RewardOpsToronto, ON, CA
Full-time

CAD, depending on experience and qualifications.We are seeking a Lead/Senior Data Scientist to design and deliver advanced analytical solutions that power our global loyalty SaaS platform.This role... Show more

 • Promoted

RQ08214 - Sr. Business Intelligence Specialist

Rubicon PathToronto, ON, CA
Full-time

Business Intelligence Specialist.Business Intelligence Specialist.A Senior Business Intelligence Specialist FFS resource is needed for the IFIS in Cloud Project for the below deliverables:.Validate... Show more

 • Promoted

BI Reporting Analyst: Dashboards, SQL & QuickSight

Jonas Club SoftwareMarkham, York Region, CA
Full-time

A technology solutions provider is seeking a Development Analyst for their Business Intelligence team in Markham, Canada.The role involves designing and optimizing BI assets using AWS QuickSight an... Show more

 • Promoted

Toronto Business Intelligence Consultant Position

Policy, Planning & ResearchToronto, ON, CA
Full-time

Unlock potential as a Business Intelligence Consultant for the City of Toronto at Union Station.Showcase your experience with BI tools, SQL, and data analysis methodologies.The City of Toronto is f... Show more

 • Promoted

Analyst, Client & Business Intelligence

Bennett Jones LLPToronto, ON, CA
Full-time

Ranked a Best Employer in Canada for 25 years, Bennett Jones is one of Canada’s premier business law firms, operating nationwide and in New York.Analyst, Client & Business Intelligence (Toronto off... Show more

 • Promoted

Business Intelligence Manager

Metergy SolutionsToronto, ON, CA
Full-time

Metergy office location is in Markham but will be moving to North York in Fall 2026!.The Business Intelligence Team is accountable for the management, development and execution of the Business Inte... Show more

 • Promoted

Analyst, Client & Business Intelligence

Bennett JonesToronto, ON, CA
Full-time

Ranked a Best Employer in Canada for 25 years, Bennett Jones is one of Canada’s premier business law firms and home to 450 lawyers and business advisors.With deep experience in complex transactions... Show more

 • Promoted

Sr. Analyst, Compensation

Restaurant Brands Internationaltoronto, on, Canada
Full-time

Ready to make your next big professional move? Join us on our journey to achieve our big dream of building the most loved restaurant brands in the world.Restaurant Brands International Inc.RBI owns... Show more

 • Promoted

Manager, Business Intelligence, GTB Analytics

ScotiabankToronto, ON, CA
Full-time

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.Global Transaction Banking (GTB) is the payments and transaction engine of Scotiabank.We suppor... Show more

 • Promoted

Sr. Business Intelligence Engineer, Forecasting and Labs Analytics

Amazontoronto, on, Canada
Full-time +1

Amazon has the world’s most complex supply chain: we fulfill global demand for hundreds of millions of products at lightning fast delivery speeds.We need your skills to optimize our supply chain, w... Show more

 • Promoted

Senior Analyst, Business Intelligence and Analytics

Livingston InternationalToronto, ON, CA
Full-time

Senior Analyst, Business Intelligence and Analytics.The Business Intelligence and Data Analyst will be responsible for transforming data into insights that drive business decisions.This role involv... Show more

 • Promoted

Dynamic SAS Analyst for Data Analysis and Reporting in Banking Sector

RedPicoToronto, ON, CA
Full-time

Boost your career as a data-savvy SAS Analyst focused on banking applications.Apply your SAS, SQL, and Power BI skills to enhance performance reporting and analysis strategies.In this role, you wil... Show more

 • Promoted

Competitive Intelligence Analyst

TeradataToronto, ON, CA
Full-time

Our Company At Teradata, we believe that people thrive when empowered with better information.That’s why we built the most complete cloud analytics and data platform for AI.By delivering harmonized... Show more

 • Promoted

Sr. Business Analyst

DelaplexToronto, ON, CA
Full-time

Get AI-powered advice on this job and more exclusive features.At Delaplex, we believe true organizational distinction comes from exceptional products and services.Founded in 2008 by a team of like-... Show more