Database Developer and Analytics Consultant

Quinte Health; Belleville; Hybrid; CAD 80,000 - 120,000; Full time

Job summary

Quinte Health is seeking a Database Developer / Analytics Consultant to enhance our data analytics capabilities. The successful candidate will contribute to the analytics and business intelligence development, supporting our hospital's data needs. This hybrid position requires a strong background in SQL, data visualization, and healthcare analytics, providing an opportunity to make a meaningful impact in our organization.

Qualifications

• Minimum of three years in decision support analytics or database management.
• Experience in complex data environments and healthcare is preferred.
• Proficient in SQL Server development including views, stored procedures, and data models.

Responsibilities

• Extract, transform, and analyze data from multiple sources.
• Develop and maintain dashboards and reports using Power BI.
• Ensure data integrity and conduct data quality checks.

Skills

SQL

Data Analysis

Data Visualization

Problem-Solving

Education

Undergraduate Degree in Health Informatics or related field

Masters Degree (completed or in progress)

Tools

SQL Server

Power BI

Job description

The Analytics Business Intelligence and Knowledge Management team provides analytical support to programs / services across Quinte Health as well as key strategic quality performance and financial initiatives. The team is composed of experienced professionals who support the organizations data needs including reporting visualization analysis and database management.

The hospital has recently implemented a new Clinical Health Information System (Cerner) requiring an extensive backend redevelopment of our analytics infrastructure. Additionally the organization is in the early stages of implementing a data governance framework to ensure standardized documentation and improved data accessibility.

Reporting to the Director Analytics Business Intelligence and Knowledge Management the Database Developer / Analytics Consultant will be responsible for analytics and business intelligence development while contributing to the administration and documentation of the hospitals data infrastructure. This role requires expertise in data extraction transformation and visualization along with an understanding of database architecture data governance principles and documentation best practices.

This is a hybrid position which would allow for a combination of at home and onsite workdays.

Required

Undergraduate Degree in a relevant field (Health Informatics Biostatistics Epidemiology Public Health Statistics Math Engineering Computer Science Science etc.).

Masters Degree (completed or in progress) in a related discipline is an asset.

Minimum of three (3) years of experience in a decision support analytics or database management environment; healthcare experience is preferred.

Experience working in complex data environments including enterprise data warehouses and relational databases.

Proficiency in SQL Server Development including the ability to develop and maintain views stored procedures and data models.

Strong knowledge of business intelligence and visualization tools such as Power BI.

Experience working with CIHI datasets (e.g. DAD NACRS OMHRS CCRS and NRS) IntelliHealth iPort and hospital data.

Understanding of healthcare funding models such as the Growth and Efficiency Model (GEM) QBPs Bundled Care and patientbased funding.

Strong problemsolving analytical and criticalthinking skills.

Demonstrated competency in qualitative and quantitative data analysis visualization and reporting.

Ability to analyze and present complex information in an easytounderstand manner.

Strong communication interpersonal and stakeholder engagement skills.

Ability to work both independently and collaboratively in a fastpaced evolving environment.

Commitment to data governance principles including documentation of data assets and flows.

Duties

Analytics & Business Intelligence :

Extract transform and analyze data from multiple sources to support evidencebased decisionmaking performance monitoring and quality improvement initiatives.

Develop and maintain dashboards scorecards and reports using Power BI to provide meaningful insights to clinical and administrative stakeholders.

Conduct data quality checks and ensure data integrity across all reporting platforms.

Partner with internal and external stakeholders to identify data needs streamline workflows and enhance datadriven decisionmaking.

Provide technical expertise and educate endusers on data interpretation and reporting tools improving overall data literacy within the organization.

Engage in process improvement initiatives to increase efficiency and reduce manual reporting efforts.

Support reporting to and from external agencies and data portals (Ontario Health MOHLTC CIHI etc.).

Stay current with emerging trends and technologies in healthcare analytics business intelligence and data visualization.

Database Development Administration & Documentation :

Design develop and optimize data models to improve data accessibility and reporting efficiency.

Develop and maintain SQL Server views stored procedures and database structures to support the hospitals reporting and analytics needs.

Collaborate with the Data Architect and Analysts to integrate data governance principles including standardized documentation of data flows assets and reporting structures.

Contribute to the creation of a report library and data dictionary ensuring consistency and clarity across analytics products.

Assist in database performance tuning troubleshooting and maintenance activities as needed.

Document database procedures data flows and system integrations to enhance transparency and efficiency.

Identify opportunities to automate and improve data pipelines to support business intelligence and analytics functions.

Other Responsibilities :

Engage in collaborative initiatives with key hospital departments such as IT Finance Clinical Informatics.

Contribute to internal knowledgesharing initiatives to foster continuous learning within the team.

Other duties as assigned.

At Quinte Health our four hospitals unite under the core values of Imagine Its You Value Everyone We All Make a Difference and Stronger Together . We work as one team to enhance lives improve access to highquality care and build healthier communitiesright where people need it most.

Quinte Healths four hospitals are the heart of our communities delivering exceptional care close to home. As one unified team were passionate about improving lives and expanding access to highquality healthcare. Our staff physicians and volunteers dont just work herewe live grow and thrive here. If youre compassionate and driven we have exciting opportunities across our hospitals. Join us and make a real impact!

Physical Demands Analysis

Strength :

Required Rarely lifting average 510 pounds maximum 15 pounds carrying pushing / pulling.

Mobility

Required Often prolonged sitting and

Required Occasionally standing and walking on hard surfaces bending / stooping.

Dexterity

Required Frequently gripping / grasping eye / hand coordination and

Required Briefly reaching with both hands.

We thank all interested candidates for their response however only those chosen for an interview will be contacted. Quinte Health is an equal opportunity employer committed to meeting needs under the Canadian Charter of Rights and Freedom and the Ontario Human Rights Code. Our Recruitment process follows the Accessibility for Ontarians with Disabilities Act in order to provide a fair and equitable process for all candidates. Applicants requiring accommodation through the recruitment / interview process are encouraged to contact the Human Resources Department atx2577 or for assistance.

Required Experience :

Contract

Key Skills

Databases,SQL,Database Development,PL / SQL,Microsoft SQL Server,ssrs,Database Design,SSIS,T Sql,Sybase,Data Warehouse,Oracle

Employment Type : Unclear

Experience : years

Vacancy : 1

Create a job alert for this search

Database Developer • Belleville, Ontario, Canada