Bayshore HealthCare is one of the Canada’s leading providers of home and community health care services and is a privately owned company. Bayshore HealthCare is proud to showcase its achievement as a Platinum member of Canada’s Best Managed Companies Program every year since 2006.  Bayshore Healthcare is also recognized as Canada’s Best Employers in Forbes 2023 list. 

Reporting to the Team Lead, Enterprise Data Architecture and Engineering, the Sr. Enterprise Data Engineer (“Data Engineer”) supports both the on-premises and cloud analytic environments within Bayshore. This currently includes an on-premises SQL Server Enterprise environment (Data Lake, Data Warehouse, Data Marts and Cubes), as well as a new Enterprise Analytic Data Fabric in Azure.  In this capacity, you will be primarily responsible for designing, developing and maintaining the structures to support Data Analytics within Bayshore, including but not limited to; OLAP databases, data modeling, and data transformations, pipelines, notebooks, stored procedures. In depth knowledge of Azure and other could platforms and related resources. You will possess a combination of business knowledge, technical skills, and people skills to effectively support the end-to-end data analytic strategy.

DUTIES AND RESPONSIBILITIES:

• Design and build scalable and resilient Data & Analytics solutions in both SQL Server Enterprise (on-premises) and Microsoft Azure (cloud).
• Design and model data warehouse and data marts using various data model techniques.
• Design and build technical solutions, both on-premises and in the cloud, to ingest, process, store and provision data for analytics.
• Design OLTP and dimensional data models, and maintain consistency between data models and databases.
• Design and document source to target transformation rules and data mapping, in SSIS and in Azure Data Factory.
•   Develop batch processing solutions using Azure Data Factory pipelines, Triggers and Integration Runtime.
• Develop source and target reconciliation report to validate data transformations.
• Design database objects, i.e., index, trigger, stored procedures, and develop database change scripts.
• Develop and maintain SQL queries and depth knowledge of performance tuning of slow running queries.
• Work on automation and optimization of internal processes in Azure.
• Participate in the review of maintenance release artefacts - Use Case, System Requirement Specification, etc.
• Investigate and resolve issues in both the on-premises, and cloud, analytic environments.
• Deliver detailed system design documents and any other supporting documentation conforming to standards.
• Provide effective knowledge transfer when required.

REPORTING RELATIONSHIPS:

• The Sr. Enterprise Data Engineer reports directly to Team Lead, Enterprise Data Architecture and Engineering.