Data Warehouse Analyst

Data Warehouse Analyst

BA3 Business Analyst 3

Regular/full-time

Manitoba Justice

Business Intelligence Unit, Corporate and Strategic Services

Winnipeg MB

Advertisement Number: 43001

Salary(s): BA3 $78,546.00 - $102,282.00 per year

Closing Date: July 14, 2024

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 Indigenous people and persons with disabilities.

An eligibility list may be created for similar positions and will remain in effect for 12 months.

Candidates who do not meet all essential criteria may be considered on an underfill basis at a commensurate rate of pay.

Collaborating closely with internal and external partners, the Business Intelligence Unit (BIU) aims to deliver valuable insights, develop data-driven solutions, and inform strategic planning. These initiatives optimize departmental decision-making by leveraging comprehensive analysis and informed perspectives.

To be considered for this competition you must submit an application form and resume. NOTE: Only those who provide the application formand resume will be considered. See below for further instructions.

Click here to access the application form.

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

Qualifications:
Essential:

• Post-secondary education in Information Technology, Engineering or Mathematics. An equivalent combination of education, training and experience may be considered
• Extensive experience in data warehouse development, management, and administration
• Experience in data warehouse concepts, methodologies, and architecture (i.e.: dimensional modeling, star schema, data vault)
• Extensive experience with data warehousing tools (i.e.: SQL Reporting Server, Power BI, ETL, etc.)
• 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 (Word, Excel, Outlook and PowerPoint)

Desired:

• Knowledge of the Justice system and Justice operations
• Knowledge of the existing Justice related systems and data domain

Duties:
This position will have lead responsibility for the modernization of the way that the BIU acquires, stores, processes, and integrates data. Primary responsibilities will include working with Manitoba’s central Digital and Technology Solutions (DTS) group and Justice IT to determine the best approach for data to be staged to the BIU, and the design and implementation of the technology and infrastructure necessary for this. The position will also have a primary responsibility for the design and development of a data warehouse that will aggregate data from various sources to support fast and efficient data analysis and reporting by the BIU. The position will also support the implementation of the Courts Modernization Project and on-going reporting requirements within the Department of Justice.

Apply to:

Applicants may request reasonable accommodation related to the materials or activities used throughout the selection process. When applying to this position, please indicate the advertisement number and position title in the subject line and/or body of your email. Your cover letter, resumé 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.