FNHA OVERVIEW

About us
The First Nations Health Authority is a diverse and transformational health organization of professional, innovative, and dedicated team members and leaders.
The first of its kind in Canada, FNHA works as a health-and-wellness partner with BC First Nations to support self-determination and decision-making to improve health outcomes.
FNHA is proud to have been named one of BC’s Top Employers for 2025. Learn more about why we were selected here.
The IMIT team is looking for enthusiastic students to join our team. You will be provided opportunities to learn from experienced individuals in this field as well as other IMIT teams. If you are interested to make a career in data warehouse and business intelligence fields, this opportunity is for you!
Title: Business Intelligence & Data Warehouse Student
Salary: $19.87 - $24.66 - $29.43 per year (pay range explained below)
Contract: Term (Anticipated start September to December 2025)
Hours: Casual – 37.5 hours (Mon-Fri 8:30 – 4:30)
Location: Alberni office (Metro Vancouver) location on the ancestral Coast Salish Territories of the Musqueam, Squamish, and Tsleil-Waututh Nations – Hybrid - (Hybrid working is an option in line with FNHA’s flex work policy).

EDUCATION

• Must be currently enrolled in 3rd or 4th year BC post-secondary program in the field of computer science or a related discipline

EXPERIENCE

• Previous work experience in the field considered an asset

KNOWLEDGE

• Solid knowledge of current internet technologies
• Computer skills, MSSQL 2013 (and higher) experience, basic knowledge about Active Directory
• Knowledge of designing and implementing MS SQL Server databases advanced T-SQL and scripting methods
• Knowledge and understanding of BI tools (MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS))
• Thorough knowledge on database design methodologies, functional dependencies, normalization, entity relationship modelling
• Understanding of software development methodologies and lifecycle
• Strong analytical skills, research, writing and communication skills
• Intermediate knowledge about Tableau, and Power BI for visualization purposes
• Basic knowledge on Data Catalogue concept
• Intermediate knowledge of programming languages, such as C#, and Python
• Basic Knowledge of R language to interpret scripts considered a good to have
• Is a team player with a strong customer service orientation and diplomacy while dealing with multiple stakeholders

As the Business Intelligence & Data Warehouse Student, you will build, implement, and maintain ETL’s (extract transform, and load). You will also develop data catalogue categories, tags, and be defined by the team’s lead and manager. As well as you will Identify, document, review and configure BI/DW solutions. Additionally, you will Develop procedures and documentations for user support and service desk reference/support.