Business Intelligence Engineer

Brooksource

Toronto

Hybrid

CAD 48,216 - 55,104

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

A leading consultancy firm in Toronto is seeking an experienced Power BI Developer to enhance digital analytics capabilities. This pivotal role involves designing and maintaining high-impact Power BI dashboards while managing data from various sources. Ideal candidates will have 3+ years of Business Intelligence experience, a robust knowledge of DAX, and the ability to automate processes. The position offers a hybrid work model and strong potential for contract extension based on performance. Expect a collaborative environment focused on delivering high-quality results.

Qualifications

3+ years of hands-on Business Intelligence / Power BI experience.
Experience building Power BI dashboards from the ground up.
Solid working knowledge of DAX.

Responsibilities

Design, build, and maintain Power BI dashboards from scratch.
Write and optimize DAX to support dynamic visuals.
Consolidate data from multiple existing sources.

Skills

Business Intelligence experience

Power BI dashboard development

Solid knowledge of DAX

Data consolidation

Automation understanding

Troubleshooting

Hybrid collaboration

Ownership mindset

Tools

Power BI

SQL

Automation tools (e.g., cron)

Job description

This range is provided by Brooksource. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$35.00/hr - $40.00/hr

Location: Toronto, Canada

Work Model: Hybrid (2–3 days on-site per week)

Contract Length: 6 months (strong potential for extension)

Start Timing: Early - Mid February (flexible)

Rate: Please note the rate listed is CAD $ and T4 rate. Open to IC as well for higher rate.

About the Role

We are supporting a large enterprise organization in Toronto that is expanding its digital analytics capabilities and looking to bring on an experienced Power BI Developer / BI Engineer on a contract basis.

This role sits at the intersection of business intelligence, data curation, and automation. You’ll be responsible for building high-impact Power BI dashboards from the ground up, consolidating data from multiple existing sources, and ensuring dashboards are fully automated, reliable, and proactively monitored.

This is not a reporting-only role and not a pure data engineering role — it’s ideal for someone who thrives in building and owning Power BI solutions end to end.

What You’ll Be Doing

Design, build, and maintain Power BI dashboards from scratch
Write and optimize DAX to support complex, dynamic visuals
Consolidate data from multiple existing sources (e.g., databases, Excel, SharePoint, other BI tools)
Perform light data cleaning and normalization as needed
Implement automation for data refreshes, checks, and monitoring
Build proactive notifications to flag successes, warnings, or failures
Troubleshoot and resolve data or automation issues before stakeholders are impacted
Own the full lifecycle of dashboards you build (development, QA, automation, support)
Partner with internal stakeholders to ensure metrics are accurate and meaningful

Technical Environment

DAX
SQL (reading and understanding queries; heavy SQL development not required)
Multiple structured and semi-structured data sources
Automated refresh and scheduling processes (e.g., cron or similar tools)

Required Qualifications

3+ years of hands-on Business Intelligence / Power BI experience
Strong experience building Power BI dashboards from the ground up
Solid working knowledge of DAX
Experience consolidating data from multiple disparate sources
Understanding of automation concepts (scheduled jobs, monitoring, notifications)
Ability to troubleshoot data and automation issues independently
Comfortable working in a hybrid, collaborative environment
Strong ownership mindset — able to manage work end to end

Nice to Have (Not Required)