Finance Systems Data Engineer Associate

3 days ago

Markham, Ontario, Canada Aviva Full time
About the Role

We 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 Responsibilities
  • Design, develop, and maintain ETL 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 complex 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.
Requirements
  • Experience in the insurance industry and ability to understand underwriting data terminology.
  • Experience in supporting finance systems.
  • Knowledge in Oracle Fusion applications including sub-modules such as accounts payable, cash management, and fixed assets.
  • Demonstrable experience as an ETL Developer (Informatica PowerCenter and Informatica BDM).
  • Experience as a PostgreSQL Developer.
  • Experience in Guidewire Policy, Billing, and Claims Centers.
  • Experience on automation tools like Control-M, ASG ZENA.
  • Experience in writing Unix scripts.
  • Experience in Qlik and Python reporting.
  • Experience with Snowflake.
  • Solid understanding of accounting principles (balance sheet/P&L concepts).
  • Expertise in ETL tools (especially Informatica) and PostgreSQL.
  • Strong expertise in Postgres and database design.
  • Knowledge of data warehousing concepts and best practices.
  • Excellent problem-solving skills and attention to detail.
  • Experience in Agile methodology and JIRA.
  • Above-average 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 (an asset).
  • Informatica Certified Professional (ICP) and/or Informatica Foundation Level Certifications (IDMC, CDCG, MDM, etc.) (preferred).
  • Experience with database systems (e.g., Oracle, Postgres, MySQL). SQL Associate Certification (an asset).
  • Guidewire professional certifications (an asset).
  • Familiarity with cloud-based data solutions (e.g., AWS, Snowflake) (preferred).
  • Knowledge of data visualization tools (e.g., Qlik, Python, Power BI) (an asset).
What We Offer
  • 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.

