CareerPlan

Business Intelligence Architect/Data Modeler

Oakville, ON, CAFull-time2026-10-28 → 2026-11-10

Core

Design, develop, and maintain Power BI dashboards, reports, and data models to provide actionable insights and support business performance management, operational analytics, and strategic initiatives.

Role type

Senior Business Intelligence Architect / Data Modeler

Builds

Production BI dashboards, reports, scorecards, and semantic data layers

Domain

Pharmaceutical industry / Business Intelligence

Deliverable

dashboards & analysis

Required skills

Power BI, Databricks, SQL, SSIS, Data modelling, Data warehousing, ETL development, Dashboard design, Data validation, Requirements gathering

Preferred skills

Pharmaceutical/healthcare domain knowledge, Legacy BI tools (SAP BusinessObjects, Crystal Reports), Data governance experience, User training

Technologies

Power BI, Databricks, SQL, SSIS, SAP BusinessObjects, Crystal Reports

Responsibilities

Design and develop Power BI dashboards and reports; Build and optimize data transformation solutions using Databricks and SQL; Create and manage robust data models and semantic layers; Develop and maintain SSIS ETL workflows; Partner with cross-functional teams to deliver end-to-end BI solutions; Analyze complex datasets to identify trends and performance opportunities; Produce functional and technical documentation; Deliver training and support to end users.

Seniority

Senior, hands-on IC