Data Engineer, Enterprise Analytics

Njoyn; Newmarket; On-site; CAD 70,000 - 100,000; Full time

Job summary

An innovative healthcare organization is seeking a Data Engineer to transform care delivery through data-driven insights. This pivotal role involves designing and maintaining ETL processes, collaborating with analytics teams, and developing business intelligence solutions to enhance patient care outcomes. The ideal candidate will have a strong background in SQL Server, ETL procedures, and data governance. Join a dynamic team committed to leveraging data as a strategic asset to improve healthcare delivery and population health management. If you're passionate about data and making a difference in healthcare, this is the opportunity for you!

Qualifications

• 5+ years of experience in MS SQL Server and ETL processes.
• Strong background in developing BI reports and dashboards.

Responsibilities

• Design and maintain ETL processes and data pipelines.
• Collaborate with teams to deliver data models and reporting solutions.
• Ensure data quality and governance standards are met.

Skills

MS SQL Server

ETL Procedures

SQL Server Integration Services (SSIS)

Power BI

SQL Server Reporting Services (SSRS)

Data Warehousing

Data Analysis Expressions (DAX)

Agile Methodologies

Database Design

Data Governance

Education

Bachelor’s degree in Health Informatics

Business Intelligence certification

Tools

SQL Server Management Studio (SSMS)

Power BI

SQL Server Reporting Services (SSRS)

Job description

Business Intelligence, Analysis and Decision Support

Southlake is building healthy communities through outstanding care, innovative partnerships, and amazing people. We deliver a wide range of healthcare services to the communities of northern York Region and southern Simcoe County. Our advanced regional programs include Cancer Care and Cardiac Care and serve a broader population across the northern GTA and into Simcoe-Muskoka.

Our team of nearly 6,000 staff, physicians, volunteers, students and Patient and Family Advisors are committed to creating an environment where the best experiences happen. As a recognition of our commitment to quality and patient safety, we have received the highest distinction of Exemplary Standing from Accreditation Canada.

Job Summary

As Southlake Health looks to the future, its vision remains clear: to continue growing alongside its communities. Anchored by its commitment to people, Southlake Health is leveraging data as a critical strategic asset to transform care delivery, enhance population health management, and enable predictive analytics. Through innovation and collaboration, every initiative is driven by a desire to deliver the exceptional care patients expect and deserve, advancing health outcomes for the future.
Reporting to the Manager of Enterprise Analytics, the Data Engineer will play a pivotal role in our organization, contributing to the delivery of a comprehensive suite of analytics services to advance SouthlakeHealth’s key strategic priorities. The Data Engineer will work collaboratively with analytics resources and leaders across the organization to develop, test, and implement data solutions that facilitate real-time insights. This role requires excellent Software Development Life Cycle (SDLC), change management, and communication skills to manage multiple high priority initiatives within an agile work environment.

Primary Responsibilities

1. Design, develop, and maintain ETL/ELT processes, data pipelines, and SQL Server Integration Services (SSIS) packages feeding the landing, integration, and analytical layers of the Enterprise Data Warehouse (EDW).
2. Collaborate with Data Architect, BI Developer and Database Administrators to implement specific data mart(s) for clinical, operational and finance-oriented data and support the EDW architecture and data content growth.
3. Streamline and enhance data integration workflows across diverse data sources, leveraging best practices to meet evolving business requirements and support the expansion of Southlake's Leading Edge Analytics Platform (LEAP).
4. Partner with Business Intelligence Developers and Decision Support Consultants to deliver data models that drive accurate performance measurement and reporting processes including Power BI reports, dashboards, scorecards, and self-serve analytics solutions.
5. Employ automated mechanisms that validate data being processed and drive timely access to high quality data, in alignment with data governance standards and security protocols.
6. Establish and maintain technical documentation for ETL processes, data models, and data flows to support operational continuity and scalability.
7. Provide subject matter expertise on best practices for real-time operational data flow and reporting processes and participate in internal working groups and committees as required/assigned.

Skills & Abilities

1. 5 years of experience with database design, implementation, troubleshooting and maintenance within MS SQL Server environment required.
2. 5 years of experience developing ETL procedures and SQL Server Integration packages (SSIS) for data management of internal and external systems using SQL Server Management Studio (SSMS) required.
3. 5 years’ experience developing business intelligence reports, scorecards, and dashboards for dissemination through SQL Server Reporting Services (SSRS), Power BI and other platforms required.
4. 5 years’ Experience working with transactional and analytical processing systems (OLTP, OLAP) required.
5. 5 years’ experience programming and optimizing queries on the Meditech HIS required.
6. Implement, troubleshoot and maintain operational databases within an Enterprise Data Warehouse (EDW) for real-time and retrospective reporting and advanced analytics needs.
7. Advanced understanding of data warehousing concepts and ETL/ELT best practices required.
8. Advanced understanding of Power Query, Data Analysis Expressions (DAX), and semantic data models within Microsoft Power BI.
9. Ability to manage multiple priorities and work well under pressure to meet tight timelines.
10. Self-motivated team player able to work independently with minimal supervision.
11. Contribute to the development of sustainable business intelligence and data quality solutions including reports, balanced scorecards, DQ audits, and performance measurement dashboards for dissemination across the enterprise through SQL Server Reporting Services (SSRS), Power BI or other BI reporting platforms.
12. Develop technical specifications and standard operating procedures that facilitate knowledge transfer and streamline administration of SQL Server dependencies.
13. Execute and maintain security protocols for reporting systems in accordance with hospital data governance policies and procedures.
14. Perform other duties consistent with the job classification as required.

Qualifications

1. Bachelor’s degree in Health Informatics, Engineering, Statistics, Computer Science or related discipline from an accredited institution is required.
2. Current Business Intelligence and or Database Management related credentials/certification is preferred.

Regular and reliable attendance is an expected requirement of this position.

At Southlake, we are committed to fostering an inclusive and accessible environment. We are dedicated to building a workforce that reflects the diversity of the community in which we live and serve, including those with disabilities. Southlake is committed to providing accommodations in all parts of the hiring process. If you require an accommodation, we will work with you to meet your needs.

It is the responsibility of all Southlake employees to work in a safe manner and promote health and safety in the workplace.

Please note: If you are selected to move forward in the recruitment process, a Southlake Talent Representative will contact you via email. Please double check any emails you receive from Southlake and ensure that the address ends in @southlakeregional.org or @southlake.ca. If it does not, we do not recommend responding as your email may not be sent to the Southlake team.