CAREER OPPORTUNITY

Data Solutions Consultant

2025-127

Choose Collingwood General & Marine Hospital:

Explore a role with Collingwood General & Marine Hospital (CGMH) and live your ideal lifestyle. Located on the shores of Georgian Bay, you have the opportunity to enjoy the 4-season recreational community.

Collingwood General and Marine Hospital (CGMH) is an 84 bed hospital located in Collingwood, Ontario (approximately 90 minutes north of Toronto) that serves more than 74,000 permanent residents and 3.5 Million annual visitors to the communities of Wasaga Beach, Collingwood, Clearview and the Blue Mountains. CGMH is an acute care hospital providing emergency care, diagnostic services including lab, imaging and cardio respiratory therapy, as well as two inpatient units (medicine and surgery). In addition, CGMH also provides care in specialty areas including obstetrics, orthopaedics, intensive care and surgery. The Hospital also provides out patient care including dialysis and a wide range of clinics including mental health and rehabilitation services. CGMH continues to provide care close to home for our community and plays a key role as an integrated orthopaedic centre for our region. For more information please visit our website at www.cgmh.on.ca and our Foundation website at www.cgmhf.com.

Corporate Culture:

At Collingwood General & Marine Hospital, we are anchored by our vision, mission and values and guided by our strategic directions. If you exhibit the core values of CGMH; Inclusive, Caring, Accountable, Respect, Excellence, Adaptable, Teamwork, we want you to join us in providing exceptional services to our patient and their families.

Benefits:

This position also includes 8% vacation pay and 14% pay in lieu of benefits as well as access to the Employee & Family Assistance Program and access to CGMH Perkopolis discounts. CGMH endorses the Health Care Providers Group Insurance Plan which provides Group Benefits for you and your eligible dependents by enrollment only.

Relocation support may be available for this opportunity. For more information, please speak with your recruitment representative when contacted for more information.

The Opportunity:

The primary focus of this role is to support the ingestion, transformation, and staging of CGMH’s datasets into a unified data platform—Microsoft Fabric. With numerous internal and external data sources, including iPort, Telehealth, the Ministry of Health (MOH), CIHI, Statistics Canada, and others, the successful candidate will collaborate closely with the CGMH data team to build and refine robust data pipelines.

In addition to data engineering, the Data Solutions Consultant will apply advanced data modeling skills to enhance the Business Intelligence team’s semantic models. The goal is to accelerate the delivery of high-value analytical solutions that support decision-making across the organization. This is a multifaceted role that blends:

• Technical expertise (particularly in data engineering and Microsoft Fabric),
• Consulting skills (requirements gathering and stakeholder engagement), and
• Project management acumen (including DevOps and CI/CD practices).

The ideal candidate is a data professional who thrives on working with meaningful datasets that directly impact patient care. This role offers a unique opportunity to shape and modernize CGMH’s data architecture—positioning the hospital for success today and in preparation for our future facility.

Qualifications:

Education:

• An undergraduate degree in Computer Science, Business Administration, Health Sciences, Health Information Management, Health Informatics, or a closely related discipline is required.

• A master’s degree in data Analytics, Health Informatics, Computer Science, or a related field is strongly preferred and will be considered a significant asset.

• Demonstrated proficiency in data analysis and programming languages, including Python (PySpark), SQL, and R.

• Familiarity with AGILE/Scrum methodologies and experience working in iterative, collaborative development environments.

• Microsoft Certification such as Fabric Analytics Engineer Associate is considered a strong asset and indicative of a candidate’s commitment to continuous learning and technical excellence.

Technical Skills:

• Minimum 3+ years of experience in data engineering, preferably with distributed technologies such as Apache Spark, Databricks, and Microsoft Fabric (Lakehouse) using Medallion Architecture.
• At least 2 years of hands-on experience with Azure Data Factory.
• Experience in data modelling using Apache Spark Notebook development
• Experience using Azure DevOps is preferred.
• Proficiency in SQL, Python (PySpark), and R for data analysis, engineering and transformation.
• Experience with Microsoft SQL Server tools and applications (e.g., SSRS, SSIS, SSMS), including authoring queries and modifying database objects.
• Experience with data visualization tools such as Power BI, Tableau, and others to create compelling, insight-driven dashboards.
• Exposure to data analytics platforms (e.g., Alteryx, Azure Synapse) for ingestion, modeling, and transformation. Understanding of DevOps practices and CI/CD pipelines in a data development context.

