Data Warehouse Analyst

Introduction

The Business Intelligence Unit (BIU) plays a critical role in managing justice related data across Manitoba, aiming to ensure information reported from justice system applications is accurate, consistent, and reliable. BIU supports seamless data sharing among various partners, enabling informed decision making and enhancing transparency across the justice sector. The Data Warehouse Analyst role will be essential in developing, maintaining, and optimizing data reporting systems to support efficient and timely reporting for both internal stakeholders and external agencies.

To be considered for this competition you must submit an Application Screening Form and Resume. Complete the application screening form at the link below or contact Human Resource Services under “Apply to” to request a copy of the application form. The selection board may only rely on information provided in this form to determine whether a candidate will be invited for further assessment. Note: You are not required to submit a cover letter, but may be asked to submit references, or other documentation at a later point if invited for further consideration.

Duties: The Data Warehouse Analyst will play a lead role in modernizing justice related data reporting processes by evaluating, transforming, and maintaining how justice data is acquired, stored, processed, and integrated across platforms. Key responsibilities include collaborating with Manitoba’s Digital and Technology Solutions (DTS) and Justice Information Systems (JIS) to identify, implement, and sustain an effective data warehouse solution for Manitoba Justice. The role will also contribute to the conceptualization of additional reporting solutions, including assessing business intelligence and RPA platforms, dashboards, and reporting structures to meet evolving justice data needs. The Data Warehouse Analyst will be expected to provide mentorship and oversight to junior analysts as required. Qualifications: Essential:

• Post-secondary education in Information Technology, Computer Science, Data Science, Engineering or Mathematics combined with a minimum of 2 years work experience. An equivalent combination of education, training and experience may be considered
• Extensive experience in data warehouse development, management, and administration
• Advanced experience in data analysis and data-mining techniques
• Extensive experience with data warehousing and data analysis tools including SQL, R, Azure Data Ecosystem and Power BI
• Demonstrated ability working with large, complex and diverse datasets, ensuring that data quality and data validation practices are maintained.
• Excellent interpersonal skills with the ability to work collaboratively with internal and external stakeholders
• Strong project management, leadership and problem-solving skills
• Ability to work collaboratively in a team environment
• Ability to demonstrate a high degree of confidentiality
• Excellent verbal communication skills with the ability to communicate contentious issues with tact
• Excellent written communication skills
• Proficiency with Microsoft Office applications especially using Excel, as well as Word, Outlook and PowerPoint

Desired:

• Knowledge of the Justice system and Justice operations
• Knowledge of the existing Justice related systems and data domain
• Knowledge of Power Platform tools (specifically Power Automate, and Power Apps) and/or Robotic Process Automation (RPA) solutions.

Conditions of Employment:

• Must be legally entitled to work in Canada
• Must provide and maintain a satisfactory Criminal Record Check with Vulnerable Sector Search
• Must provide and maintain a satisfactory Adult Abuse Registry Check and Child Abuse Registry Check
• Must provide and maintain a satisfactory Enhanced Internal Security Check - Level 4