data warehouse analyst

• Work Term : Permanent
• Work Language : English
• Hours : 40 hours per week
• Education : Bachelor's degree
• Experience : 1 year to less than 2 years

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
• Setup the IT infrastructure to allow applications to access databases
• 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

• Data Warehouse
• Dbase Plus
• MS SQL Server
• Data analysis software
• MS Office
• MS Windows

Personal suitability

• Accurate
• Efficient interpersonal skills
• Judgement
• Organized
• Team player

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
• Recruits Veterans and other candidates with military experience through targeted hiring initiatives (for example : job fairs, outreach programs etc.)
• 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.)
6 days ago