BI Developer

Mindlance; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading consulting firm in Toronto is seeking a BI Developer to enhance reporting platforms and dashboards. The role requires strong skills in Python and SQL, with 3-5 years in BI development. You will design reports, integrate metrics, and contribute to analytical solutions, driving performance and user experience. Ideal candidates will have expertise in Tableau and experience with large datasets. A background in Business or Technology is preferred.

Qualifications

• 3–5 years of experience in reporting, analytics, or BI development roles.
• Strong hands-on experience with Python scripting, including KPI development.
• Advanced SQL skills including complex joins and query optimization.

Responsibilities

• Review and analyze existing metrics for integration into reporting platforms.
• Design and refine performance-optimized reports and dashboards.
• Evaluate technical approaches and contribute to build strategies.

Skills

Reporting analytics

Python scripting

Data transformation

SAS migration

Tableau

SQL

Power BI

Dashboard optimization

Education

Business and Technology, Computer Science, or IT related field

Tools

Tableau

SQL

Power BI

Job description

Overview

Job Title: BI Developer
Location: Toronto, ON (Onsite)
Duration: 12 + Months

Responsibilities

• Involves reviewing and analyzing existing metrics to determine how they can be effectively integrated into the current reporting platform and tableau dashboards. The developer collaborates closely with other team members assisting with peer review, validating logic, and performing testing to ensure accuracy, performance, and reliability of data solutions.
• Throughout the day, the developer designs and refines reports and dashboards that are both performance-optimized and intuitive for end users, translating complex data into clear, actionable insights. In addition, developer evaluates technical approaches and provides recommendations to the team leads, actively contributing to decisions around build strategies, design solutions, and ongoing improvement to the reporting environment.
• This role requires a balance of technical expertise, collaboration and strategic thinking to support high-quality scalable, and user-focused analytics solutions.

Must have Skills

• 3–5 years of experience in reporting, analytics, or BI development roles.
• Strong hands-on experience with Python scripting, including KPI development and metric standardization
• Data transformation and automation
• Supporting legacy-to-modern migrations
• Proven experience migrating or modernizing SAS-based reporting logic into Python and SQL.
• Experience converting Oracle BI (OBI) reports into Tableau.
• Advanced SQL skills (complex joins, CTEs, window functions, query optimization).
• Strong expertise in Tableau, including Complex calculated fields and LOD expressions
• Experience in PowerBI in addition is highly desirable.
• Dashboard performance tuning
• User-centric design and interactivity
• Experience working with large-scale, relational datasets

Nice to have skills

• Background in BI reporting
• Education background in Business and Technology, Computer Science, or IT related field.
• Prior experience in Banking Industry

Mindlance is an equal opportunity employer. We are committed to inclusive, equitable, barrier-free recruitment and selection processes, and work environment in accordance with the Accessibility for Ontarians with Disabilities Act (AODA). We will be happy to work with applicants requesting accommodation at any stage of the hiring process.