Senior Analytics Engineer

Aviva Investors (External); Markham; Hybrid; CAD 90,000 - 110,000; Full time

Benefits offered by this job

Salary band

Annual bonus eligibility

Retirement plan

Share plan

Health benefits

Wellness programs

Hybrid work model

Career development

Education support

Extra vacation days

Job summary

Aviva Canada is seeking a hands-on Data Engineer to join the Claims Data and Insights team in Finance. You will deliver scalable data pipelines, own end-to-end data solutions, and partner with claims, analytics, and actuarial teams to translate business needs into robust data foundations.

You will work with Snowflake and Python/SQL, shape data models, optimize performance, and support a modern data platform with hybrid work flexibility and career growth opportunities.

Qualifications

• Minimum 3 years of experience in data engineering, analytics, or a related technical role.
• Strong communication skills to explain complex concepts to non-technical stakeholders.
• Collaborative with ownership mindset and delivery focus.
• Strong analytic and problem-solving skills with ability to handle complex data models.

Responsibilities

• Design, develop, and optimize scalable data pipelines and datasets using Snowflake and SQL.
• Own end-to-end delivery of data solutions from requirements to support.
• Define and apply best practices for data modeling, performance, and cost-efficient Snowflake architecture.
• Automate data ingestion and transformations from multiple sources.
• Monitor, troubleshoot, and resolve data pipeline and reporting issues.
• Collaborate with claims operations, analytics, and actuarial teams to translate business needs into data solutions.

Skills

Python

SQL

Analytical thinking

Problem solving

Tools

Snowflake

Job description

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.