Data Warehouse Analyst

Government of Manitoba; Winnipeg; On-site; CAD 80,000 - 106,000; Full time

Job summary

A provincial government office in Winnipeg seeks a Data Warehouse Analyst to lead the modernization of justice data reporting. The role requires post-secondary education in IT and a minimum of 2 years of relevant experience. Responsibilities include improving data reporting processes and mentoring junior analysts. The ideal candidate will have advanced skills in SQL and data analysis, and proficiency in Power BI and Microsoft Office tools. This position offers a salary range of $80,910 to $105,346 per year.

Qualifications

• Minimum 2 years experience in data warehouse development and management.
• Advanced experience with data analysis and data-mining techniques.
• Demonstrated ability to work with large and diverse datasets.

Responsibilities

• Modernize justice data reporting processes.
• Collaborate to implement and sustain effective data warehouse solutions.
• Mentor junior analysts.

Skills

Data analysis

Interpersonal skills

SQL

Project management

Leadership

Education

Post-secondary education in IT, Computer Science, Data Science, Engineering or Mathematics

Tools

Power BI

Azure Data Ecosystem

Microsoft Office (Excel, Word, Outlook, PowerPoint)

Job description

Data Warehouse Analyst

BA3 Business Analyst 3

Regular/full-time

Manitoba Justice

Business Intelligence Unit, Corporate and Strategic Services

Winnipeg MB

Advertisement Number: 44885

Salary(s): BA3 $80,910.00 - $105,346.00 per year

Closing Date: February 22, 2026

The Manitoba government recognizes the importance of building an exemplary public service reflective of the citizens it serves, where diverse abilities, backgrounds, cultures, identities, languages and perspectives drives a high standard of service and innovation. The Manitoba government supports equitable employment practices and promotes representation of designated groups (women, Indigenous people, persons with disabilities, visible minorities).

Employment Equity is a factor in selection for this competition. Consideration will be given to women, Indigenous people and persons with disabilities.

An eligibility list will be established and will remain in effect for 12 months.

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.

CLICK HERE to Access the Application Screening Form

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

Apply Now

Advertisement # 44885

Talent Acquisition

Human Resource Services

600-259 Portage Avenue

Winnipeg, MB, R3B 2A9

Phone: [phone]

Fax: [phone]

Email: [e-mail]

Please indicate the advertisement number and position title in the subject line and/or body of your email when applying. Applicants may request reasonable accommodation related to the materials or activities used throughout the selection process. Your cover letter, resume, and/or application must clearly indicate how you meet the qualifications.

Please be advised that job competitions for represented positions may be grieved by internal represented applicants. Should a selection grievance be filed, information from the competition file will be provided to the grievor's representative. Personal information irrelevant to the grievance and other information protected under legislation will be redacted.

We thank all who apply and advise that only those selected for further consideration will be contacted.