Individually we are people, but together we are Aviva. Individually these are just words, but together they are our Values – Care, Commitment, Community, and Confidence.

We are seeking a dedicated ETL Developer / Finance Systems Data Engineer with solid experience in the insurance industry and expertise in ETL and PostgreSQL development to join our dynamic team.

If you would like to be part of a leading company in the insurance industry, dedicated to providing top-notch financial solutions, then come join our team!

What you'll do:

• Design, develop, and maintain ETL(Informatica Power Center) processes to extract, transform, and load data from various sources into our finance systems.

• Develop and optimize complex SQL queries and stored procedures in PostgreSQL.

• Monitor daily/monthly jobs and resolve failures (if any)

• Collaborate with finance and insurance teams to understand data requirements and ensure data integrity and accuracy.

• Build Qlik reports.

• Perform data analysis and solve data-related issues.

• Implement data quality checks and validation processes.

• Provide solutions by building complexed Finance calculations using Postgres store procedure or ETL.

• Monitor and improve the performance of ETL processes and database systems.

• Document technical specifications and maintain comprehensive documentation of ETL processes and database schemas.

• Stay up to date with the latest industry trends and best practices in ETL and database management.

What you'll bring:

• Experience in the insurance industry & able to understand underwriting data terminology.

• Experience in supporting finance systems.

• Demonstrable experience as an ETL Developer (Informatica PowerCenter and Informatica BDM)

• Experience as a PostgreSQL Developer.

• Proven experience as Database Developer, hands on experience in writing DDLS and DMLS for relational databases

• Experience in writing complex SQL queries for Adhoc reporting.

• Expertise in ETL tools (especially Informatica) and PostgreSQL.

• Strong expertise in Postgres and database design.

• Knowledge of data warehousing concepts and best practices.

• Experience on automation tools like Control-M, ASG ZENA Experience in writing Unix scripts.

• Experience in Qlik & Python reporting. (Nice to have).

• Experience with Snowflake. (Nice to have).

• Excellent problem-solving skills and attention to detail.

• Experience in Agile methodology & JIRA.

• Good communication and collaboration skills.

• Ability to work both independently and as part of a team.

• Bachelor’s degree in computer science, Information Technology, or a related field preferred, but equivalent experience will also be considered.

• Experience with database systems (e.g., Oracle, Postgres, MySQL). SQL Associate Certification an asset.

• Knowledge of data visualization tools (e.g., Qlik, Python, Power BI) an asset.

What you’ll get

• The salary band for this position ranges from $75,000 to $110,000. Please note that individual salary is determined by factors such as job-related knowledge, skills and experience, as well as internal equity.

• Compelling rewards package including base compensation, eligibility for annual bonus, retirement savings, share plan, health benefits, personal wellness, and volunteer opportunities.

• Outstanding Career Development opportunities.

• We’ll support your professional development education.

• Competitive vacation package with the option to purchase 5 extra days off per year.

• Employee driven programs focused on gender, LGBTQ+, origins, diversity, and inclusion.

• Corporate wellness programs to support our employees’ physical and mental health.

• Hybrid flexible work model.

This job advertisement is for an existing vacancy which has been posted both internally & externally.

Aviva Canada may use AI (Artificial Intelligence) tools to assist us throughout the recruitment process to screen, assess or select applicants for a position.

Aviva Canada welcomes applications from all qualified individuals and has a process in place to provide accommodations for persons with disabilities at all stages of the hiring process and during employment. If you require an accommodation during the interview or hiring process, please contact your Aviva Talent Acquisition Partner so that an appropriate accommodation can be arranged.

#LI-PS1
#LI-Hybrid