Skip to content

Open nowPosted 2 days ago

Data Engineer - Snowflake, dbtCore/Cloud, AWS

aviva135 open roles

Pay
$100,000 – $125,000 a year
Where
Markham
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowData Engineer - Snowflake, dbtCore/Cloud, AWSaviva · Markham
  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on aviva's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

13.5% of postings close within 7 days. Measured by our own scanner across the market. aviva postings stay open a median of 17 days.

Share of postings closed within
  1. 2.3%1 day
  2. 4.6%3 days
  3. 13.5%7 days
  4. 21.8%14 days
  5. 36.6%30 days
  6. 58.9%60 days
This job: posted 2 days ago

aviva median: 17 days open

The posting

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.

Aviva Canada is looking for a 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

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

What you'll bring

Extensive Experience:

  • 6+ years of professional experience delivering over 5 high-impact data projects from inception through warranty.
  • 3+ years of Snowflake, dbtCore/Cloud, and AWS Cloud Technologies.
  • 3+ 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 $100,000 to $125,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.

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-PS1 #LI-Hybrid

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against aviva's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.
  3. We apply on aviva's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.
  4. Every reply, sorted

    aviva's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.
  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.