Data Warehouse Programmer

Overview:

Reporting to the Supervisor, Data Warehouse, the Data Warehouse Programmer develops and maintains data warehouses and/or analytic reporting solutions. The position works closely with business users to meet query and/or report requests. As a member of a project team, the Programmer produces deliverables specific to the development phase.

The Data Warehouse Programmer must complete the Programmer Training over a maximum 24-month period to progress to the Programmer/Analyst classification.

Responsibilities:

• Develop and maintain reports, dashboards and analytics, in accordance with established criteria and standards, using provided design, customer requirements and documents.
• Develop SQL queries.
• Assist with SQL queries, reports and dashboards review and testing processes.
• Assist with preparing operational documentation for systems users and support teams.
• Prepare documentation according to established departmental and divisional standards.
• Contribute to team effort by accomplishing assigned tasks.
• Coordinate change and implementation activities in accordance with established criteria and standards.
• Create program design specifications in accordance with established criteria and standards.
• Ensure data integrity, consistency, and adherence to data standards.
• Participate in and conduct peer code reviews to ensure adherence to coding standards, design patterns, and data governance practices.
• Collaborate with Programmer/Analyst and Analyst in design process for new report and dashboard requests.
• Implement and document reports and dashboards.
• Create conceptual design documents for enhancements and work items.
• Attend training courses as required.
• Perform other duties as required.

Qualifications:

Education:

• Diploma in Computer Science, Information Systems, Data Analytics or related field. Data warehouse related certificates are an asset.

Technical Knowledge and Skills:

• Knowledge of the insurance domain is an asset, including concepts such as:
  o Policies, premiums, claims, underwriting, billing, or actuarial data.
  o Regulatory or compliance-driven reporting.
• Strong proficiency in SQL and relational database concepts.
• Knowledge of Data Warehousing concepts.
• Understanding of ETL/ELT processes and data lifecycle management.
• Experience with cloud data platforms (e.g., MS Fabric, or similar) is an asset.
• Experience working across development, test, and production environments.
• Experience in Agile / Scrum delivery environments.
• Experience using Azure DevOps for source control, work tracking, and CI/CD pipeline, or similar.
• Knowledge of data quality, data governance, or metadata management practices.
  Experience participating in or leading peer review processes (e.g., pull requests, design reviews).
• Uses or learns Business Intelligence tools e.g. Business Objects, Power BI, Report Builder etc.
• Establishes and maintains effective relationships and communications with supervisors, employees and internal customers.
• Communicates effectively, orally and in writing to convey technical information in a clear, concise and understandable manner for both technical and non-technical audiences.

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
• 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
• maternity, parental and adoptive leaves
• bereavement and family responsibility leaves
• employee and family assistance program
• mental-health programming
• onsite employee gym facility (Cityplace)
• discounted gym memberships
• 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.