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.