Senior Analytics Engineer & Supply Trading

Insight Global; Calgary; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading recruitment firm is seeking an Analytics Engineer – Supply & Trading to join a major power generation company in Calgary, Alberta. The successful candidate will transform complex trading data into scalable analytics products, ensuring accuracy for decision-making. This role requires over 8 years of experience in analytics engineering and strong SQL expertise, along with familiarity with cloud environments like Snowflake and Azure. Join a vibrant team committed to diversity and inclusion.

Qualifications

• 8+ years of experience in analytics engineering, data analytics, or a senior hybrid technical/analytics role.
• Strong SQL and data modeling expertise with high-volume transactional datasets.
• Proven capability to deliver technically robust, production-ready solutions.

Responsibilities

• Transform high-volume trading data into scalable analytics products.
• Work closely with commercial stakeholders to ensure analytical solutions are accurate.
• Support decision-making for the Supply & Trading organization.

Skills

SQL expertise

Data modeling

Experience with trading datasets

Collaboration with stakeholders

Familiarity with cloud environments

Tools

Snowflake

Databricks

Azure

Job description

Job Description

Insight Global is seeking an Analytics Engineer – Supply & Trading to join a major power generation company in Calgary, Alberta, on a 12 month contract, 3-5 days a week on site. This highly embedded role supports the Supply & Trading (S&T) organization by expanding, defining, and delivering analytics that enable effective contractual and trading decision‑making.

This role serves as a critical bridge between business-facing analytics and core data engineering, transforming complex, high‑volume transactional trading data into governed, scalable data models and analytical products that align with Capital Power’s Enterprise Oversight Framework (EOF) — the company’s foundational enterprise reporting platform. The successful candidate will work closely with trading and commercial stakeholders, ensuring analytical solutions are accurate, traceable, and optimized for decision support.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [e-mail]. To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Skills and Requirements

• 8+ years of experience in analytics engineering, data analytics, data engineering, or a senior hybrid technical/analytics role.
• Strong SQL and data modeling expertise, particularly with high‑volume, financially transactional datasets such as trading, payments, exchange activity, credit, ecommerce (e.g., Shopify), or other highly governed, compliance-heavy environments.
• Hands‑on experience working with trading, commercial, or market‑based datasets (energy, commodities, financial markets, etc.).
• Proven capability to operate in a bridge role, collaborating deeply with business stakeholders while delivering technically robust, production‑ready solutions.
• Experience working within modern data platforms and cloud environments, such as:
• Snowflake
• Databricks
• Azure
• SQL‑based cloud services
• Demonstrated comfort with structured delivery models, including DevOps‑aligned development and release practices.
• Experience in one or more adjacent data domains is considered an asset.
• Experience with ETRM platforms; Allegro familiarity is an asset.