Business Intelligence Specialist

7 days ago

Toronto, Ontario, Canada Teckhorizon Inc Full time $100,000 - $150,000 per year

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 Specialist

    7 days ago

    Toronto, Ontario, Canada 2iSolutions Inc. Full time $80,000 - $120,000 per year

    **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

    1 week ago

    Toronto, Ontario, Canada Bevertec Full time $80,000 - $120,000 per year

    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...

  • Business Intelligence Specialist

    2 weeks ago

    Toronto, Ontario, Canada S M Software Solutions Inc Full time $41,000 - $41,100 per year

    Role: RQ Business Intelligence Specialist – SeniorClient: Ministry of Public and Business Service Delivery & ProcurementLocation: Toronto, ON (Hybrid – 3 days onsite / 2 days remote)Start Date: Oct 20, 2025End Date: Feb 27, 2026 (Possible Extension)Hours/Day: 7.25Must Have Skills:Oracle APEX Application DevelopmentStrong SQL / PL-SQL and ETL...

  • Senior Business Intelligence Specialist

    1 week ago

    Toronto, Ontario, Canada 2iSolutions Inc. Full time $80,000 - $120,000 per year

    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...

  • Senior Business Intelligence Specialist

    7 days ago

    Toronto, Ontario, Canada Randstad Full time $80,000 - $120,000 per year

    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

    5 minutes ago

    Toronto, Ontario, Canada Avenir Energy Ltd. Full time $80,000 - $120,000 per year

    Business Intelligence (BI) Analyst – 1 year termAbout Avenir Energy Ltd.Avenir Energy Ltd. is one of Canada's largest and fastest-growing propane distribution companies. We are a fast-paced, customer-focused, field-based business with operations across the country and a commitment to excellence. With over 400 dedicated team members, we are driven to become...

  • Business Intelligence Specialist

    2 weeks ago

    Toronto, Ontario, Canada vTech Solution Canada Full time $80,000 - $120,000 per year

    Please share your resume at Company DescriptionvTech Solution, Inc. is a CAMSC certified minority-owned firm headquartered in Winnipeg with a primary focus on Workforce Solutions. Specializing in Managed Workforce Solutions and IT Consulting Services, vTech addresses the evolving staffing needs of businesses. The company works at the intersection of business...

  • Consultant, Business Intelligence

    22 minutes ago

    Toronto, Ontario, Canada CIBC Full time $80,000 - $120,000 per year

    We're building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing what's right for our clients.At CIBC, we embrace your strengths and your ambitions, so you are empowered at work. Our team members have what they need to make a meaningful impact and are truly valued for who they are and...

  • Business Intelligence Analyst

    5 days ago

    Toronto, Ontario, Canada FreshBooks Full time $90,000 - $120,000 per year

    As a Business Intelligence Analyst at FreshBooks, you will design and deliver data assets that empower our teams to make analytics-informed decisions. You'll collaborate with stakeholders across the business to understand priorities and challenges, translating them into effective, scalable data solutions. Your work will enable self-service analytics, ensure...

  • Business Intelligence Developer

    2 weeks ago

    Toronto, Ontario, Canada Infotek Consulting Inc. Full time $60,000 - $80,000 per year

    Position:Business Intelligence DeveloperStart Date:November 3, 2025End Date:April 17, 2026Schedule:Monday–Friday, 9AM–5PM, 37.5 hours/weekDuration:6 monthsRole OverviewWe are seeking aBusiness Intelligence Developerto support ongoing reporting and data integration efforts within a corporate analytics and AI team. This role focuses on building and...