Finance Systems Data Engineer Associate

1 month ago

Markham, Ontario, Canada Aviva Full time
Job Title: Finance Systems Data Engineer Associate

We are seeking a highly skilled Finance Systems Data Engineer Associate to join our dynamic team at Aviva. As a key member of our team, you will be responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into our finance systems.

Key Responsibilities:
  1. Design and develop ETL processes to extract, transform, and load data from various sources into our finance systems.
  2. Develop and optimize complex SQL queries and stored procedures in PostgreSQL.
  3. Monitor daily/monthly jobs and resolve failures (if any).
  4. Collaborate with finance and insurance teams to understand data requirements and ensure data integrity and accuracy.
  5. Build Qlik reports.
  6. Perform data analysis and solve data-related issues.
  7. Implement data quality checks and validation processes.
  8. Provide solutions by building complex Finance calculations using Postgres store procedure or ETL.
  9. Monitor and improve the performance of ETL processes and database systems.
  10. Document technical specifications and maintain comprehensive documentation of ETL processes and database schemas.
  11. Stay up to date with the latest industry trends and best practices in ETL and database management.
Requirements:
  1. Experience in the insurance industry & able to understand underwriting data terminology.
  2. Experience in supporting finance systems.
  3. Knowledge in Oracle Fusion applications including sub-modules such as accounts payable, Cash management & fixed assets.
  4. Demonstrable experience as an ETL Developer (Informatica PowerCenter and Informatica BDM).
  5. Experience as a PostgreSQL Developer.
  6. Experience in Guidewire Policy, Billing & Claims Centers.
  7. Experience on automation tools like Control-M, ASG ZENA Experience in writing Unix scripts.
  8. Experience in Qlik & Python reporting.
  9. Experience with Snowflake.
  10. Solid understanding of accounting principles (Balance sheet/P&L concepts).
  11. Expertise in ETL tools (especially Informatica) and PostgreSQL.
  12. Strong expertise in Postgres and database design.
  13. Knowledge of data warehousing concepts and best practices.
  14. Excellent problem-solving skills and attention to detail.
  15. Experience in Agile methodology & JIRA.
  16. Above average communication and collaboration skills.
  17. Ability to work both independently and as part of a team.
  18. Bachelor's degree in computer science, Information Technology, or a related field an asset.
  19. Informatica Certified Professional (ICP) and/or Informatica Foundation Level Certifications (IDMC, CDCG, MDM etc.) preferred.
  20. Experience with database systems (e.g., Oracle, Postgres, MySQL). SQL Associate Certification an asset.
  21. Guidewire professional certifications an asset.
  22. Familiarity with cloud-based data solutions (e.g., AWS, Snowflake) preferred.
  23. Knowledge of data visualization tools (e.g., Qlik, Python, Power BI) an asset.
