Job Title

Junior Data Analytics Developer Location:Calgary, AB Passion Dental Groupis a growing dental support organization dedicated to empowering a network of forwardthinking dental professionals across Canada. Our mission is simple but powerful: to support clinicians in delivering exceptional patient care through collaboration, innovation, and community. We believe that data, when paired with passion and purpose, has the power to transform how care is delivered. That''s why our Data Analytics Team plays a crucial role in shaping decisions across the company, from operational efficiency to patient experience. About the Role We''re looking for aJunior Data Analytics Developerto join our talented and collaborative analytics team in Calgary. This opportunity is ideal for an earlycareer professional who enjoys solving problems with data, loves learning new technologies, and wants to make a meaningful impact in an organization that values innovation and teamwork. You''ll work under the guidance of the Data Engineering and Analytics Team Lead, contributing to production dashboards, reporting solutions, and data quality initiatives that support our clinicians and operations teams nationwide. What You''ll Do Analytics & Reporting Build, maintain, and enhance dashboards and reporting tools inPower BI (Microsoft Fabric). Develop and refine semantic data models for consistent, reliable reporting. Translate business questions into actionable analytics solutions that drive clarity and insight. Data & Platform Collaboration Partner with data engineers, architects, and product managers to deliver scalable business intelligence solutions. Support and optimize endtoend data flows, ensuring accuracy and timeliness. Work extensively withSQL, Snowflake,andMicrosoft Fabricfor data querying and analysis. Data Quality & Governance Participate in data validation, reconciliation, and documentation initiatives. Adhere to strong data governance and security practices particularly when handling sensitive or patientrelated information. Enablement & Support Create engaging documentation and provide training to help business users get the most from analytics tools. Participate in iterative feedback cycles to continuously improve reporting products. Qualifications & Requirements 1+ year of experience in business intelligence, analytics, or reporting development. Proficiency in SQL (joins, aggregations, and performance optimization). Solid understanding of Power BI (Microsoft Fabric) and data visualization best practices. Experience with DAX, ETL/ELT processes, and relational data modeling. Familiarity with Snowflake or similar cloud data warehouses. Exposure to scripting or automation tools (Python, Ansible, Terraform, etc.). Experience working in a cloud environment (AWS, Azure, or GCP). Advanced Excel skills and strong communication skills, both written and verbal. Detailoriented, collaborative, and eager to learn. Some Nice to Haves Experience with theModel Context Protocol (MCP)for AI integrations. Knowledge ofGit/GitHuband version control. Experience transforming data usingdbt. Familiarity withMicrosoft Power Automateor workflow automation. Background in healthcare, dental, or other regulated data environments. Exposure to agile or ticketbased development workflows. Why Passion Dental Group? AtPassion Dental Group, we believe our greatest strength is our people. We create a supportive, growthoriented culture where every team member feels valued whether they work in a clinic or in our support office. You''ll join an organization that celebrates innovation, teamwork, and positive impact, while contributing to the future of dental care across Canada. Learn more about our story and vision at Passion Dental Group is committed to workplace diversity and provides accommodations to applicants with disabilities throughout our hiring process. If you require accommodation through any aspect of our process, please let us know by emailing