Data Analytics Solutions Specialist

Bayshore HealthCare; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

Bayshore Healthcare in Toronto is seeking a detail-oriented data professional to design, build, and support modern analytics and reporting solutions across SQL Server, Python, Power BI, Azure Data Factory, and Microsoft Fabric.

This role partners with business stakeholders to ensure data is accurate, automated, well-documented, and easy to understand, with secure access controls and scalable self-service analytics.

Qualifications

• Degree in Information Technology, Computer Science, Data, or a related field.
• Hands-on experience delivering data, reporting, or analytics solutions.
• Strong proficiency in SQL Server for querying, analysis, and reporting support.
• Hands-on experience with Power BI including data modeling, DAX, report development, and security fundamentals.
• Ability to write Python scripts for automation, data transformation, and operational support.
• Proficiency using PySpark within Spark environments to develop, optimize, and run ETL/ELT transformations.
• Experience with Microsoft Fabric for data integration, modeling, and reporting.
• Strong attention to detail and focus on data accuracy and reliability.
• Ability to explain technical concepts to non-technical audiences.

Responsibilities

• Develop, maintain, and optimize data solutions using SQL Server, Azure Data Factory, and Fabric.
• Design and manage end-to-end data pipelines from ingestion through transformation to 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 with 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, 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.

Skills

SQL Server

Power BI

Python

DAX

Data Modeling

Azure Data Factory

Microsoft Fabric

PySpark

Education

Degree in Information Technology, Computer Science, Data or related field

Tools

PySpark

Fabric Notebooks

Power BI Service

Job description

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.