BI Developer

Vaco Recruiter Services; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading Canadian energy organization is seeking a skilled BI Developer with expertise in Power BI and SQL. The role involves designing data models, developing reports, and collaborating with business partners to ensure analytics meet their needs. Ideal candidates possess a Bachelor's degree and over 5 years of BI development experience, particularly with Power BI. This position offers a competitive hourly rate between $87.58 to $97.58 and is located in the Greater Toronto Area. Interested candidates should apply by submitting their resumes in the specified format.

Qualifications

• 5+ years of experience in BI development.
• Strong proficiency with SQL and relational databases.
• Experience deploying content via Power BI Service.

Responsibilities

• Design and develop Power BI models and reports.
• Ensure data accuracy and perform quality checks.
• Collaborate with stakeholders for reporting needs.

Skills

Power BI semantic models

SQL

DAX

Data modeling

Data visualization best practices

Agile environments

Education

Bachelor’s degree in computer science or related field

Tools

Power BI

SQL Server

Azure SQL

Snowflake

Job description

About the Company

Our client is a leading Canadian energy organization with a strong presence across Ontario. They operate critical infrastructure that supports millions of customers and drives economic growth.

Why Work Here

Our client is engaging in ongoing transformation and investing in cutting‑edge technologies and modernizing operations to meet the evolving needs of the energy sector. By joining, you will be part of an organization that values collaboration, professional development, and making a meaningful impact on the future of clean energy.

About the Opportunity

• Data Modeling & Architecture: Design and develop Power BI semantic models using best practices (star schema, DAX measures, calculation groups, incremental refresh, model optimization).
• Build scalable data models that integrate with SQL‑based data sources and enterprise data platforms.
• Perform data profiling, validation, and quality checks to ensure accuracy and consistency.
• Report & Dashboard Development: Develop interactive Power BI reports, dashboards, and paginated reports from concept through deployment.
• Translate business requirements into effective visual designs, KPIs, and analytical outputs.
• Optimize report performance through model tuning, efficient DAX, and UX improvements.
• Collaboration & Requirements Gathering: Work directly with business stakeholders to understand reporting needs, pain points, and success metrics.
• Participate in solution design sessions and provide guidance on best practices.
• Communicate complex analytical concepts in clear, business‑friendly language.
• Documentation & Governance: Create and maintain technical documentation, including data dictionaries, solution designs, and process documentation.
• Support standards around BI governance, version control, deployment pipelines, and data security.
• Power Platform Support (Preferred): Assist with or build lightweight Power Apps to complement reporting workflows.
• Support integration between Power BI and PowerApps where applicable.

About You

• Bachelor’s degree in computer science, Information Systems, Data Analytics, Business Intelligence, or a related field.
• Certification in Power BI, Azure, or related technologies is an asset.
• 5+ years of experience in BI development, with a focus on enterprise‑scale data modeling and reporting.
• Proven expertise in building and managing semantic models in Power BI or similar tools (including DAX, tabular modeling, and dataset certification).
• Proficiency in Power Query/M transformations and advanced DAX (measures, table functions, calculations).
• Experience implementing row‑level security (RLS) and governance practices.
• Experience deploying content via Power BI Service, workspaces, and deployment pipelines.
• Knowledge of developing paginated reports is an asset.

Data & SQL Experience

• Strong proficiency with SQL and relational databases (e.g., SQL Server, Azure SQL, Synapse, Snowflake).
• Ability to write complex SQL queries and optimize database interactions.

General BI/Analytics Skills

• Ability to translate business requirements into analytical solutions.
• Experience working in Agile or iterative delivery environments.
• Understanding of data visualization best practices and user‑centered design.

Power Platform (Preferred)

• Exposure to Power Apps (Canvas or Model‑Driven) or Power Automate flows.
• Ability to support small workflow apps that complement reporting needs.

Pay Range

$87.58 - $97.58/hr

How to Apply

Click the “Apply Now” button and follow the instructions to submit your resume. Please know that we only accept documents in MS Word or Rich Text formats. When referencing this job, quote #469075.

This position for employment is for a current vacancy with Vaco/Highspring’s client. You must currently reside within the Greater Toronto Area and be permitted to work in Canada to be considered for this opportunity. A recruiter will be in touch with you if your profile meets our client’s requirements for this role.

Determining compensation for this role (and others) at Vaco/Highspring depends upon a wide array of factors including but not limited to the individual’s skill sets, experience and training, licensure and certifications, office location and other geographic considerations, as well as other business and organizational needs. With that said, as required by local law in geographies that require salary range disclosure, Vaco/Highspring notes the salary range for the role is noted in this job posting. The individual may also be eligible for discretionary bonuses, and can participate in medical, dental, and vision benefits as well as the company’s 401(k) retirement plan. Additional disclaimer: Unless otherwise noted in the job description, the position Vaco/Highspring is filing for is occupied. Please note, however, that Vaco/Highspring is regularly asked to provide talent to other organizations. By submitting to this position, you are agreeing to be included in our talent pool for future hiring for similarly qualified positions. Submissions to this position are subject to the use of AI to perform preliminary candidate screenings, focused on ensuring minimum job requirements noted in the position are satisfied. Further assessment of candidates beyond this initial phase within Vaco/Highspring will be otherwise assessed by recruiters and hiring managers. Vaco/Highspring does not have knowledge of the tools used by its clients in making final hiring decisions and cannot opine on their use of AI products.