Power BI Developer

SMARTFOX

Canada

On-site

CAD 70,000 - 110,000

Full time

40 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

SMARTFOX turns data into clear, interactive Power BI dashboards and reports that help teams spot opportunities, catch problems early, and make confident decisions. You’ll work across data sources and business units to deliver fast, accurate reporting with privacy and data residency built in from the start.

The ideal candidate has 3+ years of hands-on Power BI experience, strong DAX and Power Query skills, and solid data modeling knowledge.

Qualifications

  • 3+ years hands-on experience building Power BI reports and dashboards.
  • Bachelor’s degree or college diploma in Computer Science, Information Systems, Data Analytics, or related field.
  • Strong DAX and Power Query (M) with data modeling and star schema knowledge.
  • Experience with relational databases such as SQL Server and writing efficient SQL queries.
  • Familiarity with Power BI Service administration (workspaces, gateways, refresh, deployment pipelines).
  • Knowledge of privacy requirements in Canada (PIPEDA).
  • Ability to translate vague business questions into clear metrics and visuals.
  • Clear communication and ability to explain insights to non-technical audiences.
  • Legally authorized to work in Canada.

Responsibilities

  • Build: Design and publish interactive Power BI dashboards and reports.
  • Model: Create clean data models with star schemas and relationships.
  • Transform: Use Power Query and DAX to shape data from SQL, cloud, APIs, and Excel.
  • Secure: Implement row-level and object-level security compliantly.
  • Localize: Set up Canadian cloud regions for data residency.
  • Optimize: Tune refresh schedules and query performance.
  • Collaborate: Work with analysts, data engineers, and business leaders.
  • Govern: Manage workspaces, deployment pipelines, and metrics.
  • Enable: Train end users and support self-service reporting.

Skills

Power BI
DAX
Power Query
SQL
Data modeling
PIPEDA privacy
Communication skills
Work authorization

Education

Bachelor’s degree or college diploma in Computer Science / Information Systems / Data Analytics

Tools

SQL Server
Power BI Service
Microsoft Fabric / Azure Synapse

Job description

Turn Data Into Decisions That Move the Business

Data only creates value when people can understand it and act on it. As a Power BI Developer at Smartfox, you’ll turn raw data into clear, interactive dashboards and reports that help our teams and customers spot opportunities, catch problems early, and make confident decisions. You’ll work across data sources and business teams to build reporting that is accurate, fast, and easy to use, with privacy and data residency built in from the start.

What You’ll Do
  • Build: Design and publish interactive Power BI dashboards and reports that answer real business questions.
  • Model: Create clean, well-structured data models with star schemas, measures, and relationships that stay fast as data grows.
  • Transform: Use Power Query and DAX to shape, clean, and calculate data from SQL databases, cloud platforms, APIs, and Excel.
  • Secure: Implement row-level and object-level security so people see exactly the data they should, and handle personal information in line with PIPEDA and Quebec’s Law 25.
  • Localize: Set up workspaces and capacities in Canadian cloud regions where data residency requirements apply.
  • Optimize: Tune refresh schedules, query performance, and model size so reports load quickly.
  • Collaborate: Partner with analysts, data engineers, and business leaders to turn requirements into working solutions.
  • Govern: Manage workspaces, deployment pipelines, and version control, and document key metrics so everyone works from the same numbers.
  • Enable: Train and support end users, and help teams adopt self-service reporting.
What You Bring
  • Bachelor’s degree or college diploma in Computer Science, Information Systems, Data Analytics, or a related field (or equivalent experience)
  • [3+] years of hands‑on experience building Power BI reports and dashboards in a professional setting
  • Strong command of DAX and Power Query (M), with a solid understanding of data modeling and star schema design
  • Experience working with relational databases such as SQL Server, including writing efficient SQL queries
  • Familiarity with Power BI Service administration, including workspaces, gateways, scheduled refresh, and deployment pipelines
  • Working knowledge of privacy requirements for personal data in Canada, including PIPEDA
  • Ability to translate vague business questions into clear metrics and visuals
  • Clear communication skills and the ability to explain insights to non‑technical audiences
  • Legal authorization to work in Canada
Bonus Points

Microsoft Power BI Data Analyst certification (PL-300), experience with Microsoft Fabric, Azure Synapse, Snowflake, or Databricks, Python or R for data analysis, experience with row-level security in enterprise environments, familiarity with Quebec’s Law 25 or Ontario’s PHIPA, SOC 2 experience, experience with Git or Azure DevOps for BI development, and French as an asset for teams in Quebec.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Power BI Developer | PowerBI | BI Developer
Senior Power BI Developer | PowerBI | BI Developer

Resource Informatics Group, Inc • Pickering

Hybrid
CAD 80,000 - 110,000
Power BI Developer
Power BI Developer

Astra-North Infoteck Inc. • Toronto

Hybrid
CAD 70,000 - 90,000
BI Developer
BI Developer

Globaldataandbi • Toronto

Hybrid
CAD 120,000 - 180,000
Power BI Developer
Power BI Developer

Synechron • Mississauga

Hybrid
CAD 115,000 - 125,000
Hybrid work policy
RRSP with employer's contribution up 4
Udemy for Business access
+1
Power BI Developer
Power BI Developer

Saint Laurent Consulting • Vaughan

On-site
CAD 70,000 - 110,000
Bilingual Power BI Developer
Bilingual Power BI Developer

Altis • Ottawa

Hybrid
CAD 83,000 - 124,000
Power BI Developer
Power BI Developer

Precision Technologies • Mississauga

On-site
CAD 110,000 - 140,000
Software Developer - ETL / Power BI - Intermediate
Software Developer - ETL / Power BI - Intermediate

isgSearch • Toronto

On-site
CAD 90,000 - 130,000
Data Analyst – Power BI / Microsoft Fabric
Data Analyst – Power BI / Microsoft Fabric

Myticas Consulting Inc. • Ottawa

On-site
CAD 90,000 - 107,000
Full benefits
Intermediate Software Developer
Intermediate Software Developer

Hirematic Talent Solutions • Toronto

On-site
CAD 55,000 - 62,000