Senior Analytics Engineer

Aviva Canada; Markham; On-site; CAD 90,000 - 110,000; Full time

Benefits offered by this job

Hybrid work model

Career development

Health benefits

Job summary

Aviva Canada is seeking a motivated data engineer to join the Claims Data and Insights team within Finance. You will design, build, and optimize scalable data pipelines using Snowflake and Qlik, owning end-to-end delivery from requirements to implementation and support.

You will collaborate with claims operations, analytics, and actuarial teams to translate business needs into robust data solutions, enabling advanced analytics and scalable data governance.

Qualifications

• Minimum 3 years of experience in data engineering, analytics, or related technical role.
• Strong communication skills; ability to explain complex concepts to non-technical audiences.
• Collaborative with ability to work independently and own deliverables.
• Proficiency in Python and SQL with experience in complex data models.

Responsibilities

• Design, develop, and optimize scalable data pipelines and analytical datasets using Snowflake and Qlik.
• Own end-to-end delivery of data solutions from requirements through implementation and support.
• Define and apply best practices for data modeling, performance optimization, and cost-efficient Snowflake architecture.
• Automate data ingestion and transformation workflows from multiple source systems.
• Monitor and resolve data pipeline and reporting issues to ensure reliability and performance.
• Collaborate with claims operations, analytics, and actuarial teams to translate business needs into data solutions.

Skills

Python

SQL

Data engineering

Analytics

Communication

Tools

Snowflake

Qlik

ETL/ELT

Job description

Experience Aviva

Experience Aviva

Together, we are Aviva. Our values — Care, Commitment, Community, and Confidence — guide how we show up for each other and for our customers. Individually, they’re words. Together, they define who we are.

At Aviva Canada, we put people first, our employees, our customers, and our communities. We’re proud of a culture built on care, inclusion, and collaboration, where your voice matters and your growth is supported. We’re not just about insurance; we’re about making a real difference by protecting what matters most.

The Opportunity

Aviva Canada is looking for a motivated and technically strong individual to join the Claims Data and Insights team within Finance. This role is ideal for someone who thrives as a hands‑on individual contributor through strong delivery, operational understanding, stakeholder management, and end-to-end ownership.

You will play a key role in evolving our Claims Data ecosystem by delivering high‑impact data solutions, supporting engineering best practices and the modernization of our data platform. You will work closely with the team supporting our Qlik environment and contribute significantly to our migration to Snowflake, helping to establish a scalable, well‑governed data foundation that enables advanced analytics and supports future growth across Claims and Finance.

If you are excited about building modern data solutions and driving meaningful business impact, we would love to hear from you.

What You’ll Do

• Design, develop, and optimize scalable data pipelines and analytical datasets using Snowflake and Qlik.
• Own the end‑to‑end delivery of data solutions, from requirements through implementation and support.
• Define and apply best practices for data modeling, performance optimization, and cost‑efficient architecture within Snowflake.
• Automate data ingestion and transformation workflows while integrating data from multiple source systems.
• Monitor, troubleshoot, and resolve data pipeline and reporting issues to ensure reliability, performance, and availability.
• Collaborate with claims operations, analytics team, and actuarial teams by developing a strong understanding of claims workflows and owning stakeholder interactions to translate business needs into robust data solutions.
  
  

What You’ll Bring

• Minimum 3 years of experience in data engineering, analytics, or a related technical role.
• Strong communication skills, with the ability to clearly explain complex technical concepts to non-technical audience.
• A collaborative approach, balanced with the ability to work independently and take ownership of deliverables.
• A strong sense of accountability and ownership, with a consistent focus on delivering results.
• Strong analytic and problem-solving skills with the ability to work through the technical implementation details while appreciating the big picture.
• Proficiency in Python and SQL, with experience working with complex data models.
• Hands-on experience with cloud data warehouses (Snowflake preferred).
• Experience building, maintaining, and debugging ETL/ELT data pipelines.
  
  

What Makes You Stand Out

• Familiarity with P&C insurance and claims data.
  
  

What You’ll Get

• The salary band for this position ranges from $90,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.
• Hybrid flexible work model.
• 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.
  
  

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.