Senior Data Analyst

123Dentist; Toronto; On-site; CAD 65,000 - 90,000; Full time

Job summary

123Dentist, Canada's largest dentist-owned network, is looking for a Senior Data Analyst specializing in Power BI. You will create enterprise-grade analytics solutions using SQL and Power BI while collaborating within a dynamic team. This mid-senior level position offers a competitive salary and great benefits, empowering you to make a significant impact in a growing company.

Benefits

Competitive salary and benefits package

Full-time permanent employment

Supportive and collaborative team environment

Challenging and rewarding role

Qualifications

• 8+ years of experience in data analysis and reporting.
• 5+ years of hands-on Power BI development.
• Expert-level proficiency in SQL.

Responsibilities

• Design and maintain Power BI reports based on enterprise data models.
• Build SQL-based stored procedures and views for data consistency.
• Collaborate with data engineers and business stakeholders.

Skills

SQL

Power BI

DAX

Data Modeling

Automation

Education

Bachelor’s degree in computer science, Information Systems, or related field

Tools

Power BI

Azure DevOps

Git

Job description

123Dentist is Canada’s largest majority dentist-owned network of dental practices, with almost 500 locations nationwide and nearly 8,000 employees. We offer professional advancement opportunities, competitive compensation, corporate sponsored incentive programs such as long-term bonuses for full-time employees (afirstof its kind in the Canadian dental industry), and a long-term career in a growing network located in multiple communities across the country, at all levels of the industry.

Whether you’re entering the job market or you’re an experienced practitioner, we welcome your interest! Come join the 123Dentist team and be part of our success.

We provide Canadian dentists and dental practices with an array of non-clinical support and resources, including accounting, HR, marketing, as well as supply & equipment procurement.

By leveraging our unmatched management experience, marketing expertise and state-of-the-art technologies, we allow dentists to take advantage of a practical and effective alternative to practice ownership and focus on what they’re best at – being a dentist!

Job Overview:

We are looking for a highly skilled and experienced Senior Data Analyst – Power BI to join our Business Intelligence team. This role is critical in designing and delivering enterprise-grade analytics solutions, using centralized SQL-based data modeling and advanced Power BI features. The ideal candidate will be passionate about data architecture, performance optimization, and scalable reporting, with strong experience in automation and BI governance.

This position requires a strong foundation in SQL development and Power BI report design, combined with the ability to work collaboratively in a fast-paced, data-driven environment.

Responsibilities and Duties:

• Design, develop, and maintain Power BI reports and dashboards based on enterprise-level data models using star or snowflake schemas.
• Build robust SQL-based data stored procedures and views, ensuring all business logic and transformations are centralized in SQL to support consistency, maintainability, and optimized performance.
• Create complex DAX measures, calculated columns, KPIs, and time intelligence functions for executive and operational reporting.
• Ensure Power BI models are clean, efficient, and optimized for large data volumes and quick refresh cycles.
• Implement advanced Power BI features, including Row-Level Security (RLS), field parameters, composite models, drill-through, and Paginated Reports.
• Use the Power BI REST API to automate tasks such as publishing reports, refreshing datasets, managing workspaces, and enabling Power BI Embedded scenarios for application integration.
• Support Power BI deployment pipelines and version control by integrating with Azure DevOps and Git, enabling CI/CD workflows and controlled, auditable release processes.
• Conduct gap analysis and ensure high data quality across reports and dashboards.
• Collaborate closely with data engineers, business stakeholders, and other analysts to ensure business requirements are translated into scalable, governed BI solutions.
• Stay updated on the latest BI technologies, with interest or experience in Microsoft Fabric, AI, and forecasting tools considered an asset.
  
  

Education, Credentials, Qualifications:

• Bachelor’s degree in computer science, Information Systems, Data Analytics, Engineering, or a related field.
• 8+ years of experience in data analysis, reporting, and data visualization.
• 8+ years of advanced SQL development experience.
• 5+ years of hands-on Power BI development and dashboard creation.
  
  

Required Skills & Abilities:

• Expert-level proficiency in SQL, including use of stored procedures, CTEs, temp tables, loops, and other procedural logic.
• Strong experience with Power BI data modeling, DAX calculations, and managing relationships.
• Deep understanding of BI architecture best practices, including pushing all logic to SQL and minimizing Power Query (M) usage.
• Proven track record deploying Power BI at an enterprise scale, managing large datasets and optimizing performance.
• Experience with Power BI REST API, Embedded Power BI, and automation tools such as PowerShell or Python.
• Familiarity with deployment pipelines, CI/CD tools (especially Azure DevOps), and Git version control.
• Excellent analytical, problem-solving, and communication skills.
• Ability to work independently and as part of a collaborative team.
• Bonus: Knowledge of Microsoft Fabric, AI-driven analytics, and forecasting models is a plus.
  
  

What We are Offering:

• Full-time permanent employment, competitive salary and great benefits package
• A collaborative team that will support and train you, great office environment
• Challenging and rewarding role that will develop your skillset and talent
• Dynamic, fast paced and growing company, with an entrepreneurial, ‘can do’ attitude
  
  

Why Join Us? At 123Dentist, we value a diverse and inclusive workplace and offer a dynamic environment where you can make an impact on the total rewards experience for our team members across the country.

123Dentist is an equal opportunity employer committed to diversity and inclusivity. The organization strives to build a workforce that reflects the communities it serves, including individuals with disabilities. Accommodations are available upon request throughout the recruitment process. Please inform our team if you need assistance at any stage.

We thank all candidates for their interest; however, only those selected for an interview will be contacted.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Hospitals and Health Care

Referrals increase your chances of interviewing at 123Dentist by 2x

Get notified about new Senior Data Analyst jobs in Toronto, Ontario, Canada.

Greater Toronto Area, Canada $65 - $90 3 weeks ago

Senior Analyst, Credit Risk Data, Analytics, and Platforms

Senior Data Analyst – Measurement, Triangle Retail Media

Intermediate Business Analyst - Client Data and Onboarding

Toronto, Ontario, Canada $85,000 - $110,000 2 weeks ago

Business Analyst, Investment Data Operations

Senior Analyst - Business Support Strategy & Incident Management

Greater Toronto Area, Canada CA$87,596.60 - CA$109,509.40 3 days ago

Senior Business Analyst, Data Integration & Performance Platform (12 month contract)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.