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.
#LI-MH1
#LI-Hybrid
