Supervisor, Data Warehouse (12-month Term) Job at Manitoba Public Insurance, Canada

Z2N3OXFBQThrc1FPZ0dmRTVpc0Q1dTczUWc9PQ==
  • Manitoba Public Insurance
  • Canada

Job Description

Job Description

Supervisor, Data Warehouse

Reporting to : Manager, Data Science & Operations

Position Type : This is a 12-month term position.

Overview :

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.

Job Tags

Temporary work, Flexible hours,

Similar Jobs

Jobot

Tax Manager or Staff accountant - public Job at Jobot

 ...00 - $160,000 per year A bit about us: We are a small public accounting firm with large clients. We've been in business for nearly...  ...based on any of these protected categories. It is Jobots policy to comply with all applicable federal, state and local laws respecting... 

Check-Mate Industries

1st shift- Part-time Worker- (Shifts: 10-2 M-F or 7-3:30 T,W,TH)- 15.00 hourly Job at Check-Mate Industries

 ...Job Description Job Description Part-time Assembly, Resize, Fabrication and Finishing...  ...can choose the following shifts: ~20 hours per week ~ Monday through Friday (10:00...  ...Thursday (7:00 a.m. 3:30 p.m.) Pay: ~$15.00/hour (paid weekly) EOE/AA/M/F/ET/D... 

Lensa

Staff Embedded Software Audio Engineer Job at Lensa

Ford Model E Platform Architecture Engineering is looking for a Staff embedded software engineer to work on Audio DSP platform software. In this role you will be responsible for the development of automotive software solutions and embedded software modules for electric... 

My Derm Recruiter

Medical Assistant or Scribe Job at My Derm Recruiter

 ...Medical Assistant Or Scribe Opportunity Come join our team! We have an immediate need for a Medical Assistant or Scribe in our O'Fallon, IL clinic! If you are ready to make an impact every day, and thrive in a fast-paced environment, then a career at Forefront may be... 

ConGlobal

Intermodal Equipment Operator Job at ConGlobal

Overview: Launch Your Career with ConGlobal ConGlobal is hiring immediately for a key role in our global supply chain operations.Whether youre looking to grow your career or gain new skills, this role offers paid training , competitive pay , excellent benefits...