Student, Co Op

**FNHA Overview**:
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.

**JOIN OUR HISTORIC JOURNEY**
At FNHA, you’ll have the opportunity to contribute to BC’s history. With a unique governing structure and mandate, our fluid work environment means you can play an active role in real change.
Our talented teams value respect and foster lateral kindness in their working relationships. Our holistic approach to wellness, based on First Nations teachings, is incorporated into all aspects of work culture. Where else will you get to create a personal wellness plan as part of your performance goals?

**Position Summary**:
The Student will focus on the Business Intelligence and Data Warehouse.
- Build, implement, and maintain ETL’s (extract, transformation, and load) under the BI /DW Senior Lead’s supervision
- Develop data catalog categories, tags, others
- as required and defined by the team’s lead and manager.

**As a health and wellness organization, the First Nations Health Authority has aligned with the Provincial Public Health Order released on October 14, 2021. We have a mandatory COVID-19 vaccination policy for all employees at First Nations Health Authority. This policy requires all employees to be fully vaccinated against COVID-19. If selected for employment, you will be required to provide proof of vaccination by providing a copy of your BC Vaccination Card Passport with the QR code.**

**Responsibilities**:

- Gather requirements from the users on the Business Intelligence and Data Warehouse (BI/DW)team
- Gather requirements from the business users on the design and layout for the reports and dashboards
- Identify, document, review and configure BI/DW solutions under Senior Lead, BI /DW supervision to address the business needs.
- Develop procedures and documentations for user support and service desk reference/support.
- Collaboration with BI/DW team on different related activities

**Qualifications**:

- Must be currently enrolled in 3rd or 4th year post-secondary program in the field of computer science or a related discipline
- Previous work experience in the field considered an asset

**Knowledge, Skills & Attributes**:

- 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 modeling
- 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 as a good to have
- Is a team player with a strong customer service orientation and diplomacy while dealing with multiple stakeholders

**Closing Statement**:
**Diversity**

The First Nations Health Authority is committed to respecting diversity within our workforce; preference will be given to individuals with Indigenous ancestry (First Nations, Inuit, Métis).

**What You Can Expect From Us**

Joining our family means joining an organization that supports personal growth, in-house training, a paid volunteer day and a unique full-day orientation program.

Leading with culture, all FNHA employees complete San’yas Indigenous Cultural Safety Training. We support our family to be leaders in wellness and all staff members develop a yearly wellness plan as part of their performance partnership and goal-setting.

**Closing**

Please note that only those applicants shortlisted will be contacted. If you do not hear from us about this position, please accept our sincere appreciation for your interest in FNHA