Sr Business Intelligence Consultant

Duradigital; Edmonton; On-site; CAD 90,000 - 120,000; Full time

Job summary

Dura Digital in Edmonton is seeking a Senior Business Intelligence Developer/Consultant to design and maintain Power BI data models, and to support migrations from SQL Server to Snowflake. You’ll collaborate with data engineers and stakeholders to build trusted, scalable analytics solutions.

You will optimize DAX measures and model relationships, ensure consistent metrics, and mentor others to raise BI maturity.

Qualifications

• Experience building Power BI data models and reports.
• Strong SQL skills and data modeling fundamentals.
• Proven ability to translate requirements into BI solutions.
• Experience with Snowflake or cloud data warehouses.
• Ability to mentor teammates and raise BI maturity.
• Familiarity with Agile delivery environments.

Responsibilities

• Design, develop, and maintain Power BI data models for performance and usability.
• Lead migration of Power BI reports/data models from SQL Server to Snowflake.
• Coordinate with data engineers to align models with Snowflake structures.
• Translate stakeholder requirements into actionable reporting solutions.
• Optimize DAX measures, columns, and relationships for clarity and speed.
• Ensure consistency of metrics across reports and domains.
• Identify ways to reduce technical debt in BI assets.
• Provide production support for critical BI workloads.

Skills

Power BI

DAX optimization

Semantic layer design

SQL

Communication

Mentoring

Education

University degree in Computer Science / Information Systems

Tools

SQL Server

Snowflake

Git

Job description

Dura Digital is looking for a Business Intelligence consultant who knows that great analytics starts with strong data models. You care deeply about semantic consistency, performance, and usability; and you’re passionate about helping organizations deliver effective BI platforms.

As a Senior Business Intelligence Developer and consultant, you’ll play a key role in working with our clients designing and maintaining Power BI data models , supporting the migration of Power BI reports from SQL Server to Snowflake. You’ll work closely with data engineers, analytics partners, and project stakeholders to ensure trusted, scalable, and high-performing analytics solutions.

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