Aviva

Senior Data Engineer

Aviva$115K — $140K *
Finance & Insurance
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • 8+ years of experience delivering high-impact data projects end-to-end.
  • 2-5 years of hands-on experience with Snowflake and dbt Core/Cloud.
  • 5+ years of coding experience in languages like Python and Java.
  • Deep knowledge of relational, NoSQL, and big data platforms.
  • Advanced skills in SQL, Python, Shell, and Terraform for performance-driven coding.
  • Strong communication skills for technical and business interactions.
  • Familiarity with insurance processes is a plus.

Responsibilities

  • Define and lead data engineering strategies, standards, and guidelines.
  • Develop architecture solutions aligned with both business and technical goals.
  • Design and implement scalable, high-performance data pipelines.
  • Maintain clean, reusable code in SQL, Python, Shell, and Terraform.
  • Champion data quality and governance through test plan creation and reviews.
  • Conduct root cause analysis for complex data issues and implement solutions.
  • Lead agile ceremonies and ensure timely execution of data initiatives.
  • Mentor and guide junior Data Engineers and team members.
  • Collaborate with QA, architects, designers, and delivery teams for cohesive product development.
  • Produce maintainable technical documentation for knowledge sharing.

Benefits

  • Compelling rewards package including base salary, bonus eligibility, and retirement savings.
  • Support for professional development education.
  • Competitive vacation allowance with the option to purchase extra days off.
  • Diversity and inclusion programs focusing on gender, LGBTQ+, and origins.
  • Comprehensive corporate wellness programs to support employees' health.
  • Hybrid work model offering flexibility.
Full Job Description
Aviva Canada is looking for a Senior Data Engineer to support our enterprise data modernization journey. You'll use your expertise across modern and legacy platforms to build robust data pipelines and systems that power analytics and AI initiatives. In this role, you will contribute to the design and implementation of data solutions that support our growing business and next-generation Snowflake platform. This role offers the opportunity to make a meaningful impact while working within a collaborative, forward-thinking team.

What you'll do

  • Technical Leadership: Define and drive the data engineering strategy, standards, and guidelines across the organization.
  • Solution Design: Develop high-level and low-level solution architectures, ensuring alignment with business and technical goals.
  • Data Pipeline Development: Lead the design and implementation of high-performance data pipelines using tools like dbt Core/Cloud, ensuring scalability and maintainability.
  • Code Ownership: Write and maintain clean, reusable code in SQL, Python, Shell, and Terraform.
  • Quality & Governance: Champion data quality, governance, and cataloging practices; create and review test plans to validate data solutions.
  • Issue Resolution: Perform root cause analysis and implement effective solutions for complex data issues.
  • Agile Delivery: Lead agile ceremonies, foster a delivery-focused mindset, and ensure timely execution of data initiatives.
  • Mentorship: Guide and mentor Data Engineers and project team members, elevating team capabilities and engineering excellence.
  • Collaboration: Work closely with architects, designers, QA engineers, and delivery teams to ensure cohesive and customer-centric data products.
  • Documentation: Produce and maintain comprehensive technical documentation to support implementation and knowledge sharing.
  • Talent Development: Contribute to hiring by designing technical challenges, conducting interviews, and supporting onboarding.


What you'll bring

  • 8+ years of professional experience delivering over 10 high-impact data projects from inception through warranty.
  • 2- 5 years of Snowflake, dbtCore/Cloud, and AWS Cloud Technologies.
  • 5+ years of experience with coding in multiple programming languages such as Python, Java, etc.
  • Technical Expertise: Deep knowledge of relational databases (Snowflake, PostgreSQL, Amazon Aurora), big data platforms (Hadoop), and NoSQL databases (e.g., MongoDB).
  • Data Visualization Proficiency: Skilled in tools such as Snowsight, Streamlit, Qlik, and SAP BusinessObjects to communicate insights effectively.
  • Advanced Coding Skills: Expert-level proficiency in SQL, Python, Shell, and Terraform, with a strong focus on performance, reusability, and maintainability.
  • Presentation & Communication: Strong technical and business presentation skills; able to identify and address gaps in data designs and processes with both internal and external stakeholders.
  • Pipeline & Orchestration Tools: Hands-on experience with orchestration tools like Zena and AWS Managed Airflow.
  • Resilience & Adaptability: Proven ability to thrive in fast-paced, ambiguous, and high-pressure environments.
  • Customer-Centric Mindset: Passion for solving real-world problems using data-driven insights to deliver impactful business outcomes.
  • Collaborative Approach: Strong interpersonal and communication skills, with the ability to lead teams and influence cross-functional stakeholders.
  • Domain Knowledge: Familiarity with insurance industry processes and systems is a strong asset.
  • AI/ML & GenAI Exposure: Experience in operationalizing AI/ML & GenAI models is a plus.


