Business Intelligence And Data Warehouse Analyst

Board of Health Newmarket York Regional Health Service Department
Department: Environmental Services Department
Branch: Business Planning and Operations Support Branch
Status: Temporary Full-Time
Length of Assignment: Approx. 12 months
Location: Newmarket / Ontario
Date Posted: February 13, 2020
Date Closing: March 13, 2020
Number Of Positions: 1


$44.63 to $ 48.51per hour
This is a Replacement
Union position - CUPE Local 905 (York Region Unit)

Scheduled Hours


Scheduled Shifts

0830 – 1630

Position Purpose

Reporting to the Program Manager, Data Management & Business Intelligence, is responsible for enhancing and implementing data validation and business intelligence technology solutions; enabling users’ secure access to quality data; documenting ETL specifications, such as source to target mappings, business rule and data validation requirements; providing technical support, software upgrades, operations and maintenance for data and analytics solutions; and coordinating development efforts with team members.

Major Responsibilities

•Coordinates and provides support for the implementation of Data Warehouse & Business Intelligence (DWBI) projects in the Department.
•Extracts, mines, evaluates, analyzes, and researches data from the Data Warehouse which contains data from the various systems.
•Assesses impact of DWBI system on existing business processes and procedures and makes recommendations to management staff for revisions and develops transition plans.
•Researches, analyzes, organizes, implements and documents data acquisition, transformation, creation and maintenance processes, and ensures that data meets Department’s quality requirements.
•Maintains data approval workflow.
•Designs and maintains Extract Transfer Loads process and validates results with business users.
•Assists data owners and end users to perform data validation quality checks; reviews and analyzes the results of program and systems testing with end users.
•Assists with the development and analysis of data standards; identifies issues and assists with/implements resolutions.
•Liaises with internal staff, providing systems expertise and support; shares information regarding initiatives and other best practices with Branch and Department staff.
•Liaises with vendors/business owners of source systems and with external vendors on software and hardware updates, new product initiatives, and other systems related information, in conjunction with ITS Branch.
•Maintains expertise by reviewing technical literature, attending seminars, conferences and training as directed and shares information regarding initiatives and other best practices with Branch and Department staff.
•Performs backup duties of other Business Data and Technology Management staff, as assigned.


•Successful completion of a Community College Diploma in Information Technology, Computer Sciences or approved equivalent combination of education and experience.
•Minimum three (3) years of demonstrated hands-on experience extracting, mining, analyzing, and reporting technical data generated from data management systems, data integrity and security; creating and maintaining data files to support software configurations; and providing support for the development, implementation, operation and maintenance of specialized automated systems and related applications.
•Demonstrated experience creating interactive dashboards using visulization tools (e.g. PowerBI, Tableau and Crystal Reports).
•Knowledge of data, internet, and networking technologies, Data Warehouse and Business Intelligence.
•Knowledge of database and programming languages (e.g. PL/SQL, Visual Basic, SQL, Oracle, JavaScript, HTML, XML, SharePoint, SCADA, Maximo, MS SQL, GIS, MS Project Server, PeopleSoft).

How to Apply

Please apply online by March 13, 2020 . We thank all candidates for their interest, however only those selected for an interview will be contacted via email.

Apply for this job

Latest Posts