Healthcare and Domain Knowledge:

• Familiarity with Electronic Medical Record (EMR) systems, particularly MEDITECH Expanse.

• Awareness of Canadian healthcare datasets such as CIHI’s DAD, NACRS, NRS, CCRS, and other sector data (e.g., Wait Times, MOH, Telehealth).

• Ability to navigate and interpret complex healthcare data with a focus on improving patient outcomes.

Professional Competencies:

• A self-starter mentality with a proactive approach to problem-solving and continuous improvement.
• Strong ability to translate business requirements into actionable data solutions and provide value-driven analysis.
• Demonstrated commitment to confidentiality and privacy, especially when handling sensitive clinical and financial data.
• High attention to detail and a patient-first mindset aligned with CGMH’s values.
• Proven ability to multi-task and adapt in a fast-paced, evolving environment.
• Self-motivated with the ability to work independently and as part of a collaborative team.
• Familiarity with AGILE/Scrum methodologies and iterative development practices.
• Must strive to continuously provide a safe and supportive environment for patients, staff, physicians, and volunteers
• Must adhere to the duties of workers, as stipulated in the Occupational Health and Safety Act
• Must have an ability to effectively communicate (written and verbal) in the English language in order to provide excellent communication with team members, patients and families. Ability to communicate in additional language(s) is considered an asset.
• Must be dedicated to professional growth & development
• Must be able to perform all bona fide and essential duties of the position, which may include physical demands such as moving/transferring patients, pushing, pulling, bending, etc.
• Must have demonstrated excellent attendance/performance record
• Excellent organization and prioritization skills
• Ability to work independently and effectively communicate with other members of the health care team

Duties and Responsibilities:

• Design, develop, and maintain robust data pipelines to ingest, transform, and stage datasets from internal and external sources (e.g., MEDITECH Expanse, iPort, Telehealth, MOH, CIHI, Statistics Canada) into Microsoft Fabric using Medallion Architecture.

• Build and enhance existing semantic models by revisiting and re-engineering dimension and fact tables

• Perform complex single and multi-data source queries using SQL, Python (PySpark), and/or R to extract and validate data for internal/external information requests, data quality assurance, and project-specific initiatives.

• Validate data from data sources (relational database, flat-file, API etc) into data pipelines

• Implement and adhere to DevOps and CI/CD practices to ensure efficient, iterative development and deployment of data solutions in a collaborative, AGILE/Scrum environment.

• Build and enhance CGMH’s Semantic models (dimensions and facts) after consulting with data team members and related business SMEs.

• Develop documentation for data engineering artifacts and/or data flows

• Troubleshoot/audit/verify data quality and interface accuracy.

• Uphold data governance standards and contribute toward CGMH’s maintenance of data glossaries/dictionary/metrics catalogue and documentation.

More Information:

Location: Remote

Employee Group: Non-Union

Employment Type: Permanent Part-Time

Start Date: In line with next Hospital Orientation intake

Hours of Work: Please be reminded that as a Hospital, in order to provide the necessary patient care, our operations run 24/7. Therefore, depending on the program for which you are applying, it may be an expectation that you are available to work weekdays and weekends, as well as all shifts - days, evenings, and nights.

Wage: $49.27 - $58.51 per hour

HOW TO APPLY:

If you are interested in joining our inspiring team, please apply online before 11:59pm EST on the posting close date by submitting an updated copy of your resume and cover letter in PDF or Word format.

Due to the volume of applications, only those selected for an interview will be contacted. Please be advised that as part of the mandatory screening process CGMH requires professional references, verification of academic training, professional accreditation, plus a current Police Vulnerable Sector Check.

Collingwood General and Marine Hospital is committed to an inclusive, barrier-free selection process. We encourage all qualified individuals who may contribute to a diverse and inclusive workplace to apply. If contacted regarding a competition, please advise Human Resources of accommodation measures you may require during our selection process. Information received relating to accommodation needs of applicants will be addressed confidentially.