Senior Business Intelligence Developer (6-month Contract)
About the role
The Opportunity 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.
- 6-Month Contract opportunity with the possibility of extension**
Who You Are
- 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.
How You’ll Make An Impact
- Report to the Senior Manager, Data.
- 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 Bring To The Table
-
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.
Key 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
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-Light
We thank all applicants for their interest; however, only those selected for an interview will be contacted.
About AMA - Alberta Motor Association
AMA is a multi-service organization representing 1 million Albertans. While most often known for our roadside assistance program, we also offer travel, registries and insurance services, Alberta’s largest driver education school, a member rewards program and member events in our communities. Part of the CAA and AAA family, we’re focused on our member’s needs and guided by their values to provide products, services and advocacy to help them live confidently.
Anyone here will tell you that we’re a different kind of employer, and it all comes down to how we treat our members - and each other. We've boiled it down to just two words: Practically Family. That’s not just a catchy phrase, we live it every day through simple gestures.
Practically Family is the web developer heading off shift who stops to help a team member carry items in the door, the insurance advisor who uses their break to pick up an extra coffee for a co-worker who’s having a bad day, or the registries agent who takes the time to help a member put their new licence plate on their vehicle. Not to mention all the birthday parties, free food days and wedding showers we throw for each other!
Taking care of one another, encouraging one another. It’s what family does, and what being Practically Family is all about. If you can picture yourself answering yes to the question, “Am I treating this member or colleague like a close family member or friend?” with every interaction, you’re our kind of people!
Senior Business Intelligence Developer (6-month Contract)
About the role
The Opportunity 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.
- 6-Month Contract opportunity with the possibility of extension**
Who You Are
- 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.
How You’ll Make An Impact
- Report to the Senior Manager, Data.
- 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 Bring To The Table
-
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.
Key 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
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-Light
We thank all applicants for their interest; however, only those selected for an interview will be contacted.
About AMA - Alberta Motor Association
AMA is a multi-service organization representing 1 million Albertans. While most often known for our roadside assistance program, we also offer travel, registries and insurance services, Alberta’s largest driver education school, a member rewards program and member events in our communities. Part of the CAA and AAA family, we’re focused on our member’s needs and guided by their values to provide products, services and advocacy to help them live confidently.
Anyone here will tell you that we’re a different kind of employer, and it all comes down to how we treat our members - and each other. We've boiled it down to just two words: Practically Family. That’s not just a catchy phrase, we live it every day through simple gestures.
Practically Family is the web developer heading off shift who stops to help a team member carry items in the door, the insurance advisor who uses their break to pick up an extra coffee for a co-worker who’s having a bad day, or the registries agent who takes the time to help a member put their new licence plate on their vehicle. Not to mention all the birthday parties, free food days and wedding showers we throw for each other!
Taking care of one another, encouraging one another. It’s what family does, and what being Practically Family is all about. If you can picture yourself answering yes to the question, “Am I treating this member or colleague like a close family member or friend?” with every interaction, you’re our kind of people!