16 Apr
|
Celebal Technologies
|
Toronto
16 Apr
Celebal Technologies
Toronto
Apply on Kit Job: kitjob.ca/job/2fss8r
Job summary
Power BI Developer
Location - Anywhere in Canada
Remote with 5% travel
Key responsibilities
- Design and maintain semantic models (datasets, star schemas, measures, calculated columns) in Power BI.
- Build scalable, performant data models using best practices (normalization vs. denormalization, grain definition, role-playing dimensions, surrogate keys).
- Implement DAX measures, performance tuning, and query optimization.
- Create reusable datasets and shared semantic layers (certified datasets, composite models, XMLA endpoints).
- Partner with business stakeholders to gather requirements, translate KPIs into model logic, and present insights to non-technical audiences.
- Develop reports/dashboards with robust UX, accessibility, and storytelling.
- Collaborate with data engineering to source/transform data (ETL/ELT), manage row-level security, and support deployment pipelines.
- Mentor/PMO support for BI governance, dataset versioning, and documentation.
Required skills & experience
- 3+ years Power BI development; deep hands-on experience building semantic models.
- Strong DAX proficiency (complex measures, time intelligence, performance patterns).
- Experience with data modeling concepts: star schema, surrogate keys, slowly changing dimensions, conformed dimensions.
- Familiar with Power BI Desktop, Power BI Service (workspaces, dataflows, certified datasets), XMLA, and gateways.
- SQL proficiency (T-SQL or similar) for complex queries and model validation.
- Excellent verbal and written communication; proven ability to translate technical concepts for business stakeholders.
- Experience applying row-level security and governance in Power BI.
Preferred
- Experience in Healthcare or Life Sciences (clinical, claims, EHR/HL7/FHIR, regulatory reporting, clinical trials, patient outcomes).
- Familiarity with Azure data stack (Synapse, ADLS, Azure SQL, Databricks)
- Knowledge of M (Power Query) and dataflow orchestration.
- Certification: Microsoft Certified: Data Analyst Associate (PL-300) or equivalent.
Apply on Kit Job: kitjob.ca/job/2fss8r
📌 Power BI Developer (Toronto)
🏢 Celebal Technologies
📍 Toronto