OPEN: BI Developer

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

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

Job ID: 26-

Number of Vacancies: 1

Level: MP4

Duration: 9 Months

Hours of work: 35 Hours per week

Location: 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.

CPUS Engineering employs artificial intelligence (AI) tools as part of its recruitment process to enhance efficiency and consistency. These tools may assist with activities such as application screening, candidate evaluation, and summarization of interview feedback.

AI-generated outputs are intended to supplement, not replace, human judgment. All final hiring decisions are made by qualified human decision-makers who exercise professional discretion in reviewing and assessing candidate information alongside any AI-generated insights.

CPUS Engineering ensures that the use of AI in recruitment complies with all applicable employment laws, human rights legislation, and privacy regulations. The organization is committed to maintaining fairness, transparency, and non-discrimination throughout the hiring process.