Business Intelligence Developer

Reporting to the Principal Engineer, Data \& AI, the BI Developer supports internal data systems, reporting, and lightweight applications across the firm. This role will work closely with a senior engineer and focus on maintaining and extending existing dashboards, data pipelines, and internal tools.

This is a

hands-on, backend-leaning Business Intelligence role

with exposure to data engineering and basic application support — not a pure visualization or business reporting position. This position will be required to work in-office 2 days a week at our Toronto headquarters.

What you’ll work on:

Supporting and extending

Power BI data models,

including: Power Query (including API-based data sources and transformations); DAX measures and calculated fields; understanding and maintaining complex existing models.

Helping maintain and troubleshoot

ETL logic

that feeds dashboards and reports.

Basic

Python support:

Small bug fixes and enhancements to existing Flask-based internal apps and Ad hoc scripts or utilities as needed.

Writing and troubleshooting

basic SQL queries.

Assisting with day-to-day support of internal data tools used by operations and leadership.

What we’re looking for:

Strong working knowledge of

Power BI backend:

Comfortable with Power Query and DAX and able to read and modify existing logic (not just build visuals).

Basic proficiency in

Python:

Comfortable navigating an existing codebase and making small, targeted changes.

Working knowledge of

SQL;

SELECTs, joins, filtering, aggregations

Comfortable learning within established systems and patterns

Interest in working alongside AI-enabled internal tools (e.g., LLM-assisted workflows, automation, or data enrichment)

Detail-oriented, reliable, and comfortable working independently with guidance

Nice to have (not required):

Experience working with APIs or JSON data

Familiarity with Azure or cloud-based data tools

Some exposure to JavaScript or frontend concepts (Bootstrap-level is fine)

Interest in data engineering or internal tooling

What this role is (and isn’t):

✅ Hands-on and technical

✅ Strong exposure to real production systems

✅ Close collaboration with senior engineering

❌ Not a pure analytics or reporting role

❌ Not a senior engineering or ML role

Why this role exists:

The goal of this role is to take ownership of day-to-day BI and data support work so senior engineering effort can remain focused on higher-level system design and AI initiatives.

Salary Range:

$60,000–$70,000 CAD

Level:

Early career / junior-to-intermediate

THE COMPANY

WE BELIEVE TALENT TRANSFORMS

Caldwell is an elite executive search firm trusted by established and growth-focused companies alike. For more than 50 years we have partnered with clients to design and build extraordinary teams. Our partners don’t just place leaders—they challenge assumptions, enable strategy, and prioritize long-term fit. Built through repeat clients and referrals, Caldwell delivers clarity and results without arrogance or shortcuts. For clients seeking substance over scale, we’re the confident voice that listens—and leads. At Caldwell, our purpose is your mission.

caldwell.com