Senior Analytics Developer

Experience Aviva
Individually we are people, but together we are Aviva. Individually these are just words, but together they are our Values – Care, Commitment, Community, and Confidence.

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
We're building trustworthy pricing data products that our underwriters, actuaries, and data scientists rely on every day. If you're passionate about high‑quality data and love turning complex pipelines into reliable, analytics‑ready assets, this role is for you.

You'll lead quality efforts within the Pricing Transformation team, owning test strategies for pipelines and models while contributing to analytics engineering (modelling, transformation, and documentation). Your work ensures faster releases, fewer defects, and data our stakeholders can trust.

What You'll Do
Quality Engineering (Data Focus):

• Create and approve test strategies for ETL/ELT pipelines and analytics assets. Set up test environments and representative QA datasets; execute tests, log defects, and sign off on releases.
• "Shift‑left" quality: collaborate early with data engineers, product owners and analysts to apply functional and non‑functional testing for data quality, lineage, security, and performance.
• Automate quality gates in CI/CD (e.g., Jenkins) for dbt and Airflow jobs. Implement schema/constraint tests, reconciliation checks, anomaly detection and monitoring for freshness and completeness.

Analytics Engineering (Data Modelling & Enablement)

• Design and maintain analytics‑ready models in Snowflake using dbt (naming, documentation, versioning, test coverage), scheduled/orchestrated via Airflow.
• Build robust transformation logic in SQL/Python with performance tuning, clear lineage, and re‑usable patterns; champion coding standards and peer reviews.
• Partner with product and stakeholders to translate business requirements into data models and acceptance criteria; measure outcomes with clear data quality KPIs (freshness, coverage, defect leakage).

What You'll Bring

• Bachelor's degree in Computer Science, Data Engineering, Information Technology, or a related field.
• A Master's degree in Data Analytics or Engineering is an asset.
• 5+ years of professional experience in data engineering, analytics engineering, or quality assurance within data environments.
• Minimum of 2 years focused on QA/testing for data pipelines and analytics workflows.
• Strong SQL and Python, with hands‑on experience testing and validating large‑scale transformations.
• Experience with at least some of: Snowflake, dbt, Airflow, Jenkins/Git‑based CI/CD.
• Practical knowledge of data quality frameworks (constraints, reconciliation, profiling), lineage and security considerations, and defect management using Jira.
• A collaborative mindset — comfortable working with engineers, analysts, product, and platform teams.

What Makes You Stand Out

• Experience in insurance or financial services.
• Familiarity with insurance or pricing/actuarial data contexts.
• Experience introducing observability/monitoring for pipelines and datasets.
• Comfort facilitating risk‑based testing and go‑live readiness assessments.

What You'll Get

• The salary band for this position ranges from $80,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 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.