Technical Specialist -Data Engineering

Technical Specialist -Data Engineering

Job Posting # : 925226

Union : Non-Union

Site : Toronto General Hospital

Department : Data Operations - Clinical Support & Performance

Reports to : Director, Data Engineering

Hours : 37.5 hours per week

Salary : $81,708-$102,141 per annum (To commensurate with experience and consistent with UHN compensation policy)

Status : Permanent Full-Time

Posted Date : Oct 3, 2023

Closing Date : Until Filled

The University Health Network, where "above all else the needs of patients come first", encompasses Toronto General Hospital, Toronto Western Hospital, Princess Margaret Cancer Centre, Toronto Rehabilitation Institute and the Michener Institute of Education.

The breadth of research, the complexity of the cases treated, and the magnitude of its educational enterprise has made UHN a national and international resource for patient care, research and education.

With a long tradition of ground breaking firsts and a purpose of "Transforming lives and communities through excellence in care, discovery and learning", the University Health Network (UHN), Canada's largest research teaching hospital, brings together over 16,000 employees, more than 1,200 physicians, 8,000+ students, and many volunteers.

UHN is a caring, creative place where amazing people are amazing the world.

UHN Data & Analytics supports UHN's growing demand for data, data-driven insights and helps TeamUHN ensure the needs of the patients come first.

Our collective goal is to better see, understand and use data to help UHN become a data-driven organization, which will help us achieve UHN's strategic goals and ultimately advance care, research and education.

UHN Data & Analytics supports UHN in data-driven decisions, data literacy, performance improvement, data governance, analytics, and automation as well as advances these capabilities through collaboration across the organization.

Position Summary

Technical Specialist is an expert in core ETL / ELT concepts, cloud-based data management, Master Data Management and data analytics & visualization who has an extensive background with Health Information Systems.

The principal responsibilities include : perform UHN Azure Cloud administration, design and implement UHN Power BI solution, develop data modeling and ETL process.

This position will provide key insights that help the organization make data-driven decisions. A wide degree of creativity and latitude is expected.

It will assist the clinical teams, financial team, HR team and other data teams with EPIC report tools, MS Azure, Power BI expertise to provide a Business Intelligence ecosystem that transforms data from multiple source systems into an extensible platform that provides business insights and analytical capabilities to UHN teams.

Duties

• Work closely with stakeholders, subject matter experts, and end-users to understand the requirements, provide technical leadership in the development of technology deliverables
• Identify and develop the appropriate technological solutions for various data needs
• Create a strategy for establishing a secure and well-managed enterprise environment in Azure
• Define and implement the security architecture to ensure data security at rest and in transit application security key management identity, management authentication and authorization
• Lead design process for network connectivity to Azure
• Establish and implement monitoring and management infrastructure for both availability and performance management
• Write efficient and performant stored procedures, views, and functions in T-SQL
• Extract data and manipulate data to be used in presentable reports and analytical tools
• Ensure accuracy & integrity of data & applications through analysis, coding, writing clear documentation & problem resolution
• Design and implement ETL processes with SSIS and / or Azure Data Factory
• Design SSAS OLAP cubes and querying them with MDX
• Experience creating and maintaining RDL reports with SSRS
• Design and works with data marts, data warehouses
• Develop dashboards, datasets, visuals, and paginated reports with Microsoft Power BI
• Provide Power BI desktop & cloud platform, gateways & administration support and expertise;
• Troubleshoot problems and questions
• Provide support to end users

Qualifications

• Undergraduate Degree in Health Informatics, Computer Science, Industrial Engineering, Business Analytics, or equivalent
• Certification in Epic Cogito BI Developer (Epic Cogito Fundamentals, Clarity Data Model, Caboodle Data Model, Clinical and / or revenue / access Data Model) or equivalent experience is ideal and can be completed during probationary period
• A minimum 3-5 years of experience in building / developing, testing, and deployment of Business Intelligence and Data Analytics in a complex healthcare environment
• Deep understanding of data and analytics technologies, ability to build technical solutions and strategies
• Microsoft Azure expertise is a must, 3+ years of experience designing and supporting Azure environments, including IaaS and PaaS
• Hands on experience using the Azure administration portal
• Demonstrable experience deploying enterprise workloads to Azure
• Experience with EPIC tools - Radar dashboards, SlicerDicer, Workbench report, Cogito SQL, Caboodle data model, Clarity data model
• Proficiency with SQL and relational database concepts
• Enterprise Data Warehouse Design / Development, Data modeling and ETL experience
• Power BI Modeling / Development / Administration. 3+ years of experience in creating visualizations and dashboards using Power BI
• Proficiency with PowerShell, Python, C# or other scripting languages
• Experience in a large IT clinical transformation within a healthcare setting is an asset

Skills

• Ability to gain an in-depth understanding of data models and data structures
• Ability to effectively work both independently and in a team-oriented environment
• Ability to quickly identify risks or issues and apply problem solving and / or escalate to management
• Skilled at tracking tasks, defining next steps, identifying owners, and holding people accountable
• Able to learn in a self-directed, fast-paced, rapidly-changing environment
• Ability to analyze data, problem-solve, and clearly communicate solutions
• Ability to understand organizational requirements and their impact on the technical aspects of a solution
• Ability to work in a complex multi-communication-channel environment
• Ability to take ownership of work activities and ensure that they are completed accurately, efficiently, and in a timely manner
• Ability to strive for excellence and willingness to put forth extra effort when necessary
• Resilience and ability to persevere in difficult situations, overcome obstacles, and reach high levels of performance, when faced with stressful work situations and time pressures

Why join UHN?

In addition to working alongside some of the most talented and inspiring healthcare professionals in the world, UHN offers a wide range of benefits, programs and perks.

It is the comprehensiveness of these offerings that makes it a differentiating factor, allowing you to find value where it matters most to you, now and throughout your career at UHN.

• Competitive offer packages
• Government organization and a member of the Healthcare of Ontario Pension Plan (HOOPP https : / / hoopp.com / )
• Close access to Transit and UHN shuttle service
• A flexible work environment
• Opportunities for development and promotions within a large organization
• Additional perks (multiple corporate discounts including : travel, restaurants, parking, phone plans, auto insurance discounts, on-site gyms, etc.)

Current UHN employees must have successfully completed their probationary period, have a good employee record along with satisfactory attendance in accordance with UHN's attendance management program, to be eligible for consideration.

Vaccines (COVID and others) are a requirement of the job unless you have an exemption on a medical ground pursuant to the Ontario Human Rights Code.

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. Applicants need to make their requirements known in advance.

Any information received related to an accommodation will be addressed confidentially.

University Health Network thanks all applicants, however, only those selected for an interview will be contacted.