Job Description

As a Data Warehouse Developer with Vancouver Coastal Health you will:

• Be a part of the Data Management and Reporting technical team with a primary focus on the ongoing sustainment and development of the organisation\xe2\x80\x99s on-premises data infrastructure.
• Design and develop scalable, efficient, data integration solutions for large scale data analyses, model development, validation and implementation
• Collaborate with a variety of cross-functional team members to identify, develop, implement and maintain innovative solutions for the information needs of Vancouver Coastal Health.
• Apply experience in data modelling, data warehousing, building data pipelines, and excellent problem solving ability to tackle processing of high volumes of clinical data.

Qualifications

Education & Experience

• Master\xe2\x80\x99s degree in Business Administration, Information Systems or equivalent plus three years experience in Information, Utilization Management and Quality Management or equivalent industry/certification experience
• Three (3) years experience in Information Technology with focus in database development and warehousing

Knowledge & Abilities

• Strong skills and experience in MS SQL Server, SSIS, SSRS, SSAS, and T-SQL
• Preferred experience with data virtualisation tools (e.g. Denodo)
• Demonstrated experience building and optimizing data pipelines (ETL)
• Experience working in an Agile environment
• Advanced analytical and problem solving skills.
• Excellent writing and verbal communication skills.
• Knowledge of database design and report design at the intermediate to advanced level.
• Knowledge of healthcare databases an asset.
• Knowledge using cloud data warehousing solutions (e.g. Azure SQL, Synapse Analytics, Databricks, etc.) an asset
• Knowledge of Azure or other cloud infrastructure services (e.g Azure Data Factory, Azure DevOps) an asset
• Proficiency coding in Python, Scala, R, Java, or other language an asset

Closing Statement

As per the current Public Health Orders (Long Term Care/Seniors Assisted Living Provincial Health Officer Order and the Health Sector Order), as of October 26, 2021, all employees working for Vancouver Coastal Health must be fully vaccinated for COVID-19. Proof of vaccination status will be required.

Why Join Vancouver Coastal Health (VCH):

VCH is a world class innovator in medical care, research and teaching, delivering service to more than one million BC residents. At VCH, we embrace thinking boldly, taking smart risks, and \'going first\' when we believe it will lead to the best possible outcomes for patients and their families. We invite you to join us in creating healthy lives in healthy communities by showcasing our passion for care, connection to the communities we serve and our culture of teamwork that makes VCH a great place to work.

• Comprehensive health benefits package, including MSP, extended health and dental and municipal pension plan
• Grow your career with employer-paid training and leadership development opportunities
• Wellness supports, including counselling, critical incident and innovative wellness services are available to employees and their immediate families
• Award-winning recognition programs to honour staff, medical staff and volunteers
• Access to exclusive discount offers and deals for VCH staff

Diversity, equity, and inclusion are essential to our goals of creating a great place to work and delivering exceptional care. We acknowledge and accommodate unique differences and ensure special measures are in place so that all prospective and current employees are given an opportunity to succeed.

We are committed to building a representative workforce and encourage applications reflecting diversity of sex, sexual orientation, gender identity or expression, racialization or ancestry, disability, political belief, religion, marital or family status, age, and/or status as a First Nation, Metis, Inuit, or Indigenous person.

Vancouver Coastal Health is proud to be recognized as one of Canada\'s Top 100 Employers in 2023.

Only short-listed applicants will be contacted for this posting.

***Employees of VCH must apply online via the Internal Career Portal on CareerHub, you are currently viewing the External Career Portal. Refer to the https://my.vch.ca/working-here/job-postings site for instructions on how to view internal job postings and how to apply as an employee. Current VCH employees who apply to this posting using this external site will be considered as an external candidate. Seniority will not apply.***

Thank you for your interest in Vancouver Coastal Health.

Vancouver Coastal Health