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.)