Sr. Reporting Business Intelligence Analyst

Flexstaf IT - 30 emplois

Toronto, ON

Posté aujourd'hui

Détails de l'emploi :

Temps plein

Niveau d`entrée

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.

#Business Analysis carrières

Postulez dès maintenant

Enregistrer

Partager un emploi :

Foire aux questions

What is the job title and what does this role do?

This is a Sr. Reporting Business Intelligence Analyst role that bridges Finance and IT to drive data analysis, KPI tracking, and BI reporting, including building and maintaining reporting packages and modernizing BI tools.

What technologies and tools will I be working with in this BI role?

The role requires SSRS for report development and SSIS for ETL pipelines, along with advanced SQL Server skills, T-SQL, SSMS, and familiarity with BI modernization and potential ERP/reporting systems.

What are the key responsibilities related to data and reporting?

Responsibilities include authoring and deploying reports, designing ETL pipelines, generating financial and operational reports, writing complex queries and ad-hoc data loads, and collaborating with IT and business units.

What qualifications and experience are required for this position?

Requires 3+ years of BI, data analysis, and KPI-tracking experience, mastery of SSRS and SSIS, advanced SQL Server skills, expert Excel, Windows Server infrastructure experience, and a related bachelor’s degree.

Where is the job located and what is the employment type?

This is a full-time position based in Toronto, ON.

What emphasis is placed on collaboration and soft skills in this role?

Strong communication and collaboration skills are required to partner with technical developers and business executives, along with analytical, detail-oriented, proactive, and independent work traits.

What industries or systems familiarity would help in this job?

Familiarity with health/medical benefit plans, financial reporting standards, or ERP/reporting systems like Crystal Reports, IIS, Dynamics GP/Great Plains is strongly preferred.