- Company Name
- Aviva Canada
- Job Title
- Senior Analytics Developer
- Job Description
-
Job Title: Senior Analytics Developer
Role Summary:
Lead quality and analytics engineering for pricing data products, ensuring reliable, test‑driven pipelines and models that support underwriters, actuaries, and data scientists.
Expectations:
Deliver high‑quality, production‑ready analytics assets with minimal defects, meet rigorous data quality KPIs, and govern early‑stage testing to accelerate release cycles.
Key Responsibilities:
- Design, document, and maintain Snowflake analytics models using dbt, implementing naming, versioning, and test coverage.
- Build and optimize SQL/Python transformations, enforce coding standards, and conduct peer reviews.
- Develop and approve test strategies for ETL/ELT pipelines and analytics data products.
- Set up test environments, generate representative QA datasets, execute tests, log defects, and sign off releases.
- Implement “shift‑left” quality by collaborating with data engineers, product owners, and analysts to apply functional, non‑functional, lineage, security, and performance tests.
- Automate quality gates in CI/CD pipelines (Jenkins, Git-based workflows) for dbt and Airflow jobs, including schema, constraint, reconciliation, anomaly detection, and monitoring checks.
- Partner with stakeholders to translate business requirements into data models and acceptance criteria, measuring outcomes with data quality KPIs.
- Conduct risk‑based testing and go‑live readiness assessments, facilitating release confidence.
Required Skills:
- Proficiency in SQL and Python, including testing and validating large‑scale transformations.
- Hands‑on experience with Snowflake, dbt, Airflow, and CI/CD tools (Jenkins, Git).
- Strong knowledge of data quality frameworks (constraints, reconciliation, profiling), lineage, security, and defect management (Jira).
- Ability to design and maintain analytics‑ready models, document lineage, and tune performance.
- Collaborative mindset, comfortable working cross‑functionally with engineers, analysts, product, and platform teams.
- Experience in insurance or financial services contexts (asset).
- Familiarity with observability/monitoring for pipelines and datasets (asset).
Required Education & Certifications:
- Bachelor’s degree in Computer Science, Data Engineering, Information Technology, or related field.
- Master’s degree in Data Analytics or Engineering considered an asset.