Share this Job

ETL Developer

Date: Jul 14, 2021

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

Company: Wawanesa Insurance

 

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 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 ETL Application Developer 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. 
  • Collaborating with multiple departments, diagnose, troubleshoot, and resolve incidents supporting Data Management applications.
  • Monitoring of production workflows and processes. 
  • Provide support for monthly server/application patches, application and infrastructure upgrades
  • Provide periodic on-call ETL support to Enterprise Data Warehouse.
  • Deployment of ETL Code packages to Stage and Production environments.
  • Participate in code reviews and release planning sessions 
  • 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. 

Qualifications

  • 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, Linux, 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. 
  • Proven ability to work collaboratively within a team environment.
  • Experience with other ETL tools such as AWS Glue 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 of cloud computing concepts and infrastructure, specifically with AWS tools like Redshift, Athena, Aurora PostgreSQL or GLUE is considered an asset.
  • Experience with Business Intelligence tools and software like MicroStrategy or Power BI 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 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. We’re also proud to give our employees in Canada the flexibility to choose how and where they want to work. Options in most roles include work from the office, from home, or a hybrid mix of time spent at both.
 

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, jobs@wawanesa.com.


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