Data Analytics Solutions Specialist at Bayshore Specialty Rx

Mississauga, Ontario, Canada -

Full Time

Start Date

Immediate

Expiry Date

10 Aug, 26

Salary

0.0

Posted On

12 May, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL Server, Python, Power BI, Azure Data Factory, Microsoft Fabric, DAX, PySpark, Data Modeling, ETL/ELT, Data Pipelines, Row-Level Security, Data Visualization, Data Validation, Semantic Modeling, Automation, Stakeholder Management

Industry

Hospitals and Health Care

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

How To Apply:

Incase you would like to apply to this job directly from the source, please click here

Responsibilities

Design, build, and support modern analytics solutions by transforming raw data into actionable insights using the Microsoft data stack. Develop end-to-end data pipelines and Power BI dashboards while partnering with business stakeholders to ensure data accuracy.