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
Accountability #1 - 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
Accountability #2 - 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
Accountability #3 - 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
Accountability #4 - 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
Strong 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.
Communication and Collaboration Skills:
Clear and concise verbal and written communication skills, with an ability to articulate complex technical concepts to non-technical team members.
Demonstrated skill in collaborative work across departments, with a focus on knowledge sharing and team-oriented problem-solving.
