BI Developer

Cpus Engineering Staffing Solutions Inc.; Oshawa; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A staffing solutions firm based in Canada is seeking an experienced BI Developer to design and maintain business intelligence solutions using Power BI. Responsibilities include building semantic models, developing interactive reports, and collaborating with business partners. Candidates should have over 5 years of BI experience with expertise in data modeling, SQL, and DAX. This position offers a hybrid work environment and will require candidates to possess a bachelor's degree in a related field.

Qualifications

• 5+ years of experience in BI development with a focus on enterprise-scale data modeling.
• Proven expertise in building and managing semantic models using Power BI.
• Strong proficiency with SQL and relational databases.

Responsibilities

• Design and develop Power BI semantic models using best practices.
• Build scalable data models that integrate with SQL-based data sources.
• Develop interactive Power BI reports and dashboards.

Skills

Data Modeling

DAX

SQL

Power BI

Agile methodologies

Education

Bachelor’s degree in Computer Science or related field

Tools

Power BI

SQL Server

Azure SQL

Job description

We are currently requesting resumes for the following position: BI Developer

Resume Due Date: Tuesday, February 17, 2026 (5:00PM EST)

Job ID: 26-016

Number of Vacancies: 1

Level: MP4

Duration: 9 Months

Hours of work: 35 Hours per week

Location: 1908 Colonel Sam Drive, Oshawa

Work Mode: Hybrid – 2 days remote

Hourly Range: $90 – $95

Job Overview

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.

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.

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.

Our client is dedicated to promoting employment equity and encourages applications from equity‑seeking communities including but not limited to: Indigenous Peoples, racialized individuals, persons with disabilities, and women. Our client aims to build a diverse team that reflects the communities it serves, enhancing its ability to meet their needs. We are committed to an inclusive and accessible work environment and invites all qualified individuals to apply, offering accommodations during the application, interview and onboarding process as needed. This effort supports our client’s long‑term strategy for equity, diversity, and inclusion.