Specialist, Business Intelligence Data Warehouse
About the role
Job Description In accordance with the Vision, Purpose, and Values, and strategic direction of the Vancouver Island Health Authority (Island Health), patient safety is a priority and a responsibility shared by everyone; as such, the requirement to continuously improve quality and safety is inherent in all aspects of this position.
Reporting to the Manager, Enterprise Data Warehouse, the Specialist, Business Intelligence Data Warehouse develops, manages, and updates data models, including physical and logical models of the data warehouse, data mart, and staging area, and sometimes the operational data store and source systems. The Specialist is a lead resource responsible for the architecture, design, implementation, and operational support of the Business Intelligence databases, data repositories, and related infrastructure.
The Specialist is accountable for the day-to-day data warehouse environment that includes applications, systems, and services that are mission-critical and requires twenty-four hour support. The Specialist plays a key leadership role in the recovery process in the event of critical system outages.
QUALIFICATIONS: Education, Training And Experience A level of education, training and experience equivalent to a Bachelor's Degree in Computer Science and at least five (5) years' recent related experience in areas such as management of data warehouse implementations, performance of MS SQL Server DBA functions including backup and recovery, performance monitoring, performance optimization, disk space utilization, software installation and upgrades, logical and physical data modeling, development of stored procedures, triggers, views, and other database objects, ETL procedures; large scale project management; health care clinical and administrative implementations.
Skills And Abilities
- Effective interpersonal, verbal, and written communication skills.
- Ability to write programs in a variety of programming languages.
- Ability to transfer knowledge and skills to other department staff.
- Ability to provide clear and concise system documentation and procedures for other staff.
- Ability to keep skill set up to date with new technologies as they are introduced to the workplace.
- Data standards, database structures, database server administration.
- Familiarity with HL7, XML, MIS guidelines.
- Strong understanding of Cognos from a development and architecture perspective.
- Ability to work independently and organize workload and priorities with minimal supervision.
- Superior database querying skills including using Structured Query Language.
- Physical ability to perform job.
- Strong conceptual, communications, and technical skills.
- Ability to translate business needs into technical solutions.
- Strong relational and dimensional data modeling and database design skills.
Link To Full Job Description https://jd.viha.ca/JD3414.pdf
About Island Health
Island Health operates primary care clinics in Anacortes and on Orcas Island, and serves patients across three counties (Skagit, Island and San Juan). Our specialty services are extensive and rapidly adapting to meet the needs of our community. At Island Health, our patients are cared for by dedicated medical professionals who live and work in the community. We are a small but mighty health system, renowned for our holistic approach to patient care where our healthcare professionals treat our patients with compassion and respect. As a 5-star rated Medicare hospital and a top 100 rural hospital in the United States, patients can expect the highest quality of care where they actively participate in their healthcare planning and goal-setting.
Island Health is a Public Hospital District (Skagit County PHD No. 2) governed by a board of five commissioners whose boundaries include Fidalgo, Cypress, Guemes and Sinclair islands.
Island Health provides an innovative and growing environment for our employees to further their careers, and as a 43-bed hospital we provide a range of services and exceptional quality of care typically found in a larger facility including cancer care: physical, occupational and speech therapy; wound care; sleep wellness; psychiatry and behavioral services; family practice and specialty clinics; and much more.
Located in Anacortes, Washington, a vibrant seaside community focused on wellness, residents enjoy the exceptional quality of life the region offers including excellent schools, abundant recreational activities, and a community for artists.
To experience the culture of Anacortes, please visit: www.anacortes.org.
Island Health is your destination for opportunity and we are always recruiting. Please visit our careers page to learn more about our current positions, www.islandhealth.org/careers.
Specialist, Business Intelligence Data Warehouse
About the role
Job Description In accordance with the Vision, Purpose, and Values, and strategic direction of the Vancouver Island Health Authority (Island Health), patient safety is a priority and a responsibility shared by everyone; as such, the requirement to continuously improve quality and safety is inherent in all aspects of this position.
Reporting to the Manager, Enterprise Data Warehouse, the Specialist, Business Intelligence Data Warehouse develops, manages, and updates data models, including physical and logical models of the data warehouse, data mart, and staging area, and sometimes the operational data store and source systems. The Specialist is a lead resource responsible for the architecture, design, implementation, and operational support of the Business Intelligence databases, data repositories, and related infrastructure.
The Specialist is accountable for the day-to-day data warehouse environment that includes applications, systems, and services that are mission-critical and requires twenty-four hour support. The Specialist plays a key leadership role in the recovery process in the event of critical system outages.
QUALIFICATIONS: Education, Training And Experience A level of education, training and experience equivalent to a Bachelor's Degree in Computer Science and at least five (5) years' recent related experience in areas such as management of data warehouse implementations, performance of MS SQL Server DBA functions including backup and recovery, performance monitoring, performance optimization, disk space utilization, software installation and upgrades, logical and physical data modeling, development of stored procedures, triggers, views, and other database objects, ETL procedures; large scale project management; health care clinical and administrative implementations.
Skills And Abilities
- Effective interpersonal, verbal, and written communication skills.
- Ability to write programs in a variety of programming languages.
- Ability to transfer knowledge and skills to other department staff.
- Ability to provide clear and concise system documentation and procedures for other staff.
- Ability to keep skill set up to date with new technologies as they are introduced to the workplace.
- Data standards, database structures, database server administration.
- Familiarity with HL7, XML, MIS guidelines.
- Strong understanding of Cognos from a development and architecture perspective.
- Ability to work independently and organize workload and priorities with minimal supervision.
- Superior database querying skills including using Structured Query Language.
- Physical ability to perform job.
- Strong conceptual, communications, and technical skills.
- Ability to translate business needs into technical solutions.
- Strong relational and dimensional data modeling and database design skills.
Link To Full Job Description https://jd.viha.ca/JD3414.pdf
About Island Health
Island Health operates primary care clinics in Anacortes and on Orcas Island, and serves patients across three counties (Skagit, Island and San Juan). Our specialty services are extensive and rapidly adapting to meet the needs of our community. At Island Health, our patients are cared for by dedicated medical professionals who live and work in the community. We are a small but mighty health system, renowned for our holistic approach to patient care where our healthcare professionals treat our patients with compassion and respect. As a 5-star rated Medicare hospital and a top 100 rural hospital in the United States, patients can expect the highest quality of care where they actively participate in their healthcare planning and goal-setting.
Island Health is a Public Hospital District (Skagit County PHD No. 2) governed by a board of five commissioners whose boundaries include Fidalgo, Cypress, Guemes and Sinclair islands.
Island Health provides an innovative and growing environment for our employees to further their careers, and as a 43-bed hospital we provide a range of services and exceptional quality of care typically found in a larger facility including cancer care: physical, occupational and speech therapy; wound care; sleep wellness; psychiatry and behavioral services; family practice and specialty clinics; and much more.
Located in Anacortes, Washington, a vibrant seaside community focused on wellness, residents enjoy the exceptional quality of life the region offers including excellent schools, abundant recreational activities, and a community for artists.
To experience the culture of Anacortes, please visit: www.anacortes.org.
Island Health is your destination for opportunity and we are always recruiting. Please visit our careers page to learn more about our current positions, www.islandhealth.org/careers.