Technical Specialist, Data Engineering #2

Salary: $78,254 – $97,000 annually based on experience

Get ready to digitally enable the good work at UHN, as you become a key part of data management evolution.

As a Technical Specialist reporting to the Senior Manager of Data Engineering, you are strong in Business Intelligence and Data Analytics, with a specific focus on present and emerging data technology. You’re an expert in core ETL/ELT concepts, cloud-based data management, Master Data Management and data analytics & visualization who has an extensive background with ADT / Health Information Systems. You are a SQL expert in several database management systems, and you rely on your seasoned technical abilities as well as your creativity to produce stunning data models and visualizations.

When it comes to Business Intelligence and Data Analytics, you are ahead of the pack as you look to emerging cloud BI technology and NoSQL databases to supplement or replace on-prem or traditional data warehouse solutions, often doing so with agile projects. To round off your skills, you are a master in reading the stories the data is telling you and visually sharing those stories with your stakeholders at all levels of the enterprise in meaningful ways. Finally, others describe you as a highly skilled team player with loads of emotional intelligence. Those looking to make a positive and meaningful impact on an agile team in the healthcare industry are most welcome to apply now.

Your daily impact will include:

Creating / maintaining data models, processes and ETL packages to feed data repositories
Working with executive level stakeholders on high visibility, real-time, responsive data visualizations used throughout the enterprise
Augmenting existing business data sharing processes and capabilities with modern tools and methodologies
Creating a road-map for feeding data warehouse data into data lake or cloud DW technologies
Contributing to a multi-million dollar Health Information System evolution project
Migrating on-prem reporting systems into present day cloud solutions
Leading the organization in setting standards for the visualization of descriptive and predictive analytics data
Writing advanced / complex SQL queries and scripts to pool data sources
Providing tuning expertise to technical business report creators
Developing efficient PL/SQL packages and SQL Server stored procedures
Pulling data from REST API’s including HL7-FHIR / XML / JSON
ELT solutions in cloud-based / data lake data storage technologies
Developing new ways to more efficiently store and move data across the major hospitals of downtown Toronto
Microsoft SharePoint / embedded application development with Power BI reports and APIs
Positively disrupting how business decisions are made by re-developing business reports into meaningful, visual formats in current BI platforms
Empowering the business to create, maintain and share Business Intelligence, including the underlying data sets
Ensuring data can be fluidly and securely shared across the enterprise
Fulfilling Enterprise Data Warehouse maintenance responsibilities including data requests
Administering present-day BI tools and migrating data sets into newer technologies
Project and cross-team collaborative responsibilities not explicitly listed above

Minimum Qualifications

Bachelor of (Computer) Science, Computer Engineering, Mathematics or related major required
5 years of extensive ETL/ELT building and monitoring experience for data warehouses and/or data lakes required
Databases: Proficiency in Oracle 12c/18c , SQL Server 2016/2019, Postgres
5 years of Descriptive Analytics reporting through Business Intelligence tools required
5 years experience in building data cubes, slicing/dicing data, and access controls to share data sets between individual and roles required
MSBI solutions experience including Microsoft Power BI, SSRS / SSIS , proficiency in DAX programming required
Masterful SQL, PL/SQL, T-SQL, shell scripting and programming skills
Other Business Intelligence tools: IBM Cognos required
Figure-it-out mentality with a positive, team-oriented attitude; a long history of charismatic self-starting and positive disruption
Proven ability to adapt priorities in a complex, fast-paced, fluid environment
Superior verbal, written communication and presentation skills to disseminate information to all business areas and levels of leadership
A history of working on agile / devOps teams
Working knowledge of Microsoft Power BI required

Preferred Qualifications

Master Data Management experience with multiple MDM solutions / architectures preferred
Experience in Healthcare Information Systems strongly preferred
Additional Databases: Couch DB
Advanced expertise with Microsoft Excel, pivot tables, formulas, functions
Microsoft Azure experience, including Azure Data Factory preferred
Proficiency in Azure Embedded applications development, embedding Power BI preferred
Big Data technology and NoSQL database experience preferred
Information Technology Infrastructure Library (ITIL) working environment
Microsoft Certified Solutions Expert (MCSE) designation(s): Data Management and Analytics (BI Development, BI Reporting or Data Engineering with Azure)
Oracle Certified Professional designation(s): PL/SQL Developer, Cloud
Microsoft DAX and and/or MSBI/Power BI training transcript
Fundamental Machine Learning and Artificial Intelligence training
Information Technology Infrastructure Library (ITIL) certification
Experience with Healthcare Information System migrations in Ontario an asset
HL7 / FHIR training transcript

POSTED DATE: September 14 – October 5, 2020

Staffing Advisor, Human Resources RFE 2nd Floor – Posting #861803

For current UHN employees, only those who have successfully completed their probationary period, have a good employee record along with satisfactory attendance in accordance with UHN’s attendance management program, and possess all the required experience and qualifications should apply.

University Health Network thanks all applicants, however, only those selected for an interview will be contacted. UHN is a respectful, caring, and inclusive workplace. We are committed to championing accessibility, diversity and equal opportunity. Requests for accommodation can be made at any stage of the recruitment process providing the applicant has met the Bona-fide requirements for the open position. Applicants need to make their requirements known when contacted.