eHealth Saskatchewan is a Treasury Board Crown Corporation with a unique blend of healthcare and IT services. Our vision is to empower patients and enable care, with a mission to make patient information available electronically to patients and their healthcare team. It is a complex environment, constantly evolving and quickly changing. A large and complex organization, we currently house more than 92 million lab results, 130 million prescriptions, and 500 million digital Diagnostic Images for a provincial population of one million citizens. All of this information is securely protected, delivered, and readily available to healthcare providers through a vast array of platforms and exchange tools within physician offices, acute care centers, pharmacies, and labs throughout our province. The health system in Saskatchewan has enormous data assets that can be used to improve patients’ lives.
The Data Warehouse Administrator Role
Reporting to Information and Analytical Services, duties include documenting technical requirements; developing, extending and maintaining dimensional database schemas; developing, implementing and maintaining extract-transform-load (ETL) processes, and ensuring that security and data integrity standards are met for all developed content. The Data Warehouse Administrator supports the entire data development lifecycle, including data profiling, design and development, testing, and support.
The incumbent will have extensive hands-on technical knowledge of Data Warehouse Architecture, ETL, Oracle & SQL Server database. This includes strong SQL coding skills, stored procedures, views, and other database objects. Proven skills in communication, analysis, problem solving, documentation standards and a rigor for quality control are required.
You will have the knowledge:
- a degree in computer science or a related discipline supplemented by several years of increasing responsibility within a data warehouse environment; and
- data warehousing methodology and design.
You will have the ability to:
- work independently and participate as a team member to meet the needs of clients and co-workers and to build positive work relationships;
- gather, understand, and synthesize specialized information in a way that can be applied to identify and meet the needs of the organization using SQL, Oracle, Informatica, SSIS and MicroStrategy tools;
- extract, recall, synthesize, conceptualize, and apply ideas, processes, and information to create new solutions;
- orally present or explain technical and health information to a wide variety of technical and non-technical individuals in a clear, accurate and understandable manner;
- extract, recall, synthesize, conceptualize, and apply ideas, processes, and information to create new solutions;
- orally present or explain technical and health information to a wide variety of technical and non-technical individuals in a clear, accurate and understandable manner;
- write a variety of detailed, accurate and clear material in a variety of formats at a level appropriate to the target groups;
- contribute effectively to the development of systems by using your knowledge and experience on handling data and information requirements and your strong analytical skills;
- independently prioritize and organize your own workload to meet tight deadlines and successfully complete projects in a changing environment; and
- you must be self-motivated, thorough, creative, client-oriented, responsible and flexible in order to adapt to a dynamic environment and to respond effectively to non-routine work assignments.
You will be:
- a strong team player;
- respectful of others; and
- attentive to detail.