Senior BI Developer

Apex Systems; Canada; On-site; CAD 61,992 - 75,768; Full time

Job summary

An IT consultancy in Canada is seeking a Senior BI Developer with advanced Power BI skills. This mid-senior level position focuses on enhancing dashboards and developing technical solutions based on stakeholder requirements. The ideal candidate will have expert DAX skills and proficiency in SQL, with experience in data querying via Snowflake and Databricks. A Bachelor's degree is required, and a Master's degree in a related field is preferred. This contract position promises dynamic work in IT Services and Health Care sectors.

Qualifications

• Expert-level DAX skills required with advanced calculations.
• Proficient in SQL for data manipulation.
• Experience querying data in Snowflake and/or Databricks, but no engineering skills needed.

Responsibilities

• Gather requirements from business stakeholders to translate into technical solutions.
• Enhance and maintain existing Power BI dashboards.
• Build and refine semantic models based on best practices.
• Collaborate with Data Engineering for data needs understanding.
• Query data in Snowflake and Databricks for model development.
• Create documentation for reports and BI artifacts.

Skills

Expert DAX skills

Proficiency in SQL

Experience with Power BI

Data querying in Snowflake

Data querying in Databricks

Education

Bachelor's degree in Computer Science or related field

Master's degree (preferred)

Tools

Power BI

Snowflake

Databricks

Job description

This range is provided by Apex Systems. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

CA$45.00/hr - CA$55.00/hr

Senior BI Developer

Duration: Contact to Hire – Expected Permanent Conversion

• We are seeking a Senior BI Developer with deep expertise in Power BI, with a strong preference for experience in Microsoft Fabric. This role is not project‑based; instead, it focuses on developing proofs of concept, enhancing existing dashboards, and supporting ongoing ad hoc reporting needs.
• A current example includes updating an existing rebates dashboard to align with upcoming program changes that will impact calculations, metrics, and KPIs.

Key Responsibilities

• Partner with business stakeholders to gather requirements and translate them into effective technical solutions.
• Enhance, optimize, and maintain existing Power BI dashboards, including complex calculations, business logic, drill‑downs, and cross‑filtering.
• Build and refine semantic models, including assessing current models and rebuilding them according to best practices.
• Collaborate with Data Engineering to understand data availability, identify gaps, and articulate data needs—without performing hands‑on data engineering.
• Query data in Snowflake and/or Databricks to support reporting and model development.
• Create and maintain documentation for reports, metrics, calculations, and BI artifacts.
• Support a team that currently includes a business analyst with limited Power BI depth and a data engineer who has built foundational but patchwork data resources.

Qualifications

• Expert‑level DAX skills, including advanced calculations and business logic.
• Proficiency in SQL.
• Experience querying data in Snowflake and/or Databricks (querying only; no engineering required).
• Proven ability to work directly with business stakeholders to gather requirements and deliver BI solutions.
• Bachelor’s degree required; Master’s degree preferred, ideally in Computer Science or a related field.

Preferred Qualifications (Nice to Have)

• Experience with Looker, particularly for customer‑facing reporting.
• DAX or Power BI certifications, with a preference for SQLBI certifications over standard Microsoft certifications.

Seniority level

Mid‑Senior level

Employment type

Contract

Job function

Information Technology

Industries

IT Services and IT Consulting and Hospitals and Health Care