THE ROLE
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
- 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
- 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
- Able to read and modify existing logic (not just build visuals)
- Basic proficiency in Python
- Comfortable navigating an existing codebase
- 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 efforts 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
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.
