Data Warehouse Administrator

Job Responsibility: Employment Type: Permanent Full-time Location(s): SK Salary Range: $41.934- $51.038 Hourly Salary Supplement: included in hourly salary range (in-scope) Why eHealth? We may be biased, but eHealth Saskatchewan is the place to be right now! As the result of a province wide consolidation of IT services in the health care sector, we have seen substantial growth in our organization that is only going to increase as we aim to meet our expanded mandate and the immense need for our support. This gives our people a unique and rare opportunity to truly create, build, improve, and leave their mark on a growing organization. A large and complex organization, eHealth is comprised of 30+ clinical and non-clinical program (service) areas that all work together to support health care providers and teams across the province in delivering the best possible care to patients, providers, citizens, and health system users. Programs range from primary care to acute care, and includes laboratories, pharmaceuticals, and diagnostics. Additional programs that also support patient care and information include Virtual Care, the MySaskHealthRecord, and the Provincial Electronic Health Record. eHealth is also responsible for the administration of various pieces of legislation to manage the registration of/changes to all vital event records (e.g. birth, marriage, death, etc.), registration of legal name changes, registration of adoptions, and for maintaining the provincial health registry for health services eligibility and distribution of health services cards. The eHealth teams engage directly with health system partners and other stakeholders both provincially and federally to ensure all services are delivered efficiently and effectively. About the Role - Data Warehouse Administrator: Reporting to the Manager of Data Management, this position will be responsible for the development of the functional components of data warehouse applications. You will work collaboratively with key stakeholders to build solutions within the corporate architecture framework. You will be responsible for all of the functionality that is required to perform system level monitoring and tuning; ensuring that both the data warehouse is functioning at an optimum level and that all appropriate system backups, including disaster recovery, are in place, current and running. In addition, you will be responsible for the automation and monitoring of production activities required by the data warehouse including extract and load functions, encryption techniques, repetitive queries and reports, and defining, developing and monitoring access. What we are looking for: The successful candidate would have gained the knowledge and skills required for this position through the completion of a post-secondary (diploma or degree) in computer science, or a related quantitative discipline. In addition to educational requirements, the successful candidate will have a minimum of 4 years of increasing data integration responsibility within a complex work environment. A combination of education and experience may be considered. Additional skills include:

• Strong background in both Oracle and SQL Server databases;
• MicroStrategy and PowerBI products;
• R, Python and PowerShell;
• MS SQL business intelligence tools, including, but not limited to: SQL Reporting Services, SQL Analysis Services, and SQL Integration Services.
• Technical knowledge of database concepts, theories, and data integration using various computer platforms
• ETL (Informatica is preferred),
• Strong computer programming skills and demonstrated proven experience with report creation and data extraction.
• Excellent knowledge of the Microsoft Office package.
• Exceptional written and verbal communication skills and one who thrives in a dynamic, technology driven environment.
• Proven experience and skills in effective communication, problem solving, data analysis, and documentation standards.
• Thorough understanding of change management protocols and quality control are also required
• Knowledge of the health environment and of data quality improvement techniques would be an additional asset.
• Proven skills in communication, analysis, problem solving, documentation standards and a rigor for quality control are required.
Competencies:Problem Solving
• Extract, recall, synthesize, conceptualize, and apply ideas, processes, and information to create creative and innovative new solutions.
Technical
• Technical knowledge of database concepts, theories, and data integration using various computer platforms.
• Strong computer programming skills and demonstrated proven experience on report creation and data extraction.
• Excellent knowledge of the Microsoft Office package.
• Data integration, data warehousing methodology, and logical data model design.
• Demonstrated ability to 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, R, Python, PowerShell, SSIS, Power BI and MicroStrategy tools with a focus on maintaining data integrity, privacy and security.
Team/Independence
• Build positive work relationships.
• Work independently and participate as a team member to meet the needs of customers, partners and co-workers.
Organizational
• Independently prioritize and organize your own workload to meet tight deadlines and successfully complete projects in a changing environment.
Analytical
• Ability to identify, explore and evaluate options on data, processes and methodologies, information technology and potential systems designed to make feasible recommendations.
• Thorough understanding of change management protocols and quality control are also required.
Communication
• Exceptional written and verbal communication skills, and thrives in a dynamic, technology driven environment.
• Proven experience and skills in effective communication, problem solving, data analysis, documentation standards.
If you are looking for an opportunity to challenge yourself and showcase your abilities, we would love to hear from you. Level: SGEU-SID10Anticipated start date: x1 Immediate, x1 April 28thLocation: Open to SK (On-site) We are committed to workplace diversity. Number of Openings: 2 Closing Date: Mar 22, 12:59:00 AM
Contact Us