Publié il y a 2 mois
Sr. Reporting Business Intelligence Analyst
@ Flexstaf IT
Toronto, Ontario
En bref
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.
Responsabilités :
- 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
Résumé des exigences :
- 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
Outils et compétences
Source et dates
Type de source non vérifié · manatal
- Date publiée par l’employeur
- 2026-08-27
- Première détection par notre source
- 2026-10-10
- Mise à jour du dossier source
- 2026-11-05
Ces dates décrivent le dossier source, pas une vérification en direct du recrutement. Consultez l’offre originale.
Détails du poste
| Niveau | Senior |
| Domaine | Données et analytique |
| Expérience | 3 an(s) et plus |
| Heures par semaine | 40 (estimé) |
| Milieu de travail | Bureau |
| Position | Surtout assis |
| Exigences physiques | physique faible · ordinateur élevé |
| Langues | English |
| Formation | Baccalauréat (exigé) |
| Domaines d’études | Computer Science, Information Technology, Business Administration, Quantitative field |
Résumé et détails rédigés par l’IA à partir de l’offre; l’offre de l’employeur fait foi.
Flexstaf IT
| Champ | Valeur |
|---|---|
| Offres sur 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
Visible seulement par vous. Conservé sur cet appareil, et dans votre compte une fois connecté.