Sr Business Intelligence Consultant

WHAT MOVES YOU

* You enjoy translating complex project requirements into intuitive, performant BI solutions.
* You’re analytical, curious, and thoughtful about how data models impact downstream reporting and decision-making.
* You’re a strong communicator who can explain technical concepts to non-technical audiences.
* You take pride in clean, well-documented models and reports that others can easily understand and reuse.
* You enjoy mentoring others and raising the overall maturity of BI practices.
* You stay calm and focused when navigating ambiguity, change, or platform migrations.

WHAT YOU'LL DO

* Design, develop, and maintain Power BI data models using best practices for performance, scalability, and usability.
* Lead and support the migration of Power BI reports and data models from SQL Server to Snowflake.
* Partner with data engineering teams to align Power BI models with Snowflake data structures and transformation logic.
* Work with project stakeholders to understand requirements and translate them into clear, actionable reporting solutions.
* Optimize DAX measures, calculated columns, and model relationships for performance and clarity.
* Ensure consistency in metrics, dimensions, and definitions across reports and subject areas.
* Identify opportunities to simplify, standardize, and reduce technical debt in existing Power BI content.
* Support data validation and reconciliation efforts during platform migrations.
* Promote BI best practices including version control, documentation, and deployment workflows.
* Assist in establishing standards for Power BI development, governance, and lifecycle management.
* Provide production support for critical BI assets, ensuring reliability and trust in reporting.

WHAT YOU'VE DONE

* You have a university degree in Computer Science, Information Systems, or a related field. or equivalent experience.
* You bring 5+ years of experience in Business Intelligence, Analytics Engineering, or Data Analytics roles.
* You have deep hands-on experience with Power BI, including:
* Data modeling
* DAX
* Performance optimization
* Data design for self-service analytics
* You have strong SQL skills and experience working with SQL Server.
* You have experience supporting or leading BI migrations (on-prem to cloud and/or platform-to-platform).
* You’ve worked with cloud data warehouses, with Snowflake experience strongly preferred.
* You understand dimensional modeling concepts (e.g., Kimball) and how they apply to BI semantic layers.
* You’re comfortable collaborating with data engineers and analysts.
* You have experience working in Agile or iterative delivery environments

SKILLS

* Business Intelligence & Analytics
* Power BI (data models, reports, dashboards)
* DAX optimization and modeling best practices
* Semantic layer design
* Data Platforms
* SQL Server
* Snowflake / cloud data warehouses
* Data Modeling
* Dimensional modeling (Kimball)
* Metrics standardization
* Languages & Tools
* SQL
* DAX
* Version control (Git)
* Practices
* BI governance and lifecycle management
* Data quality validation
* Performance tuning
* Documentation and knowledge sharing

Location: Edmonton, Alberta