Senior Business Intelligence Analyst

YOU NEVER MET A DATA STORY YOU COULDN’T TELL.
 

The Opportunity
 

Internal Job Title: Senior Analyst, Business Intelligence
 

Data isn’t just numbers to you—it’s insight, it’s strategy, and it’s the key to smarter decisions. You thrive on transforming complex data into clear, impactful visualizations that empower business leaders to act with confidence. From building BI reports to mentoring others in best practices, you know how to turn data into a story that drives action.

We’re looking for a Senior Analyst, Business Intelligence, based in Edmonton, with deep expertise in BI development and visualization. Someone who can partner with business and operational leaders to design dashboards, scorecards, and analytical tools that bring clarity to complex information. If you’re passionate about data design, storytelling, and mentoring others to raise the bar, this role is for you.
 

A Place to Belong

 AMA is more than a workplace; it’s a family. Together, we help protect the things that matter most to our more than one-million members—everything from roadside safety to retail savings, food security to childhood well-being. And with operations that span automotive, registries, travel, insurance and more, the opportunities to grow with us are almost limitless!

Building on a century of proud service in Alberta communities, we’re passionate about making a meaningful difference in the places where we live and work. And that all begins with our people. As part of the AMA team, you’ll enjoy:

• Competitive salary and flexible benefits, with five packages to choose from and up to $3,000 in health and wellness spending accounts.
• Employer-paid retirement savings program, including 5% AMA contribution and 5% matching.
• Employee-exclusive discounts on travel, insurance, memberships, driver education, registry services, and more.
• Free travel medical insurance for you and your immediate family.
• Ongoing professional development, with unlimited learning opportunities, full Udemy access, and dedicated time for personal growth.
• Paid vacation and personal days, including three weeks of vacation to start, a Me Day, a Volunteer Day, and the option to purchase additional vacation time.
• Flexible work models that make sense for your lifestyle.
   

Who You Are

• You don’t just build reports—you create stories that help people understand and act.
• You’re fluent in Power BI (including DAX and data modeling) and strong in SQL; exposure to Python is a plus.
• You can design data models that work at both detail and executive levels.
• You collaborate naturally with data engineering teams (DET), BI architects, and business SMEs.
• You’re skilled at gathering requirements and translating them into technical design.
• You’re comfortable balancing priorities and delivering high-quality outputs under tight timelines.
• You enjoy mentoring and guiding others in BI best practices.
   

How You’ll Make an Impact

• Report to the Agile Team Lead, Analytics & Business Intelligence.
• Lead the development of BI reports and visualizations in Power BI and other BI tools based on stakeholder requirements.
• Build and maintain data models that integrate Snowflake, D3, and other enterprise sources.
• Write efficient DAX and SQL to create measures, KPIs, and business-ready insights.
• Partner with DET, BIA, and business stakeholders to align data solutions with real-world needs.
• Support governance by promoting certified datasets and following QA/release processes.
• Troubleshoot incidents, respond to stakeholder feedback, and ensure production deliverables are accurate and timely.
• Mentor analysts and business power users in BI design, data modeling, and visualization standards.
• Contribute to AMA’s quarterly board reporting and annual strategic planning with trusted measures.
   

What You Bring to the Table

• Bachelor’s degree in Computer Science, Information Systems, Business Management, or equivalent experience.
• 5+ years in BI/reporting, with strong hands-on experience in Power BI (including DAX, Power Query, and data modeling).
• Strong SQL skills and ability to work with enterprise data warehouses (Snowflake preferred).
• Experience with scripting or data prep in Python is an asset.
• Proven ability to consult with stakeholders, define requirements, and translate them into BI solutions.
• Demonstrated experience collaborating with data engineering teams and BI architects.
• Strong communication and presentation skills, especially with executives.
• Agile/Scrum experience is an asset.
   

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 [email protected]. We’ll work with you to ensure you feel supported throughout your journey with us.

WORK MODEL:

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