What We Offer:
  1. A competitive salary band ranging from $71,300 to $132,300.
  2. A compelling rewards package including base compensation, eligibility for annual bonus, retirement savings, share plan, health benefits, personal wellness, and volunteer opportunities.
  3. Outstanding Career Development opportunities.
  4. We'll support your professional development education.
  5. A competitive vacation package with the option to purchase 5 extra days off per year.
  6. Employee-driven programs focused on gender, LGBTQ+, origins, diversity, and inclusion.
  7. Corporate wellness programs to support our employees' physical and mental health.
  8. A hybrid flexible work model.

  • Finance Systems Data Engineer Associate

    1 month ago

    Markham, Ontario, Canada Aviva Full time $71,300 - $132,300

    Job Title: Finance Systems Data Engineer AssociateWe are seeking a highly skilled Finance Systems Data Engineer Associate to join our dynamic team. As a key member of our team, you will be responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into our finance systems.Key...

  • Finance Systems Data Engineer Associate

    1 month ago

    Markham, Ontario, Canada Aviva Full time $71,300 - $132,300

    Job Title: Finance Systems Data Engineer AssociateWe are seeking a highly skilled Finance Systems Data Engineer Associate to join our dynamic team. As a key member of our team, you will be responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into our finance systems.Key...

  • Finance Systems Data Engineer Associate

    1 month ago

    Markham, Ontario, Canada Aviva Full time

    Job Title: Finance Systems Data Engineer AssociateWe are seeking a skilled Finance Systems Data Engineer Associate to join our dynamic team at Aviva. As a key member of our team, you will be responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into our finance systems.Key...

  • Finance Systems Data Engineer Associate

    1 month ago

    Markham, Ontario, Canada Aviva Full time

    Job Title: Finance Systems Data Engineer AssociateWe are seeking a skilled Finance Systems Data Engineer Associate to join our dynamic team at Aviva. As a key member of our team, you will be responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into our finance systems.Key...

  • Finance Systems Data Engineer Associate

    1 month ago

    Markham, Ontario, Canada Aviva Full time

    Job Title: Finance Systems Data Engineer AssociateWe are seeking a highly skilled Finance Systems Data Engineer Associate to join our dynamic team. As a key member of our finance team, you will be responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into our finance systems.Key...

  • Finance Systems Data Engineer Associate

    1 month ago

    Markham, Ontario, Canada Aviva Full time

    Job Title: Finance Systems Data Engineer AssociateWe are seeking a highly skilled Finance Systems Data Engineer Associate to join our dynamic team. As a key member of our finance team, you will be responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into our finance systems.Key...

  • Finance Systems Data Engineer Associate

    1 month ago

    Markham, Ontario, Canada Aviva Full time $71,300 - $132,300

    Finance Systems Data EngineerWe are seeking a dedicated Finance Systems Data Engineer with solid experience in the insurance industry and expertise in ETL and PostgreSQL development to join our dynamic team.Key Responsibilities:Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into our finance...

  • Finance Systems Data Engineer Associate

    1 month ago

    Markham, Ontario, Canada Aviva Full time $71,300 - $132,300

    Finance Systems Data EngineerWe are seeking a dedicated Finance Systems Data Engineer with solid experience in the insurance industry and expertise in ETL and PostgreSQL development to join our dynamic team.Key Responsibilities:Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into our finance...

  • Finance Systems Data Engineer Associate

    1 month ago

    Markham, Ontario, Canada Aviva Full time

    Job Title: Finance Systems Data Engineer AssociateWe are seeking a dedicated Finance Systems Data Engineer with solid experience in the insurance industry and expertise in ETL and PostgreSQL development to join our dynamic team.Key Responsibilities:Design and Develop ETL Processes: Design, develop, and maintain ETL processes to extract, transform, and load...

  • Finance Systems Data Engineer Associate

    1 month ago

    Markham, Ontario, Canada Aviva Full time

    Job Title: Finance Systems Data Engineer AssociateWe are seeking a dedicated Finance Systems Data Engineer with solid experience in the insurance industry and expertise in ETL and PostgreSQL development to join our dynamic team.Key Responsibilities:Design and Develop ETL Processes: Design, develop, and maintain ETL processes to extract, transform, and load...

  • Data Engineer

    4 weeks ago

    Markham, Ontario, Canada Recrute Action Full time

    Job Title: Data Engineer - Finance SystemsRecruit Action is seeking a highly skilled Data Engineer to join our team. As a Data Engineer, you will be responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from diverse sources into finance systems.Responsibilities:Design and develop ETL processes to extract,...

  • Data Engineer

    4 weeks ago

    Markham, Ontario, Canada Recrute Action Full time

    Job Title: Data Engineer - Finance SystemsRecruit Action is seeking a highly skilled Data Engineer to join our team. As a Data Engineer, you will be responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from diverse sources into finance systems.Responsibilities:Design and develop ETL processes to extract,...

  • Finance Systems Data Engineer Associate

    1 month ago

    Markham, Ontario, Canada Aviva Full time $71,300 - $132,300

    Finance Systems Data EngineerWe are seeking a dedicated Finance Systems Data Engineer with solid experience in the insurance industry and expertise in ETL and PostgreSQL development to join our dynamic team.Key Responsibilities:Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into our finance...

  • Finance Systems Data Engineer Associate

    1 month ago

    Markham, Ontario, Canada Aviva Full time $71,300 - $132,300

    Finance Systems Data EngineerWe are seeking a dedicated Finance Systems Data Engineer with solid experience in the insurance industry and expertise in ETL and PostgreSQL development to join our dynamic team.Key Responsibilities:Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into our finance...

  • Data Engineer

    3 weeks ago

    Markham, Ontario, Canada Recrute Action Full time

    Job Title: Data Engineer (Finance Systems)We are seeking a highly skilled Data Engineer to join our team at Recruit Action. As a Data Engineer, you will be responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from diverse sources into finance systems.Key Responsibilities:Design and develop ETL processes...

  • Finance Systems Data Engineer Associate

    1 month ago

    Markham, Ontario, Canada Aviva Full time

    At Aviva, we're seeking a talented Finance Systems Data Engineer to join our dynamic team. As a key member of our finance team, you'll play a crucial role in designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into our finance systems.Key Responsibilities:Design and develop ETL processes to extract,...

  • Finance Systems Data Engineer Associate

    1 month ago

    Markham, Ontario, Canada Aviva Full time

    At Aviva, we're seeking a talented Finance Systems Data Engineer to join our dynamic team. As a key member of our finance team, you'll play a crucial role in designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into our finance systems.Key Responsibilities:Design and develop ETL processes to extract,...

  • Finance Systems Data Engineer Associate

    3 weeks ago

    Markham, Ontario, Canada Aviva Full time

    At Aviva, we're looking for a talented Finance Systems Data Engineer to join our dynamic team. As a key member of our finance team, you'll play a crucial role in designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into our finance systems.Key Responsibilities:Design and develop ETL processes to...

  • Finance Systems Data Engineer Associate

    2 months ago

    Markham, Ontario, Canada Aviva Full time

    About the RoleWe are seeking a dedicated Finance Systems Data Engineer with solid experience in the insurance industry and expertise in ETL and PostgreSQL development to join our dynamic team at Aviva.Key ResponsibilitiesDesign, develop, and maintain ETL processes to extract, transform, and load data from various sources into our finance systems.Develop and...

  • Finance Systems Data Engineer Associate

    2 months ago

    Markham, Ontario, Canada Aviva Full time

    About the RoleWe are seeking a dedicated Finance Systems Data Engineer with solid experience in the insurance industry and expertise in ETL and PostgreSQL development to join our dynamic team at Aviva.Key ResponsibilitiesDesign, develop, and maintain ETL processes to extract, transform, and load data from various sources into our finance systems.Develop and...