Power BI Developer / BI Analys (Pickering)

Overview Role: Power BI Developer / BI Analyst Location: Pickering, Ontario (Onsite) Type of work: Contract Length of work: 12 Months Mode of Interview: Phone interview followed by In-Person interview Mode of work: Hybrid (4days-onsite and 1 day remote) Description: The client is seeking a seasoned Power BI Developer / BI Analyst for a consulting engagement supporting data modernization and analytics program. The ideal candidate designs and delivers enterprise-grade BI solutions, works directly with business stakeholders and leadership, and can independently drive reporting initiatives from requirements through deployment and training. Key Responsibilities Requirements Gathering & Solution Design - Partner with business stakeholders and leadership to gather, analyze, and document reporting and analytics requirements.

Connect with business users directly to understand data needs across reporting solutions. Translate business requirements into dashboard designs, data models, and reporting specifications. Analyze current-state reporting gaps and recommend future-state BI solutions.

Define KPIs, metrics, and data storytelling approaches aligned to business objectives. Collaborate with data and IT teams to clarify data sources, business rules, and semantic definitions. Dashboard Development & Data Modeling - Design, develop, and deploy Power BI reports, dashboards, and executive-facing visualizations.

Build and optimize DAX measures, calculated columns, and Power Query transformations. Develop semantic models and data models aligned with warehousing and ETL principles. Integrate Power BI with Snowflake, relational databases, and enterprise data sources.

Manage Power BI workspaces, refresh schedules, row-level security, and access controls. Ensure report performance, scalability, and alignment to data governance standards. Testing, Validation & Deployment - Develop and execute test scenarios and validation activities against business requirements and acceptance criteria.

Support defect identification, triage, and resolution in collaboration with data and IT teams. Validate data accuracy, model integrity, and visual correctness prior to deployment. Assist with deployment readiness, workspace promotion, and production rollout activities.

Support change management and adoption activities during report launches. Production Support, Training & Continuous Improvement - Provide ongoing support for published reports, datasets, and dashboards. Troubleshoot data refresh failures, model issues, and user-reported discrepancies.

Develop training materials, user guides, and self-service BI documentation. Conduct end-user training and knowledge transfer sessions for business teams. Identify opportunities for report optimization, consolidation, and analytics maturity improvement.

Support AI-enabled reporting features and emerging Power BI capabilities. Required Skills & Experience 8 - 10 years of hands-on experience in BI, reporting, data analytics, and dashboard development Advanced Power BI expertise: report development, data modeling, deployment, and workspace management Strong DAX, Power Query, and SQL skills including query optimization Solid understanding of data modeling, semantic layers, ETL concepts, and data warehousing principles Experience working directly with business users, data teams, and executive stakeholders Solid data visualization and executive reporting design sensibility Proven ability to deliver end-to-end BI solutions independently with minimal supervision Experience in Agile/Scrum delivery environments Excellent verbal and written communication and stakeholder management skills Comfortable in a hybrid environment - 3–4 days per week on-site, Pickering, ON Assets (Nice to Have) Hands-on experience with Snowflake as a data warehouse and Power BI–Snowflake integration Familiarity with AI-enabled analytics features within Power BI Experience in manufacturing, distribution, or dealer/ERP environments Experience with Azure data services or cloud analytics platforms. Exposure to predictive analytics or AI-driven reporting solutions.

Understanding of data governance and security best practices. Experience with KPI frameworks and executive scorecards. Skills MS SQL Informatica Power Center DAX Microsoft Power BI Power Query Work Location Hybrid (Pickering, Ontario, Ontario, Canada) #J-18808-Ljbffr