Aviva

Senior Analytics Developer

Aviva

full-time

Posted on:

Location Type: Hybrid

Location: Markham • 🇨🇦 Canada

Visit company website
✨ AI Apply
Apply

Salary

💰 CA$80,000 - CA$110,000 per year

Job Level

Senior

Tech Stack

AirflowETLJenkinsPythonSQL

About the role

  • 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.
  • 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.
  • 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).

Requirements

  • 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.
Benefits
  • 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.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
ETLELTSQLPythondata qualitydata modelingperformance tuningschema testinganomaly detectiontransformation logic
Soft skills
collaborationcommunicationproblem-solvingattention to detailanalytical thinking