JOB DETAILS

Data Analytics Solutions Specialist

CompanyBayshore
LocationToronto
Work ModeOn Site
PostedJuly 30, 2026
About The Company
At Bayshore, we believe in creating special moments for our clients each and every day, whether at the bedside, on the phone or in the clinic. These moments touch the lives of our clients and our employees, and they guide the way we run our business. These moments inspire, change and encourage us. They are what we call the Bayshore difference. Bayshore HealthCare is one of the country’s leading providers of home and community health care services and is a Canadian-owned company. With over 100 locations across the country, including home care offices, pharmacies and infusion clinics, Bayshore has more than 13,000 staff members and provides care to over 350,000 clients. We are dedicated to enhancing the quality of life, dignity and independence of all Canadians, by providing customized care plans and solutions that allow clients to remain in the comfort of their own home. See what some of our clients have to say about their experience with Bayshore. We have been a recipient of Canada’s Best Managed Companies award since 2006. Chez Bayshore, nous croyons en la création de moments spéciaux pour nos clients, chaque jour, que ce soit à leur chevet, au téléphone ou dans une clinique. Nous cherchons à améliorer la qualité de vie, la dignité et l’autonomie de tous les Canadiens, en fournissant des plans de soins personnalisés et des solutions qui permettent à nos clients de rester dans le confort de leur propre foyer. Bayshore, une entreprise exclusivement canadienne, est l’un des plus importants fournisseurs de services de santé à domicile et en milieu communautaire au Canada. Avec plus de 100 établissements à travers le pays, y compris des succursales dédiées à la prestation de soins à domicile, des pharmacies et des cliniques de perfusion, Bayshore compte au-delà de 13 000 employés et prodigue des soins à plus de 350 000 clients. AP-2000672
About the Role

JOB SUMMARY 
We are seeking a detail-oriented and technically strong data professional to design, build, and 
support modern analytics and reporting solutions. This role works across SQL Server, Python, 
Power BI, Azure Data Factory, and Microsoft Fabric to transform raw data into clear, reliable, and 
actionable insights for the business. The ideal candidate combines strong technical execution with 
the ability to partner closely with business stakeholders, ensuring data is accurate, automated, 
well-documented, and easy to understand 


DUTIES AND RESPONSIBILITIES 
• Develop, maintain, and optimize data solutions using SQL Server, Azure Data Factory, and 
Microsoft Fabric to support enterprise analytics and reporting needs  
• Design and manage end-to-end data pipelines, from data ingestion through transformation 
and consumption  
• Build and maintain analytical and semantic data models that support scalable reporting and 
self-service analytics  
• Create and manage Power BI datasets, reports, and dashboards, applying best practices 
in modeling, DAX, and visualization  
• Ensure optimal performance across data models, queries, and refresh processes  
• Use Python to automate data workflows, handle files, and perform data transformation and 
validation tasks  
• Implement and manage data security and access controls, including Power BI Row-Level 
Security (RLS)  
• Partner with business stakeholders to translate reporting and analytics requirements into 
scalable, maintainable solutions  
• Proactively identify, troubleshoot, and resolve data quality, pipeline, and reporting issues  
• Produce and maintain clear documentation for data models, business logic, validation 
rules, and operational processes



QUALIFICATIONS 
• Degree in Information Technology, Computer Science, Data, or a related field  
• Relevant hands-on experience delivering data, reporting, or analytics solutions 
• Strong proficiency in SQL Server for querying, analysis, and supporting reporting solutions  
• Hands-on experience with Power BI, including data modeling, DAX, report development, 
refresh processes, and security fundamentals  
• Ability to write Python scripts for automation, data transformation, and operational support  
• Proficiency using PySpark within Spark environments (e.g., Fabric notebooks) to develop, 
optimize, and operationalize scalable ETL/ELT transformations for medallion-style 
pipelines. 
• Experience working with Microsoft Fabric for data integration, modeling, and reporting  
• Solid understanding of basic programming concepts and how they support data analysis 
and automation  
• Strong attention to detail, with a focus on data accuracy, consistency, and reliability  
• Ability to clearly explain technical concepts and results to non-technical audiences 

OTHER SKILLS AND ABILITIES 
• Experience building and managing semantic models in Power BI or Microsoft Fabric  
• Understanding of data warehousing concepts and analytical data design  
• Experience working with large or complex datasets  
• Familiarity with automated refreshes, scheduling, and operational monitoring of reports

 

At Bayshore Healthcare, our commitment to Equity, Diversity & Inclusion is our strength. This is how we bring our vision of being the difference in the lives of those we care for, work with and in our communities. We have a great sense of pride in creating a culture of belonging, where individual differences are embraced and celebrated, through programs, resources and policies that support each individuals purpose, potential and wellbeing.

 

At Bayshore Healthcare Ltd., and its subsidiaries, we are committed to fostering an inclusive workplace and operate in full compliance with all Provincial and Territorial legislation pertaining to Human Rights Codes and Accessibility requirements. To ensure continued compliance throughout the recruitment and selection process, we encourage candidates to disclose any accommodation needs they may have.

Key Skills
SQL ServerPythonPower BIAzure Data FactoryMicrosoft FabricData ModelingDAXPySparkETL/ELTData PipelinesData VisualizationRow-Level SecurityData WarehousingAutomationData QualityTechnical Documentation
Categories
Data & AnalyticsTechnologySoftwareHealthcare
Benefits
Equity, Diversity & Inclusion programsInclusive workplace cultureAccommodation support
Job Information
📋Core Responsibilities
The specialist will design, build, and maintain end-to-end data pipelines and analytical solutions using SQL Server, Azure Data Factory, and Microsoft Fabric. They will also partner with business stakeholders to translate requirements into actionable insights while ensuring data accuracy and system performance.
📋Job Type
full time
📊Experience Level
2-5
💼Company Size
5973
📊Visa Sponsorship
No
💼Language
English
🏢Working Hours
40 hours
Apply Now →

You'll be redirected to
the company's application page