Posted 2 months ago
Sr. Reporting Business Intelligence Analyst
@ Flexstaf IT
Toronto, Ontario
Overview
Flexstaf IT is hiring a Senior Reporting Business Intelligence Analyst to report to the Controller and bridge Finance and IT. The role builds and maintains reporting packages, KPI tracking, and ETL pipelines, and advises leadership. The posting requires 3+ years of BI experience and full-time hours.
Responsibilities:
- Build and deploy reports in SSRS
- Design and maintain SSIS ETL packages
- Produce financial reconciliation and benefit reports
- Write complex T-SQL queries and stored procedures
- Evaluate modern BI tools and reporting architecture
Requirements summary:
- 3+ years of BI, data analysis and KPI experience
- Hands-on SSRS and SSIS skills
- Advanced T-SQL and Microsoft SQL Server proficiency
- Expert Excel skills including VBA and pivot tables
- 3+ years with Windows Server environments
- Bachelor's degree in a quantitative field
Tools & skills
Source and dates
Source type not verified · manatal
- Employer posting date
- 2026-08-27
- First seen by our source
- 2026-10-10
- Source record updated
- 2026-11-05
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Senior |
| Department | Data & analytics |
| Experience | 3+ years |
| Hours per week | 40 (estimated) |
| Work setting | Office |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
| Languages | English |
| Education | Bachelor’s degree (required) |
| Fields of study | Computer Science, Information Technology, Business Administration, Quantitative field |
Summary and details written by AI from the posting; the employer’s posting is the authority.
Flexstaf IT
| Field | Value |
|---|---|
| Open jobs on Jobsy | 85 |
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.
Journal
Only you can see this. Kept on this device, and in your account when you sign in.