Any of the following certifications are an asset:
  • SnowPRO Core
  • SnowPRO Advanced Data Engineer (DEA-C01, DEA-C02)
  • SnowPro® Advanced: Architect (ARA-C01)
  • dbt Developer
  • AWS Cloud Practitioner


What you'll get

  • The salary band for this position ranges from $115,000 to $140,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.
  • 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.
  • Hybrid flexible work model.


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.

#LI-PS1
#LI-Hybrid

About Aviva

Natural health retailer and resource. Aviva promotes a holistic approach to your health and well-being through proper nutrition and a healthy, natural lifestyle. Aviva operates a retail store in Winnipeg, MB Canada and serves customers across Canada and around the world through www.avivahealth.com. Everything for healthy living.

Aviva Careers

Joining Aviva presents a prime opportunity to be part of a team that values leadership, innovation, and diversity in the workplace. Aviva, a leading insurance and financial services company, offers a variety of job opportunities that cater to a range of skills and professional interests, making it an ideal place for career growth and development.

Explore Job Opportunities

Aviva is actively hiring and continuously seeks passionate, creative, and solution-driven team players. Search open positions that match individual skills and interests in areas ranging from finance to technology. Each position at Aviva offers the chance to work with a global team that drives industry-leading solutions.

Experience Professional Growth

Aviva is committed to the professional growth of its employees. The company offers unmatched training, development, and certification support, allowing every team member to reach their full potential. Leadership and diversity training are integral parts of Aviva's commitment to fostering an inclusive environment.

Internship Programs

Start a career at Aviva with an internship that offers real-world experience and networking opportunities. Aviva's internships provide a robust platform for learning and applying practical skills in a dynamic setting, preparing interns for full-time positions within the company.

Benefits and Culture

Aviva is renowned for its employee benefits and positive company culture. The company prioritizes the well-being and satisfaction of its team, offering comprehensive benefits that enhance both personal and professional life. Aviva's culture is built on a foundation of respect for diversity and an ongoing commitment to inclusion.

Innovation and Networking

At Aviva, innovation is at the core of all operations. Employees are encouraged to lead transformation projects and introduce new strategies that drive growth and efficiency. Networking within Aviva provides connections to industry leaders and peers who are equally eager to share insights and collaborate on projects.

Career Advancement

Aviva believes in nurturing talent and providing employees with opportunities for advancement. Whether through promotions, cross-departmental moves, or leadership roles, team members have numerous paths to elevate their careers.

Join the Aviva Team

Interested candidates are encouraged to apply. Prepare a resume, practice for the interview, and explore the exciting employment and career opportunities at Aviva. Personalize job alerts to stay informed about the latest news and positions that align with career preferences and skills.

Stay Connected with Aviva Careers

Keep up to date with career tips, insider perspectives, and industry-leading insights—all from the professionals who are part of Aviva. Explore what it means to work at a company where innovation, leadership, and diversity are valued above all.

READ CAREERS BLOG

Job Alert Emails

Subscribe to receive job alerts, latest news, and insider tips tailored to preferences. Discover the rewarding opportunities that await at Aviva, a company committed to the professional and personal growth of its employees.
Learn more about Aviva
Size
28,596 employees
Industry
NASDAQ

Similar Jobs

More Jobs at Aviva

More Finance & Insurance Jobs

Find similar Senior Data Engineer jobs: