Senior Business Intelligence Developer (6-month Contract)

Overview

You’re a Business Intelligence expert 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 in AMA’s Data department, you’ll play a key role in 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.

Responsibilities

• Design, develop, and maintain Power BI data models with 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.

Qualifications

You have deep hands-on experience with Power BI, including :

Key Skills

Business Intelligence & Analytics

Data Platforms

Data Modeling

Languages & Tools

Practices

Belonging Matters Here

AMA is committed to providing an inclusive, respectful, and accessible environment. If you require an accommodation at any time during our recruitment process, please contact recruitment@ama.ab.ca . We’ll work with you feel supported throughout your journey with us.

Work Model

Hybrid

We thank all applicants for their interest; however, only those selected for an interview will be contacted.

#J-18808-Ljbffr