Senior Business Intelligence Specialist

We are seeking an experienced Senior Business Intelligence Specialist to lead both the end-to-end data architecture and hands-on report development for enterprise reporting solutions. In this role, you will split your focus between architecting scalable cloud data platforms—including Databricks Lakehouses, semantic models, and security governance frameworks—and developing interactive Power BI dashboards. Working closely with business stakeholders and technical leads, you will translate complex data requirements into performant reporting solutions, optimize data pipelines, and ensure strict compliance with enterprise data governance standards.

Location: North York, ON (Fully Onsite – 5 days/week required)

Duration: 12-month contract.



Advantages
Dual Architecture & Hands-on Scope: Balance strategic platform design with direct Power BI dashboard development.

Modern Cloud Stack: Work extensively with Databricks Lakehouse, Azure Data Factory, Synapse, and Power BI.

End-to-End Governance Leadership: Own complete security blueprints, including Row-Level Security and CI/CD pipelines.

Dedicated Onsite Collaboration: Work alongside senior analytics leads and business partners in a focused 5-day onsite workspace.



Responsibilities
Data Architecture & Blueprinting: Author comprehensive Solution Architecture Documents, Data Flow Diagrams, and Conceptual/Logical/Physical Data Models for enterprise analytics platforms.

Lakehouse & Semantic Model Design: Architect Databricks Lakehouse structures and design performant Power BI semantic models utilizing dimensional modeling and star schema principles.

Security & Governance Implementation: Design granular security frameworks, including Row-Level Security (RLS), role-based access models, data lineage documentation, and data governance controls.

CI/CD & Capacity Planning: Establish environment management strategies, continuous integration and deployment (CI/CD) pipelines, non-functional requirements, and capacity performance plans.

Hands-on Power BI Development: Build, test, and deploy interactive Power BI dashboards and reports, integrating Databricks data sources and writing complex DAX measures and Power Query transformations.

Performance Optimization & SQL Scripting: Write advanced SQL queries, optimize data warehouse performance, tune semantic model refresh cycles, and perform root-cause troubleshooting.

Requirements Gathering & Stakeholder Collaboration: Partner with business teams to elicit analytics requirements, conduct deep-dive data investigations, and provide detailed technical documentation and knowledge transfer.



Qualifications
Data Architecture Seniority: Minimum 7+ years of dedicated data architecture experience, with expert knowledge of dimensional modeling, star schemas, and enterprise data warehousing (Strictly Required).

Power BI Development: Minimum 5+ years of hands-on Power BI development experience, with expert-level skills in DAX, Power Query, and semantic model optimization (Strictly Required).

Analytics Seniority: 7+ years of broader Business Intelligence and data analytics experience (Strictly Required).

Cloud & Lakehouse Platform Expertise: Proven hands-on experience with Databricks, Azure Data Factory, Azure Data Lake, Azure Synapse, and SQL Server (Strictly Required).

Security & Governance Controls: Demonstrated experience designing and implementing Row-Level Security (RLS), data governance, and automated CI/CD pipeline architectures (Strictly Required).

Business Analysis & Data Investigation: Strong skills in gathering business requirements, performing deep-dive SQL analysis, and resolving data anomalies.

Nice-to-Have Assets:
3+ years of experience within public sector or healthcare data environments.



Summary
If you're interested in the "Senior Business Intelligence Specialist" role based in Toronto, we encourage you to apply online at www.randstad.ca.
Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.