Share this Job

Solution Analyst

Date: Aug 5, 2022

Location: Winnipeg, MB, CA, R3C-3P1 Remote - Canada, CA Kitchener, ON, CA, N2G-1H6 Calgary, AB, CA, T2R-0E4 Moncton, New Brunswick, CA, E1E-4R5 Regina, SK, CA, S4S-6X3 Edmonton, AB, CA, T6E-6A8 Saskatoon, SK, CA, S7H-0W5 Ottawa, ON, CA, K2E-7W5 Toronto, ON, CA, M2P-2B7 Vancouver, British Columbia, CA, V6J-4Y3

Company: Wawanesa Insurance


We’re proud to give our employees the flexibility to choose how and where they want to work. In this role, you can decide whether your preference is to work from home (remote), work from the office or a hybrid of time spent at both. You may live in and work in any of the following locations: British Columbia, Alberta, Saskatchewan, Manitoba, Ontario, New Brunswick, Nova Scotia, Prince Edward Island, Newfoundland & Labrador and/or the Yukon.  

The Wawanesa Mutual Insurance Company, founded in 1896, is Canada’s largest mutual insurer, with $3.9 billion in annual revenue and assets of $10.5 billion. Wawanesa Mutual, with executive offices in Winnipeg, is the parent company of Wawanesa General, which offers property and casualty insurance in California and Oregon; Wawanesa Life, which provides life insurance products and services throughout Canada; and Western Financial Group, which distributes personal and business insurance across Western Canada. With more than 5,700 employees, Wawanesa proudly serves more than two million policyholders in Canada and the United States. Wawanesa is thrilled to be named one of Canada’s Best Employers by Forbes for 2022. This certification recognizes us as a leading employer and reinforces that we’re a company that values our people for who they are and the work they do to support our customers, communities, and brokers. Wawanesa is also a Manitoba Top Employer for 2022 recognizing that we are an exceptional place to work. Wawanesa actively gives back to organizations that strengthen communities where it operates, donating well above internationally recognized benchmarks for excellence in corporate philanthropy.

We are currently looking for dedicated, driven, and enthusiastic individuals who thrive in an environment that welcomes change and are looking for an opportunity for diverse experience and advancement on a growing team.


Job Overview

Working under minimal supervision this role, as part of our Data Management team, contributes to Wawanesa success by designing, documenting, testing and supporting our Enterprise Data Warehouse solutions to meet business stakeholder requirements. 
You are someone that will have strong system and business analytical skills within data warehouse, business intelligence, data integration and reporting concepts and principles, preferably with Kimball, and with a strong technical acumen with SQL query writing.  This role will provide timely and accurate information and reports to support business decision making. 
Job Responsibilities

  • Conduct the analysis, design and documentation of both system and business requirements for application/reporting enhancements and projects.
  • Conduct requirement sessions with business and system teams.
  • Communicate system solutions in business and technical terms.
  • Researches and extracts complex data via writing SQL queries and/or using BI reporting tools.
  • Provides input into the development and maintenance of enterprise data warehouse .
  • Collaborate with multiple functional teams to ensure quality software.
  • Create test cases/plans based on requirements documentation and defect resolutions.
  • Lead changes to process and procedure improvements.Identify and resolve both system and business requirement issues.
  • Follow established practices, processes and guidelines.
  • Keep up to date with current system standards and IS departmental established methodologies.
  • Perform other duties as assigned.


  • 3 to 5 years’ experience performing systems or business analysis.
  • Completion of post-secondary degree/certificate or equivalent experience.
  • Experience in data warehouse models, preferably with Kimball, as well as data integrations. 
  • Experience in Data Modeling, Data Profiling, Data Cleansing and Data quality is considered an asset.
  • Practical experience with SQL and Business Intelligence tools such as MicroStrategy, PowerBI, Tableau, or MicroStrategy. 
  • Advanced analysis and problem solving skills with the ability to prioritize a busy workload.
  • Advanced attention to detail skills to produce high quality deliverables that accounts for all areas involved.
  • Experience in AWS technologies such as RedShift, S3, Athena etc. is considered an asset
  • Experience in Cloud migration initiatives would be considered an asset.
  • Excellent communication skills, with the ability to communicate in a clear and concise manner with style fitting for the audience and message.
  • Excellent planning and organizing skills, with the ability to develop and implement plans by prioritizing and multi-tasking.
  • Good leadership skills to provide support and guidance to team members.
  • Proven ability to work collaboratively in a team environment.
  • Demonstrable knowledge in agile practices, scrum, Kanban and continuous delivery.
  • Experience in programming languages is considered an asset.
  • Knowledge and experience in insurance industry is considered an asset.


Wawanesa provides its employees with a respectful, challenging and rewarding environment where they can maximize their potential while contributing to the company’s goals. Our full-time permanent employees are provided with highly competitive compensation packages (salaries, generous vacation allowance, leave top up, annual bonus plan, premium free benefits and a pension plan). Wawanesa provides a stable environment for its employees in today’s challenging markets. 

Wawanesa is an equal opportunity employer and is committed to fostering a diverse workforce that is equitable and inclusive for all. Wawanesa provides equal employment opportunity to all employees and applicants without regard to an individual’s protected status: race/ethnicity, colour, religion, creed, sex or gender, sexual orientation, gender identity or expression, family or marital status, pregnancy/childbirth or related conditions, national origin, disability, military or veteran status, or any other protected status. Accommodations are available upon request throughout all aspects of the selection process. Candidates requiring accommodations may contact, in confidence,

If you are interested in this exciting, challenging position with Wawanesa, apply today with your Resume.

All Wawanesa job applicants are subject to Wawanesa's Privacy Policy.