Finance Systems Data Engineer Associate

1 month 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 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.
  • 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 procedures 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.

  • Data Engineer

    1 month 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

    2 weeks ago

    Markham, Ontario, Canada Aviva Full time

    At Aviva, we pride ourselves on being a leading insurance company that provides top-notch financial solutions. We are seeking a dedicated Finance Systems Data Engineer to join our dynamic team.As a Finance Systems Data Engineer, you will be responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various...

  • Data Analyst

    4 weeks ago

    Markham, Ontario, Canada Data Privacy Full time

    Unlock the Future of Automotive TechnologyAt Syntronic, we're pushing the boundaries of innovation in the automotive industry. As a Data Analyst - Automotive Engineer, you'll collaborate with top-tier clients on cutting-edge projects, gaining international experience and exploring multiple sectors like telecommunications, healthcare, and industrial...

  • Software Engineer

    4 weeks ago

    Markham, Ontario, Canada Tomato Finance Full time

    Job Title: Software EngineerAbout the Role:We are seeking a skilled Software Engineer to join our team at Tomato Finance. As a Software Engineer, you will be responsible for designing, developing, and testing software applications.Key Responsibilities:Design and develop software applications using various programming languages and technologies.Collaborate...

  • Data Analyst

    2 weeks ago

    Markham, Ontario, Canada Data Privacy Full time

    Imagine working on cutting-edge automotive projects where innovation shapes the future. At Syntronic, we empower data analysts to drive technological advancements in the automotive industry. Our teams collaborate with top-tier clients to develop data-driven solutions that transform the sector.Responsibilities:Collaborate with internal clients to understand...

  • Financial Systems Data Specialist

    4 days ago

    Markham, Ontario, Canada Recrute Action Full time

    Job DescriptionWe are seeking a highly skilled Financial Systems Data Specialist to join our team at RecruitAction. This is a full-time position with a 37.5 hour workweek, working in our Markham office three days a week and remotely two days a week.Responsibilities:Design, develop, and maintain ETL processes to extract, transform, and load data from diverse...

  • Software Engineer

    3 weeks ago

    Markham, Ontario, Canada Tomato Finance Full time

    About the JobWe are seeking a skilled Software Engineer to join our team at {company}.The successful candidate will be responsible for designing and developing backend systems, ensuring seamless integration with our existing infrastructure.Key Responsibilities:Design and develop high-quality, scalable backend systems.Collaborate with cross-functional teams...

  • Electrical Systems Engineer

    4 weeks ago

    Markham, Ontario, Canada AECOM Full time

    Electrical Designer Role OverviewAECOM is seeking an Electrical Designer to join our Buildings+Places team in Markham, Ontario. As an Electrical Designer, you will be responsible for performing specific and limited portions of a broader assignment under the direction of an experienced electrical engineer.Key Responsibilities:Apply industry standard practices...

  • Data Engineer for Advanced Prognostics Systems

    4 days ago

    Markham, Ontario, Canada General Motors of Canada Full time

    Job DescriptionWe are seeking a highly skilled Senior Staff Data Engineer to join our team at General Motors of Canada. This role involves designing and deploying advanced signal processing methods for prognostics applications.About the RoleThis position is a key part of our dynamic team, working on various cross-functional projects simultaneously,...

  • Finance Data Analyst

    4 weeks ago

    Markham, Ontario, Canada Aviva Full time

    At Aviva, we're seeking a highly skilled Finance Data Analyst to join our team. As a key member of our finance department, you'll be responsible for designing and delivering MI reports and QLIK dashboards to support finance and MI reporting needs.Key responsibilities include:Building and maintaining interactive dashboards and reports using Qlik Sense to...

  • Financial Systems Data Engineering Specialist

    4 days ago

    Markham, Ontario, Canada Aviva Full time

    OverviewWe are seeking a highly skilled Financial Systems Data Engineer to join our dynamic team at Aviva Canada.

  • Software Engineer

    4 weeks ago

    Markham, Ontario, Canada Tomato Finance Full time

    We are seeking a skilled Software Engineer to join our team at Tomato Finance. The ideal candidate will have a strong background in software development and be able to write, modify, integrate, and test software code.The successful candidate will also be responsible for preparing reports, manuals, and other documentation on the status, operation, and...

  • Distributed Data Processing Engineer for AI-Native Systems

    7 days ago

    Markham, Ontario, Canada Huawei Technologies Canada Co., Ltd. Full time

    Job TitleDistributed Data Processing Engineer for AI-Native SystemsOverviewHuawei Technologies Canada Co., Ltd. is seeking an experienced Distributed Data Processing Engineer to join our team. This 12-month contract role will focus on developing proof-of-concept distributed systems and product components.Key ResponsibilitiesDesign and develop data processing...

  • Finance Data Analyst

    4 weeks ago

    Markham, Ontario, Canada Aviva Full time

    At Aviva, we're seeking a skilled Finance MI Reporting Analyst to join our team. As a key member of our finance department, you'll be responsible for designing and delivering MI reports and QLIK dashboards to support finance and MI reporting needs.Key Responsibilities:Build and maintain interactive dashboards and reports using Qlik Sense to visualize key...

  • Electrical Systems Engineer

    4 weeks ago

    Markham, Ontario, Canada AECOM Full time

    Electrical Designer Role OverviewAECOM is seeking an Electrical Designer to join our Buildings+Places team in Markham, Ontario. As an Electrical Designer, you will play a key role in delivering high-quality electrical engineering solutions for our clients.Key Responsibilities:Collaborate with experienced electrical engineers to design and develop electrical...

  • Technical Data Lead

    4 weeks ago

    Markham, Ontario, Canada GE Power Portfolio Full time

    Job SummaryAs a Technical Data Lead, you will be responsible for leading and mentoring a team responsible for Instrumentation, Control, and Monitoring systems associated with plant cross-disciplinary and cross-systems simulation. Your focus will be on work planning, technical approach, design assurance, and execution excellence from ITO to OTR on new build...

  • Data Systems Architect

    2 weeks ago

    Markham, Ontario, Canada General Motors Full time

    **Job Overview**This role is categorized as hybrid and requires the successful candidate to report to the office three times per week, at minimum.As a member of the Data Engineering organization at General Motors, you will have the opportunity to work with a rich and rapidly growing dataset.**Key Responsibilities**Design, build, and maintain infrastructure...

  • Cloud Engineer Data Center Specialist

    1 month ago

    Markham, Ontario, Canada Enercare Inc. Full time

    Job Title: Cloud Engineer Data Center F/HEnercare Inc. is seeking a highly skilled Cloud Engineer Data Center to join our team. As a key member of our Information Technology department, you will be responsible for designing, planning, installing, and configuring highly available server infrastructure for deploying instances, applying operating system...

  • Clinical Data Engineer

    4 weeks ago

    Markham, Ontario, Canada Astellas Full time

    Clinical Data Engineer RoleAstellas Pharma Inc. is a pharmaceutical company with a strong commitment to innovation and patient care. We are seeking a skilled Clinical Data Engineer to join our team and contribute to the development of cutting-edge therapies.The Clinical Data Engineer will play a critical role in designing and implementing data pipeline...

  • Data Engineering Expert

    4 days ago

    Markham, Ontario, Canada Elite Mente LLC Full time

    Job Title: Data Engineering ExpertLocation: Markham, ON (onsite 3 days)Open for Contract and Full-time RolesJob Overview:We are seeking a highly skilled Data Engineer to join our team at Elite Mente LLC.About the Role:As a Data Engineer, you will be responsible for designing, building, and maintaining large-scale data systems. Your primary focus will be on...