Business Analyst

Exchanger Industries Limited; Calgary; On-site; CAD 90,000 - 130,000; Full time

Job summary

Exchanger Industries Limited (EIL) is Calgary-based and Canada’s leader in custom heat transfer solutions. This role sits at the intersection of engineering execution and analytics, using Copilot, Power BI AI, and AI-assisted Excel to turn data into a storytelling narrative for leadership.

You will translate leadership questions into concrete analytics requirements, partner with IT on data access and security, and orchestrate outputs from multiple AI agents to deliver a single, validated view

Qualifications

• Bachelor's degree or diploma in a relevant field is required.
• 2–4 years in analytics, with business, engineering, or commercial focus.
• Hands-on experience using AI tools for analysis and reporting (e.g., Copilot, Power BI AI, AI-assisted Excel).
• Ability to translate business questions into buildable data requirements for developers.

Responsibilities

• AI enablement & orchestration: accelerate report creation and narratives with AI while validating outputs for accuracy and context.
• Orchestrate outputs across multiple AI agents and package findings for leadership.
• Translate KPIs and questions into clear requirements for internal developers.
• Collaborate with IT on data access, security, and scalable analytics solutions.

Skills

Analytical thinking

Business partnering

Clear communication

Problem solving

Education

Bachelor's degree in Information Systems, Computer Science, Engineering, Business Management, or related

Tools

Microsoft Fabric/Azure data tools

Power BI

HubSpot CRM

SQL

APIs/Connectors

Job description

About the job

Most analyst roles ask you to report on the business. This one asks you to help build how the business sees itself – and how it puts AI to work.

Exchanger Industries Limited (EIL) is Canada’s leading provider of custom heat transfer solutions. We’re an Alberta-based, globally recognized manufacturer of innovative, quality, custom heat transfer equipment, services, and solutions. Our roots are in the Alberta oil fields, but our customers, our project record, and our data now span the globe.

About this role

We’re looking for someone who’s genuinely hard to find. This role sits where engineering execution meets commercial performance – and, increasingly, where the business meets its AI tools. It takes the rigour to stand behind every number: to trace a KPI back to its formula, its source, and the decision it’s meant to support. It also takes someone fluent enough with Microsoft Copilot, Power BI’s AI features, and AI‑assisted Excel to turn raw data into a clear story in a fraction of the usual time.

This role has grown past “analyst who uses AI.” You’ll be the human hub in the middle of EIL’s analytics and AI build‑out: translating leadership’s questions into requirements our internal software developer and external consultants can build against, partnering with IT on the data access and security that lets it all scale, and orchestrating the outputs of multiple AI agents (sales and pipeline, capacity, financial) into one validated picture leadership can act on.

If you want to help shape how a company deploys AI rather than just consume it, this was written for you.

What you’ll do

AI enablement & orchestration

• Use Microsoft Copilot, Power BI AI features, and AI‑assisted tools to accelerate report creation, insight generation, and automated narrative summaries – then apply judgment to validate every output for accuracy, relevance, and business context
• Act as the orchestration point across multiple AI agents (sales/pipeline, capacity, financial): validate outputs, flag conflicting signals, and package findings for leadership
• Translate business questions and KPI definitions into clear requirements our internal software developer can build against
• Help scope, test, and roll out new analytics and AI tools alongside external consultants and internal stakeholders
  Partner with IT on data access, security, and implementation practices that let business analytics scale

Engineering analytics

• Build and continuously improve dashboards tracking drafting hours, capacity loading, milestone performance versus baseline, and rework trends
• Analyze hours expended versus budget by activity and product group; run department loading analysis to flag capacity and resource risks early
• Prepare variance and root‑cause reporting for leadership review
• Analyze rework hours from timesheet data and categorize quality drivers to support corrective action
• Reinforce accurate time tracking and data coding across the drafting team

Sales & business development analytics

• Analyze sales performance by product line, region, channel, and salesperson; track revenue, conversion rates, average deal size, and pipeline health
• Prepare sales forecasts and demand projections; support quota setting and territory planning
• Produce weekly, monthly, and quarterly reporting, and prepare the Monthly Sales Report with senior leadership

CRM, data quality & governance

• Own HubSpot data hygiene and governance; analyze deal progression and stage velocity
• Define and maintain EIL’s KPI dictionary (definitions, formulas, owners, refresh cadence, and the decision each metric supports)
• Implement automated data‑quality checks with exception reporting, and run monthly data‑quality reviews with Sales Ops, Engineering, and Finance

What you bring

• A bachelor’s degree or diploma in Information Systems, Computer Science, Engineering, Business Management, or a related discipline
• Experience with Microsoft Fabric or Azure data tools
  2–4 years in a business, engineering, or commercial analytics environment
• Hands‑on experience using AI tools for analysis and reporting (Microsoft Copilot, Power BI AI features, AI‑assisted Excel) paired with the judgment to know when the output is right and when it isn’t
• The instinct to sit between business and technical builders – turning a fuzzy business question into a clear, buildable requirement
• Strong Excel (Power Pivot a bonus) and the discipline to standardize templates that feed reliable reporting
• Working proficiency across Microsoft 365, HubSpot CRM, and Power BI
• SQL for querying and joining data, and experience with APIs/connectors (HubSpot to Power BI)
• Statistical thinking and structured problem solving: root cause, variance analysis, corrective action
• Genuinely clear communication – the ability to hand leadership a story they can act on

Strong assets: exposure to automation and agent platforms such as Copilot Studio or Power Automate; CBAP certification.

Work environment

Primarily office-based in the Calgary area, with day‑to‑day collaboration across Engineering, Drafting, Sales, Business Development, Estimating, Finance, Operations, and IT.

Room to grow

Depending on your strengths and interests, this role can open into estimating and product sales support, business development and market analysis, opportunity sizing, and customer‑facing work.

Exchanger Industries Limited is an equal‑opportunity employer. We thank all applicants for their interest; only those selected for an interview will be contacted.

Requirements

• Authorized to work in Canada
• 5+ years of work experience with Microsoft Power BI