BI Developer to design, develop, and maintain scalable and high‑quality business intelligence solutions for our energy client. ED 26-016

9 months

3 days on site in Oshawa

35 hours per week.

The Power BI Report Developer will design, develop, and maintain scalable and high‑quality business intelligence solutions. This includes building end‑to‑end Power BI semantic models, creating interactive and visually effective reports, documenting technical designs, and collaborating with business partners to transform requirements into actionable insights. The role requires strong data modeling skills, an understanding of SQL‑based data sources, and the ability to deliver sustainable reporting solutions. Experience with Power Apps is a plus to support broader Power Platform initiatives.

JOB DUTIES:

• Data Modeling & Architecture Design and develop Power BI semantic models using best practices (star schema modeling, 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 visual/UX improvements.
• 
  

Qualifications

• 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).
• Power Query/M transformations
• DAX (measures, table functions, advanced calculations)
• Creating reusable data models
• Row-level security (RLS) and governance practices
• Experience deploying content via Power BI Service, workspaces, and deployment pipelines.
• Knowledge of developing paginated reports (nice to have)

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

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