REMOTE - Sr Power BI Developer (DAX, Python, Snowflake SQL) to support Analytics Modernization project - VRP 2627-260414TR - April 27 - 3

S.i. Systems enterprise public sector client is seeking REMOTE Sr Power BI Developer (DAX, Python, Snowflake SQL) to support Analytics Modernization project - VRP 2627-260414TR - April 27 - 1

Approx 10 month Contract from May 2026 - March 31, 2027

37.5 hours / week

Fully remote within Canada - must work PST hours

The Analytics Consultant provides senior-level expertise in enterprise analytics delivery with a strong emphasis on Power BI development, enterprise reporting standards, and complex dashboard migration. This role supports the organization transition to Power BI as the enterprise reporting platform by defining and applying best-practice development standards, modernizing legacy BI solutions, and delivering high-impact dashboards aligned to enterprise data governance and Snowflake-based data models.

Acting as a trusted advisor and technical lead, the Consultant partners closely with Data Governance, Data Analytics, and business stakeholders to translate complex business requirements into scalable, governed, and performant analytics products. The Consultant brings strong business acumen, advanced visualization and storytelling expertise, and hands-on technical leadership to accelerate consistent, high-quality analytics delivery across the organization.

MUST HAVE SKILLS:

Experience with a BI platform modernization / migration / legacy platform transitions

• 5+ years - Advanced expertise in Power BI: data modeling, DAX optimization, visualization standards, accessibility, and performance tuning.

Strong proficiency with Snowflake SQL, data transformation logic, and analytic data modeling.

• Experience reviewing and translating Qlik (and/or Cognos) dashboards, scripts, and expressions into modern BI architectures.

• Advanced knowledge of data governance, data quality, and standardized business definitions.

• Hands-on experience with enterprise cloud and analytics platforms (e.g., Snowflake, AWS, Matillion or similar).

• Proficiency with version control and deployment workflows (e.g., Git/Bitbucket).

• Advanced SQL skills and working knowledge of Python for data analysis and transformation.

JOB DUTIES

A. Dashboard Requirements, Development & Release Support

• Lead requirements-gathering and solution-design activities for priority dashboards, including:

o Data Governance Dashboard

o Data Quality Dashboard

• Design and develop iterative Power BI dashboard releases incorporating:

o User feedback

o Data validation and integrity checks

o Visual and performance refinements

• Ensure all dashboard solutions align with:

o Enterprise data governance principles

o Standardized business definitions and KPIs

o Enterprise reporting and visualization standards

• Support testing, release planning, deployment readiness, and post-release refinements

B. Power BI Development Standards & Patterns

• Define and refine enterprise Power BI development standards, including:

o Semantic model and star-schema design patterns

o Naming conventions and documentation standards

o Data transformation and modeling guidance

o Visualization, layout, and accessibility standards

o Version control, promotion, and deployment workflows

o Security, governance, and role-based access controls

• Develop and maintain:

o Reference architectures and semantic models

o Reusable templates and development assets

o Technical documentation and user guidance

• Deliver training sessions and technical advisory support to internal analytics teams to drive adoption and consistency

C. Technical Advisory & Analytics Enablement

• Act as a senior technical advisor to Analytics Delivery and Insights Execution

• Provide design reviews, architectural guidance, and hands-on support for complex analytics initiatives

• Identify risks, dependencies, and technical constraints early, and recommend effective mitigation strategies

• Coach and mentor internal developers on Power BI best practices, data modeling, and visualization storytelling

D. Qlik Migration Analysis & Snowflake Translation

• Review existing Qlik and Cognos dashboards, scripts, and expressions to:

o Identify core business logic and metrics

o Understand data flow and transformation rules

o Document redevelopment requirements

• Translate legacy BI logic into:

o Snowflake SQL transformations

o Governed analytic data models

o Power BI semantic models aligned with enterprise standards

• Provide end-to-end technical support for Qlik Snowflake Power BI migration workstreams