Aviva Canada has an accommodation process in place to provide accommodations for employees with disabilities. If upon commencement of employment you require a specific accommodation because of a disability, please contact your Talent Acquisition Partner so that an appropriate accommodation can be arranged. This process applies throughout your career with Aviva Canada.

  • Electrical Systems Engineer

    1 month ago

    Markham, Ontario, Canada Gem Systems Inc. Full time

    Position OverviewGem Systems Inc. is seeking a skilled Electronics Engineer to join our dynamic team. The ideal candidate will possess a strong background in designing and developing electronic systems and components.QualificationsEducation: Master's degree in Electrical Engineering or a related field.Experience: A minimum of 5 years in the electronics...

  • Electrical Systems Engineer

    1 month ago

    Markham, Ontario, Canada Gem Systems Inc. Full time

    Position OverviewWe are seeking a qualified Electronics Engineer to join our team at Gem Systems Inc.. This role involves the design and development of electronic systems and components.Educational RequirementsMaster's degree in Electronics or a related fieldWork EnvironmentLocated in an urban areaInvolvement in the manufacturing of electrical or electronic...

  • Enterprise Platform Systems Engineer

    1 week ago

    Markham, Ontario, Canada Astellas Pharma Inc. Full time

    About the RoleAstellas Pharma Inc. is seeking a highly skilled Systems Engineer to join our team in Canada. As a key member of our digital initiatives, you will play a crucial role in driving our enterprise platform forward.Key ResponsibilitiesDesign, develop, and configure business platforms to meet the specific needs of our organization.Ensure seamless...

  • Enterprise Platform Systems Engineer

    1 week ago

    Markham, Ontario, Canada Astellas Pharma Inc. Full time

    About the RoleAstellas Pharma Inc. is seeking a highly skilled Systems Engineer to join our team in Canada. As a key member of our digital initiatives, you will play a crucial role in driving our enterprise platform forward.Key ResponsibilitiesDesign, develop, and configure business platforms to meet the specific needs of our organization.Ensure seamless...

  • Business System Analyst

    2 weeks ago

    Markham, Ontario, Canada Tata Consultancy Services Full time

    About the RoleTata Consultancy Services is an equal opportunity employer, committed to fostering a diverse and inclusive work environment. Our organization values the unique perspectives and experiences that each individual brings to the table, and we strive to create a workplace that reflects the communities we serve.Our Commitment to Diversity and...

  • Business System Analyst

    2 weeks ago

    Markham, Ontario, Canada Tata Consultancy Services Full time

    About the RoleTata Consultancy Services is an equal opportunity employer, committed to fostering a diverse and inclusive work environment. Our organization values the unique perspectives and experiences that each individual brings to the table, and we strive to create a workplace that reflects the communities we serve.Our Commitment to Diversity and...

  • Senior Principal Engineer

    2 weeks ago

    Markham, Ontario, Canada Huawei Full time

    Job Summary:We are seeking a highly experienced Senior Principal Engineer to lead our team in designing and developing next-generation data and AI systems. The ideal candidate will have a strong background in cloud infrastructure, data processing, and AI, with a proven track record of delivering business impact and customer success stories.Key...

  • Senior Principal Engineer

    2 weeks ago

    Markham, Ontario, Canada Huawei Full time

    Job Summary:We are seeking a highly experienced Senior Principal Engineer to lead our team in designing and developing next-generation data and AI systems. The ideal candidate will have a strong background in cloud infrastructure, data processing, and AI, with a proven track record of delivering business impact and customer success stories.Key...

  • Electrical Systems Engineer

    1 month ago

    Markham, Ontario, Canada Gem Systems Inc. Full time

    Electrical Systems EngineerMaster's degree in Electrical Engineering is essentialAt least 5 years of experience in the production of electrical or electronic devicesWork environment: Urban setting within a specialized manufacturing facilityKey ResponsibilitiesDevelop cutting-edge electrical and electronic components and systemsPerform testing and evaluate...

  • Electrical Systems Engineer

    1 month ago

    Markham, Ontario, Canada Gem Systems Inc. Full time

    Electrical Systems Design EngineerMaster's degree in Electrical Engineering is essentialAt least 5 years of experience in the production of electrical or electronic devicesWork environment: Urban setting within a specialized manufacturing sectorKey ResponsibilitiesDevelop cutting-edge electrical and electronic components and systemsPerform testing and...

  • Electrical Systems Engineer

    1 month ago

    Markham, Ontario, Canada Gem Systems Inc. Full time

    Electrical Systems EngineerMaster's degree in Electrical Engineering is essentialAt least 5 years of experience in the production of electrical or electronic devicesWork environment: Urban area within a specialized manufacturing facilityKey ResponsibilitiesDevelop cutting-edge electrical and electronic components and systemsPerform testing and evaluate...

  • Electrical Systems Engineer

    1 month ago

    Markham, Ontario, Canada Gem Systems Inc. Full time

    Electrical Systems EngineerMaster's degree in Electrical Engineering is essentialAt least 5 years of experience in the production of electrical or electronic devicesWork environment: Urban area within a specialized manufacturing facilityKey ResponsibilitiesDevelop cutting-edge electrical and electronic components and systemsPerform testing and evaluate...

  • Electrical Systems Engineer

    1 month ago

    Markham, Ontario, Canada Gem Systems Inc. Full time

    Electrical Systems Design EngineerMaster's degree in Electrical Engineering is essentialAt least 5 years of experience in the production of electrical or electronic devicesWork environment: Urban setting within a specialized manufacturing facilityKey ResponsibilitiesDevelop cutting-edge electrical and electronic systems and componentsPerform testing and...

  • Enterprise Platform Systems Engineer

    1 day ago

    Markham, Ontario, Canada Astellas Pharma Inc. Full time

    About Astellas Pharma Inc.Astellas Pharma Inc. is a global pharmaceutical company headquartered in Japan, with a team of over 14,000 employees managing operations in approximately 70 countries worldwide. We are a Top 30 global biopharma company based on global revenues and are predicted to be one of the Top 10 Cancer Drug Makers of 2024 by Fierce Pharma.Job...

  • Enterprise Platform Systems Engineer

    23 hours ago

    Markham, Ontario, Canada Astellas Pharma Inc. Full time

    About Astellas Pharma Inc.Astellas Pharma Inc. is a global pharmaceutical company headquartered in Japan, with a team of over 14,000 employees managing operations in approximately 70 countries worldwide. We are a Top 30 global biopharma company based on global revenues and are predicted to be one of the Top 10 Cancer Drug Makers of 2024 by Fierce Pharma.Job...

  • Electronics Engineer

    5 hours ago

    Markham, Ontario, Canada Gem Systems Inc. Full time

    Job Title: Electronics EngineerGem Systems Inc. is seeking an experienced Electronics Engineer to join our team. As an Electronics Engineer, you will be responsible for designing, developing, and testing electrical and electronic components, systems, and equipment.Key Responsibilities:Design and develop electrical and electronic components, systems, and...

  • Electronics Engineer

    2 hours ago

    Markham, Ontario, Canada Gem Systems Inc. Full time

    Job Title: Electronics EngineerGem Systems Inc. is seeking an experienced Electronics Engineer to join our team. As an Electronics Engineer, you will be responsible for designing, developing, and testing electrical and electronic components, systems, and equipment.Key Responsibilities:Design and develop electrical and electronic components, systems, and...

  • Electronics Engineer

    2 days ago

    Markham, Ontario, Canada Gem Systems Inc. Full time

    About the RoleWe are seeking an experienced Electronics Engineer to join our team at Gem Systems Inc. as a key member of our engineering department.Key ResponsibilitiesDesign and develop electrical and electronic components, systems, and equipmentSet up and operate specialized and standard test equipment to diagnose, test, and analyze the performance of...

  • Electronics Engineer

    2 days ago

    Markham, Ontario, Canada Gem Systems Inc. Full time

    About the RoleWe are seeking an experienced Electronics Engineer to join our team at Gem Systems Inc. as a key member of our engineering department.Key ResponsibilitiesDesign and develop electrical and electronic components, systems, and equipmentSet up and operate specialized and standard test equipment to diagnose, test, and analyze the performance of...

  • Senior Associate, Commercial Finance Expert

    2 weeks ago

    Markham, Ontario, Canada Kyndryl Inc. Full time

    About the RoleWe are seeking a highly skilled Financial Analyst to join our team at Kyndryl Inc. as a Senior Associate, Commercial Finance. This is an exciting opportunity to drive revenue and cost optimization, identifying opportunities to meet deployed targets.Key ResponsibilitiesFinancial Analysis and Reporting:Perform comprehensive financial analysis,...