Business Intelligence Specialist

2 weeks ago

Toronto, Ontario, Canada Teckhorizon Inc Full time

About The Role
Our Client is seeking a Senior Business Intelligence Specialist to support the Office of the Public Guardian and Trustee (OPGT) in building a new Azure-based data warehouse/lakehouse and delivering the Reporting MVP. This is a high-impact role for a seasoned BI professional experienced in Power BI, Dynamics 365 CE/F&O, Azure data engineering, and modern data warehousing.

Key Responsibilities
Data Warehouse / Lakehouse Development

  • Design an Azure-based data warehouse/lakehouse and "golden layer"
  • Integrate and model data from Dynamics 365 CE and F&O
  • Develop and automate ETL pipelines across bronze/silver/gold layers
  • Build logical and physical data models aligned with reporting needs

Reporting & Analytics

  • Deliver the Reporting MVP through high-quality Power BI dashboards
  • Use DAX, Power Query, and gateway configurations to build interactive visuals
  • Optimize data models, performance, and data refresh processes

Data Governance & Security

  • Implement required security controls for sensitive government data
  • Ensure data quality, compliance, and alignment with OPS standards

Collaboration & Delivery

  • Work closely with data engineers, analysts, project managers, and stakeholders
  • Provide documentation, knowledge transfer, and DevOps updates
  • Meet milestones, escalate risks, and follow OPS I&IT directives

Mandatory Skills

  • Expert-level Power BI (data modeling, DAX, Power Query, gateways)
  • Hands-on reporting experience with Dynamics 365 CE and/or F&O
  • Strong knowledge of data warehousing/lakehouse concepts, ETL, modeling, and governance
  • Excellent SQL skills (T-SQL, PL/SQL) and performance tuning
  • Experience with Azure (ADF, Synapse, Azure SQL, DevOps)

Nice-to-Have

  • Azure certifications (Azure Fundamentals, Power BI Data Analyst Associate)
  • Experience with PowerApps, Power Automate, Dataverse
  • Knowledge of SSIS, SSRS, data modeling tools, and version control (Azure Repos)

  • Business Intelligence/Research Specialist

    3 days ago

    Toronto, Ontario, Canada Options Consulting Solutions Full time

    Research & Business Intelligence SpecialistWe're looking for a skilledResearch & Business Intelligence Specialistto join a collaborative, curious, results driven team. This role is ideal for someone who thrives on transforming data into insights, supporting strategic decision-making, and working closely with employee across an organization.What You'll Do:•...

  • Business Intelligence Specialist

    2 weeks ago

    Toronto, Ontario, Canada 2iSolutions Inc. Full time

    **If interested please share your latest resume on RQ Business Intelligence Specialist - SeniorLocation:**Onsite / 595 Bay Street, TorontoStart Date: End Date: Duration: 10-monthMust HavesPower BI:Proficiency in Power BI, includingdata modeling,creating interactive reportsanddashboards, and utilizing advanced features.Demonstrated experience with data...

  • Business Intelligence Specialist

    4 days ago

    Toronto, Ontario, Canada Russell Tobin Full time

    **Job Title: Business Intelligence Specialist - SeniorLocation: Toronto, ON (Onsite)Duration: 8 Months (Possible Extension)Client: Public Sector (Preferred)Pay Rate: C$75-C$85/hrRole Overview**The Senior Business Intelligence Specialist will support enterprise-wide analytics and business intelligence initiatives. This role focuses on designing, developing,...

  • Business Intelligence Specialist

    2 weeks ago

    Toronto, Ontario, Canada Bevertec Full time

    26578BEV123Business Intelligence Specialist - Senior (Power BI, Dynamics, Azure)Toronto, ONContract RoleDuration: Must Haves:Power BI: Proficiency in Power BI, including data modeling, creating interactive reports and dashboards, and utilizing advanced features.Demonstrated experience with data analytics and reporting from Dynamics 365 CE and/or F&O.Data...

  • Senior Business Intelligence Specialist

    2 weeks ago

    Toronto, Ontario, Canada 2iSolutions Inc. Full time

    We are seeking a Senior Business Intelligence Specialist for a 10-month contract opportunity in Toronto, ON. This is an onsite role.Must haves:Power BI: Proficiency in Power BI, including data modeling, creating interactive reports and dashboards, and utilizing advanced features.Demonstrated experience with data analytics and reporting from Dynamics 365 CE...

  • Business Intelligence Specialist

    2 weeks ago

    Toronto, Ontario, Canada TD Full time

    Work Location:Toronto, Ontario, CanadaHours:37.5Line of Business:Analytics, Insights, & Artificial IntelligencePay Details:$96,900 - $136,800 CADTD is committed to providing fair and equitable compensation opportunities to all colleagues. Growth opportunities and skill development are defining features of the colleague experience at TD. Our compensation...

  • Senior Business Intelligence Specialist

    2 weeks ago

    Toronto, Ontario, Canada Randstad Full time

    Do you have proficiency in Power BI, including data modeling, creating interactive reports and dashboards, and utilizing advanced features? Do you have demonstrated experience with data analytics and reporting from Dynamics 365 CE and/or F&O? If so, this would be a great opportunity for you Our client is looking for a Senior Business Intelligence...

  • Business Intelligence Specialist – Senior

    2 days ago

    Toronto, Ontario, Canada Russell Tobin Full time

    Job Title:Business Intelligence Specialist - Senior (Cognos)**Location: Toronto, ON, CAN (On-Site)Duration: 73 Days (Possible Extension)Client: Public SectorPay Rate: C$80-C$90/hr**Join our dynamic team in Toronto, ON, where innovation meets healthcare technology. We are seeking a skilled individual to translate user requirements into actionable business...

  • business intelligence specialist – senior

    3 days ago

    Toronto, Ontario, Canada SOFTLINE TECHNOLOGY Full time

    Note: This position is required to work on-site, five (5) days per week, from the office location.Responsibilities:Supports Client's wide-ranging business information requirements, implementing and supporting business intelligence software solutionsDevelops and supports customized query applications which analyze key business dataDevelops and supports guided...

  • business intelligence specialist-sr

    4 days ago

    Toronto, Ontario, Canada SOFTLINE TECHNOLOGY Full time

    Note: This position is required to work on-site, five (5) days per week, from the office location.Responsibilities:Supports Client's wide-ranging business information requirements, implementing and supporting business intelligence software solutionsDevelops and supports customized query applications which analyze key business dataDevelops and supports guided...