Data Warehouse Analyst

Durée de l'emploi: Permanent
- Langue de travail: Anglais
- Heures de travail: 40 hours per week
- Education:

- Expérience:
**Education**:

- Bachelor's degree
**Tasks**:

- Collect data to identify areas for improvement within an organization's IT infrastructure
- Document reporting needs, queries, logic, results and recommendations to other information systems professionals
- Test data models and database management systems
- Operate database management systems to analyze data
- Research and document data requirements, data collection and administration policy, and data access rules
**Computer and technology knowledge**:

- iOS
- Data Warehouse
- MAC
- Dbase Plus
- MS SQL Server
- Data analysis software
- MS Office
- MS Windows
- SQL
**Personal suitability**:

- Accurate
- Efficient interpersonal skills
- Judgement
- Organized
- Team player
**Experience**:

- 1 year to less than 2 years
**Support for newcomers and refugees**:

- Participates in a government or community program or initiative that supports newcomers and/or refugees
- Assists with immediate settlement needs of newcomers and/or refugees (for example: housing, transportation, storage, childcare, winter clothing, etc.)
- Supports social and labour market integration of newcomers and/or refugees (for example: facilitating access to community resources, language training, skills training, etc.)
- Recruits newcomers and/or refugees who were displaced by a conflict or a natural disaster (for example: Ukraine, Afghanistan, etc.)
- Supports newcomers and/or refugees with foreign credential recognition
- Offers mentorship programs that pair newcomers and/or refugees with experienced employees
- Provides diversity and cross-cultural trainings to create a welcoming work environment for newcomers and/or refugees
**Support for Veterans**:

- Participates in a government or community program or initiative that supports Veterans
- Offers mentorship, coaching and/or networking opportunities for Veterans
- Provides awareness training to employees to create a welcoming work environment for Veterans
- Assists with immediate transition needs of Veterans (for example: relocation, housing, etc.)
- Offers workshops, counselling services or other resources to help Veterans navigate their transition into the civilian workforce (for example: adapting to different organizational structures)
- Supports Veterans in translating their military skills and experience into the language of the civilian job market
- Offers flexible onboarding options to allow Veterans to gradually adapt to the civilian workplace (for example: gradually increasing hours and responsibilities, etc.)
**Support for Indigenous people**:

- Participates in a government or community program or initiative that supports Indigenous people
- Offers mentorship, coaching and/or networking opportunities for Indigenous workers
- Develops and maintains relationships with indigenous communities, indigenous-owned businesses and organizations
- Provides cultural competency training and/or awareness training to all employees to create a welcoming work environment for Indigenous workers
- Facilitates access to Elders who can offer support and guidance to Indigenous workers
**Support for mature workers**:

- Participates in a government or community program or initiative that supports mature workers
- Applies hiring policies that discourage age discrimination
- Provides staff with awareness training to create a welcoming work environment for mature workers
- Offers mentorship, coaching and/or networking opportunities for mature workers
- Offers phased retirement options that allow mature workers to gradually reduce their workload (for example: flexible or reduced work hours, part time employment, project-based or seasonal work, etc.)
- Offers phased re-entry options for mature workers who are returning to work after retiring (for example: gradually increasing hours and responsibilities)
- Provides workspace accommodations, such as age-appropriate ergonomic considerations, to meet the physical needs of mature workers (for example: adjustable desks and chairs, accessible parking, etc.)
- Offers resources to help mature workers plan their retirement (for example: financial planning, access to pension and benefits, lifestyle adjustments, etc.)