Power BI Data Engineer (Senior Business Intelligence Developer), Analytics & Business Intelligence - Full Time- Markham Stouffville Hospital

Please Note: If you are a current Oak Valley Health employee, apply to this job via the internal Workday application.

Land acknowledgement:

Oak Valley Health honours the traditional territory of the closest Indigenous communities, the Chippewas (chi-puh-waas) of Georgina Island and the Mississaugas of Scugog Island. The Haudenosaunee (Ho-de-no-shau-nee) and Anishinaabe (Ah-nishin-ah-beh) have lived, worked and existed on this land from time immemorial. This land is covered by Treaty 13 signed with the Mississaugas of the Credit, and the Williams Treaty signed with many Mississauga and Chippewa bands. We acknowledge that Indigenous Peoples were not asked to share their territory with settler populations and that we are all here as uninvited guests. We acknowledge and thank all generations of Indigenous Peoples across Turtle Island for their commitment, contributions, and protection of the land and its resources.

Who you are:

• You encompass Oak Valley Health’s core values and live the words of respect, trust, commitment, compassion and courage

• You are a patient and/or client centered individual who performs at an exemplary standard

• You are a team player with excellent communication, critical thinking and prioritization skills

Posting Closing Date: May 5th, 2025

Job Summary

We are seeking an experienced Senior Business Intelligence Developer to join our data analytics team. You will develop and maintain our data warehouse and reporting platform to enable our team to work closely with stakeholders to transform complex data into actionable insights that drive business decisions.

As an ideal candidate, you are comfortable working with large-scale clinical and administrative datasets, you understand how a hospital and/or information management environment functions to create effective data model, data visualization, and BI product support and maintenance.

Reporting to the Manager, Analytics & Business Intelligence, and working directly with other members of the Business Intelligence and Decision Support team and/or individuals at various levels within the organization.

Responsibilities

Development:

• Develop and maintain logical BI data models that support needs that are currently defined while being adaptable to future needs
• Design and develop Power BI dashboards, reports, and visualizations that provide meaningful insights from various data sources
• Create and maintain data models using DAX and Power Query to support reporting needs
• Utilize Power Platform components (e.g., Power Apps, Power Automate) to enhance BI solutions and automate processes
• Implement ETL processes using SQL Server Integration Services (SSIS) and/or Fabric Data Factory
• Manage the BI Server software administration and maintenance in collaboration with I.T.
• Develop SharePoint Sites
• Develop and maintain naming and object organization standards in collaboration with the BI team

Administration and Maintenance:

• Implement row-level security and manage user access within Power BI/Fabric
• Support the BI team in day to day maintenance of BI assets
• Provide training and support to end-users on Power BI tools and functionalities
• Optimize asset performance and ensure data accuracy and consistency
• Stay updated with the latest features and best practices in for technologies used by team
• Documentation of assets and processes
• Act as a backup to the Database Administrator for the basic maintenance of the database servers that support the BI environment
• Conduct data quality investigations and engage in continuous data quality improvements

 What you bring to the role:

Education:

• Completion of a recognized university degree in Computer Science, Engineering, Information Management, or equivalent combination of education and experience

Experience:

• 5+ years of experience working with data analytics and relational databases (SQL Server, Oracle) in a similar role
• 3+ years of experience as a Power BI Developer or similar role
• Strong proficiency in Power BI, including DAX, Power Query, and data modeling
• Solid experience with Microsoft Fabric
• Solid experience with SQL Server Integration Services (SSIS) for ETL processes
• Familiarity with Power Platform components, particularly Power Apps and Power Automate

Skills and Initiative:

• Self-motivated and able to work independently with minimal supervision and also possessing a positive team spirited attitude
• Excellent interpersonal and client relationship skills
• Strong written and verbal communication and presentation skills
• Ability to multi-task with strong attention to detail within a fast-paced environment with changing priorities
• Adhering to confidentiality and privacy requirements for sensitive financial and clinical information.
• Demonstrates a commitment to a healthy and safe workplace for self and others (staff, patients, families, etc.) by taking all reasonable precautions and working in compliance with hospital related policies, health and safety legislation and best practices and completing relevant mandatory education as required

Considered an asset:

• Training in Business Intelligence methods and tools (BI certification preferred e.g. MCSE BI or MCSE Data Management and Analytics).
• SharePoint development/experience
• Experience with Meditech/Epic/Cerner
• Experience in a healthcare decision support environment
• Experience with hospital data sets (e.g. DAD, NACRS, NRS, etc.), patient information systems, finance, HR, decision support and metrics
• Experience with Python
• Knowledge of health care reporting requirements (e.g. OHRS and MIS guidelines)

Work Schedule:

Monday to Friday days (900am-500pm). Schedules may change based on operational needs.

Hybrid model of in office and remote work.

Please note schedules may change due to operational needs.

Compensation:

Range:

Who we are:

Oak Valley Health is one of Ontario’s leading community healthcare organizations. Across our two hospital sites (Markham and Uxbridge) a Reactivation Care Centre (RCC), a Community Health Centre (CHC), and Hospital-to-Home programs, we provide high quality, patient-centred care to more than 468,000 patients each year. We offer diagnostic and emergency services, and deliver clinical programs in acute care medicine and surgery, addictions and mental health, and childbirth and children’s services. We are also proud to be part of the Eastern York Region North Durham Ontario Health Team (OHT).

Our 542 physicians, 35 midwives, over 3,000 staff and 1,000 volunteers serve patients and families with an Honoured to Care mindset, and are focused on delivering an extraordinary patient experience to the residents of Markham, Whitchurch-Stouffville, Uxbridge and beyond. We are dedicated to providing access to the right care, at the right time, in the right place by the right people and at the right cost.

Oak Valley Health Equity, Diversity, Inclusion and Belonging statement 

Oak Valley Health takes pride in serving some of Canada’s most diverse communities. We are committed to fostering an environment of equity and inclusivity where every person can work and receive care safely, openly and honestly. All qualified applicants will receive consideration and we encourage applications from Indigenous peoples, members of LGBTQ2+ communities, members of racialized groups, persons with disabilities, and all others who may contribute to the further diversification of Oak Valley Health. Furthermore, Oak Valley Health is committed to meeting the needs of all individuals in accordance with the Accessibility for Ontarians with Disabilities Act (AODA) and the Ontario Human Rights Code. Should you require accommodations during the recruitment and selection process, please contact Human Resources.

We are honoured to be recognized as one of Forbes Canada's Best Employers for Diversity. We ranked within the top 150 organizations across the country. Learn more about our commitment to EDIB.