Senior Data Analyst

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

Job summary

A major dental network located in Toronto is seeking a highly skilled Senior Data Analyst to join their Business Intelligence team. This role involves designing and delivering analytics solutions using Power BI and SQL. Ideal candidates will have over 8 years of experience in data analysis and strong expertise in Power BI and SQL development. A collaborative environment with competitive compensation and benefits awaits the right candidate.

Benefits

Competitive salary

Benefits package

Professional development opportunities

Collaborative team environment

Qualifications

• 8+ years of experience in data analysis and reporting.
• 5+ years of Power BI development experience.

Responsibilities

• Design, develop, and maintain Power BI reports and dashboards.
• Build SQL-based stored procedures and views.
• Collaborate with data engineers and stakeholders.

Skills

Expert-level SQL proficiency

Power BI data modeling

DAX calculations

Analytical skills

Problem-solving

Education

Bachelor’s degree in a related field

Tools

Power BI

SQL

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.

J-18808-Ljbffr