New job at Wawanesa Insurance (via |

ETL Application Developer - Ii or Senior

May 19 2020
Industries Bank, Insurance, Financial services
Categories Information Technology, Programming, Development
Winnipeg, MB

Wawanesa Mutual Insurance is one of the largest property and casualty insurers in Canada with $3 billion in annual revenues and assets of more than $9 billion. Wawanesa Mutual, founded in 1896 with executive offices in Winnipeg, is the parent company of Wawanesa General, which offers property and casualty insurance in California and Oregon, and Wawanesa Life, which distributes life insurance products and services throughout Canada. With over 3,500 employees, Wawanesa proudly serves over two million policyholders through nine regional offices and 41 service offices in Canada and the United States. 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, advancement on a growing team.

Job Overview

Working under general supervision, we are seeking an intermediate to Senior ETL Application Developer (II or Senior) and will contributes to Wawanesa success by building, maintaining and supporting business systems and applications. This role will primarily be responsible for the Extract, Transform, and Load (ETL) services offered by the Data Management team, encompassing both software maintenance and development assignments, and more.

Job Responsibilities:

  • Design, develop, and test software and processes to implement schema and/or data quality changes to the Enterprise Data Warehouse.
  • Maintain processes that load the legacy operational data store.
  • Maintain the operation of business systems, applications, and processes that support third party reporting.
  • Diagnose, troubleshoot, and resolve application incidents that support third party reporting.
  • Provide periodic on-call ETL support to Enterprise Data Warehouse.
  • Estimate and track progress of assigned work.
  • Create and update relevant documentation.
  • Follow established practices, processes, and guidelines.
  • Keep current with relevant technologies.
  • Perform other duties as assigned.
  • Completion of Post-secondary degree or diploma in software development or equivalent experience, or combination of education and experience.
  • 3 to 5 years experience with Windows, UNIX, relational databases (Oracle, SQL Server), Structured Query Language (SQL), Oracle PL/SQL, Java, and Microsoft Office Products.
  • Working experience with Informatica ETL tools
  • Knowledge of Software Development Lifecycle and Data Warehousing concepts.
  • Detail oriented with analytical and problem-solving skills to recognize and identify issues and take proper action to resolve them.
  • Effective communication skills, both verbal and written, for creation of reports and support.
  • Effective organizational skills with the ability to self-manage a fluctuating workload, with various situations and changing priorities.
  • Experience with other ETL tools such as IBM DataStage and Microsoft SSIS is considered an asset.
  • Experience using software development tools, such as JIRA, Confluence, Source Code Management and TeamCity is considered an asset.
  • Experience with software development languages such as Python, Java, and Jenkins is considered an asset.
  • Experience with Continuous Integration (CI) processes and technologies such as Jenkins is considered an asset.
  • Knowledge and experience in the Insurance Industry and Guidewire Insurance Suite 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 employees are provided with highly competitive compensation packages (salaries, generous vacation allowance, leave top up, goal achievement plan, premium free benefits and a pension plan). Wawanesa provides a stable and rewarding environment for its employees in today’s challenging markets.

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

Accommodations are available as needed for all applicants.

Apply now!