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 (a first of 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.

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.

• 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.