Supervisor, Data Warehouse

Manitoba Public Insurance; Winnipeg; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading company in Manitoba is seeking a Supervisor for their Data Warehouse team. The role involves managing data, leading projects, and collaborating with IT and business clients to solve complex problems. The ideal candidate will have significant experience in data warehouse analysis and SQL programming, along with strong leadership skills. The position offers a comprehensive benefits package and opportunities for professional development.

Benefits

Health benefits

Registered pension plan

Flexible work program

Employee and family assistance program

Discounted gym memberships

Qualifications

• Six years of related experience in data warehouse analysis, design and implementation.
• Two years project planning and/or leadership capacity.

Responsibilities

• Leads and conducts design and development of business information requirements.
• Serves as a point of contact for IT staff on data warehouse issues.
• Develops project estimates, system designs, and documentation.

Skills

SQL Programming

Education

Diploma in Computer Science

Diploma in Business Analysis

Tools

SAP Business Objects Designer

Job description

Overview

Reporting to the Manager, Data Science & Operations, the Supervisor, Data Warehouse works with Information & Technology (IT) and business clients to analyze and develop solutions for complex business problems. The Supervisor leads projects or is a team leader on larger, more significant, Business Analytic Environment (BAE) tasks.

The Supervisor, Data Warehouse is responsible for managing data in the corporation’s Data Warehouses and Data Lakes. The Supervisor identifies how and where it exists, plans for its use, provides control mechanisms for its protection, assures its correctness and relevance, and manages the data collection and warehouse update process.

Responsibilities

• Participates in Business Analytics architecture development, as required.
• Leads and/or conducts the design and development of business information requirements to deliver stable data structures.
• Inventories data by gathering facts about the characteristics, quantity and location of organizational data and manages these facts.
• Supports the transition of high level data architecture into Enterprise Data Warehouse (EDW) specific physical database design.
• Provides guidance and assists with developing standard methods of data access and manipulation/usage.
• Resolves usage interpretation and meaning of data.
• Serves as a point of contact for IT staff and MPI business units on data warehouse issues and query/report requests.
• Promotes joint sponsorship, custodianship and sharing of data across the organization.
• Researches existing and new data analysis tools, techniques and methodologies, and trains others.
• As a member or leader of a project team, may be required to:
  • Analyze problems or faults, determine effort required to resolve, and assign staff to the resolution
  • Develop procedures for implementation.
• Analyzes current systems through review of documentation and interviews with IT and Business Analytics clients.
• Follows and is compliant with MPI policies and procedures and the Freedom of Information and Protection of Privacy Act.
• Prepares or assists with developing business cases, requirements definitions, conceptual design documents, and Source-to-Target Matrixes related to the data warehouses.
• Develops project estimates, system designs, implementation designs, system and program specifications, and system and client documentation.
• Defines and maintains reports and warehousing testing requirements.
• Troubleshoots and supports Business Analytics data warehouses/stores.
• Leads teams in the development of new data warehouse/stores and enhancements to existing data warehouse/stores.
• Provides both technical and general direction to project staff members.
• Assists in evaluation of the performance of assigned staff.

Qualifications

Education:

• Diploma in Computer Science, Computer Programming, Business Analysis, or related discipline.
• Supplementary courses in data warehousing tools and techniques is an asset.

Experience:

• Six years of related experience in data warehouse analysis, design and implementation or implementation, including;
• SQL Programming.

• Two years project planning and/or leadership capacity.
• Management and maintenance of Business Objects reporting, and designing Universes using SAP Business Objects Designer is an asset.
• Experience in an insurance, finance or technology environment is an asset.

Employee Benefits

Health benefits

We offer a comprehensive health benefits program that includes:

• flexible health, dental and vision plans
• health spending account
• travel health coverage
• other extended health benefits such as ambulance, massage and physiotherapy

Financial security

In an effort to support financial security, we offer:

• registered pension plan
• group, dependent, and optional life insurance coverage
• critical illness insurance
• sick leave to cover short-term disability
• long-term disability

Wellness

We offer programs that focus on how to better achieve a balance between work and personal commitments, as well as maintain a healthy workplace culture. This includes:

• vacation entitlement
• flexible work program
• maternity, parental and adoptive leaves
• bereavement and family responsibility leaves
• employee and family assistance program
• mental-health programming
• lunch-and-learn offerings
• discounted gym memberships and wellness account

Diversity and inclusion

Manitoba Public Insurance believes that diversity and inclusion strengthens us. We consider ourselves to be a barrier-free organization where individual values, beliefs and practices are respected and appreciated for the diversity they bring to our work life.

Employee recognition

It’s important to recognize our employees for their contributions. Not only do we recognize employees as they achieve milestone years in their careers, we also have several outlets for leaders and peers to reward each other for work well done.

Professional development

We want our employees to grow, which is why we offer support in keeping their skills up-to-date. We offer in-house training, professional development and an educational assistance program.

Safety and health

In an effort to encourage a safe and healthy work environment, we offer various safety, health and workplace policies and programs along with technical expertise and assistance to support employee activities in safety and health.