Senior Business Intelligence Developer Analytics Business Intelligence Job In Markham

Introduction

Overview

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-nish-in-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.

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.

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.

Work schedule:

Monday to Friday days (900am-500pm).

Please note schedules may change due to operational needs.

Compensation:

BAND G

Range: $47.86 - $58.77

COVID Statement

As a result of the COVID-19 pandemic and the need to strengthen and promote health protection to patients, staff and members of the public attending in the hospital, prior to the first day of employment with the Hospital, all successful candidates are required to provide proof of COVID-19 vaccination (full vaccination is required). In order to provide you with fair & equitable accommodation, you must submit supporting medical exemption documentation or an affidavit detailing why your religion prohibits you from receiving the COVID-19 vaccine.

Responsibilities

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, you will:

• Manage the BI Server software administration and maintenance in collaboration with I.T.
• Gather business requirements for BI products in collaboration with manager and business partners.
• Develop and maintain logical BI data models that support needs that are currently defined while being adaptable to future needs.
• Develop Extract, Translate, and Load (ETL) processes to populate the data warehouse.
• Act as a backup to the Database Administrator for the basic maintenance of the database servers that support the BI environment.
• Develop and maintain naming and object organization standards in collaboration with the BI team.
• Specify and build dashboards, scorecards, tools, and reports that support strategic and operational goals.
• Prototype and conceptualize the solution through dashboard visualization of data based on business requirements.
• Conduct data quality investigations and engage in continuous data quality improvements.
• Commit to, and actively work to remain knowledgeable and up to date in the assigned field.
• Challenge the status quo and recommend innovative ways to improve reporting process efficiency and quality.

Requirements

• Completion of a recognized university degree in Computer Science, Engineering, Information Management, or equivalent combination of education and experience.
• 3 to 5 years of experience working with data analytics and relational databases (SQL Server, Oracle) in a similar role.
• Ability to write complex SQL code, create automated schedules, modify/create views, and manage stored procedures and run performance tuning to optimize queries.
• Hands-on knowledge of data warehousing, data modelling and relational database concepts and schemas.
• Experience in working with administrating Power BI.
• Experience with Power Platform (Power Apps, Power Pages, Power Automate).
• Proven well-developed computer skills and data modelling and design to support health care operations.
• Excellent decision making, problem recognition and problem-solving skills.
• Experience in synthesis and documentation of comprehensive findings for consultation reports.
• Demonstrated commitment to continuing professional development.
• Computer proficiency in Microsoft Office.
• Demonstrated good attendance and performance records with the ability to maintain these same standards.
• 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.
• Display a positive attitude toward complex challenges as well as routine maintenance and administration tasks.
• 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.

Considered an asset:

• Training in Business Intelligence methods and tools (BI certification preferred e.g. MCSE BI or MCSE Data Management and Analytics).
• Experience in a healthcare decision support environment is an asset.
• Experience with hospital data sets (e.g., DAD, NACRS, NRS, etc.), patient information systems, finance, HR, decision support and metrics.
• Experience in working with a Business intelligent tool, particularly “Information Builders” and “Power BI."
• Experience with Python.
• Knowledge of health care reporting requirements (e.g., OHRS and MIS guidelines).

Who we are:

Oak Valley Health is one of Ontario’s leading community healthcare organizations. Across our two sites (Markham and Uxbridge) and Reactivation Care Centre (RCC), 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. Are you ready to join us?

Oak Valley Health diversity 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 sexual minority groups, 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 2023. We ranked within the top 150 organizations across the country. Learn more about our commitment to EDI.