Aviva

Data Engineer - AWS, Snowflake, DBT

Aviva • $115K — $135K *
Markham, ON L3R 0G6In-Person
Finance & Insurance
5 - 7 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • University degree in Computer Engineering or Computer Science.
  • 5+ years of experience in cloud solutions, data lakes, and data warehouses.
  • Proficient in AWS, Snowflake, Python, and DBT for data management.
  • Hands-on experience with Apache Airflow for automated workflows.
  • Strong knowledge in ETL/ELT processes and data governance principles.
  • Agile software development experience is required.
  • Excellent verbal and written communication skills.

Responsibilities

  • Design and operationalize large scale enterprise data solutions in AWS and Snowflake.
  • Develop ETL pipelines for various data sources using Python and DBT.
  • Manage data workflows using Apache Airflow for task orchestration.
  • Create solution designs for data acquisition and integrations.
  • Advocate for data governance, quality, and catalog practices.
  • Utilize problem-solving skills to drive efficiency and performance.
  • Challenge the status quo to improve delivery and workflows.

Benefits

  • Annual bonus eligibility and retirement savings options.
  • Professional development support for career growth.
  • Flexible hybrid work model.
  • Outstanding vacation package with additional days off.
  • Diversity and inclusion programs advocated by employees.
  • Wellness programs for physical and mental health.
Full Job Description
We are looking for a collaborative and resourceful Data Engineer for our IT Data Platform Engineering Delivery team at Aviva Canada. You are dedicated, naturally inquisitive and are comfortable in a fast-paced environment.

This role will be part of and a member of our Information Technology Enterprise Data Services Group. You will be responsible for leading the architecture, design, analysis, and implementation in a successful, and experienced team. You'll be required to apply your depth of knowledge and expertise with both modern and legacy data platforms to develop data ecosystems that will meet business requirements and align with Aviva's enterprise architecture goals and standards. Aviva has embarked on an exciting journey to modernize, craft, and build a next generation data platform to support the growing data needs of the business and to enable the capabilities of AI to drive business value.

We embrace a culture challenging the status quo and constantly look to efficiently simplify processes, technology, and workflow.

What you'll do

  • Design, build and operationalize large scale enterprise data solutions in AWS and Snowflake
  • Design and Develop ETL Pipeline to ingest data into Cloud from different data sources (Files, Mainframe, Relational Sources, NoSQL, Hadoop Etc.) using Python and DBT.
  • Proficient in designing, scheduling, and managing data workflows using Apache Airflow, including DAG creation, task orchestration, and monitoring pipeline performance.
  • Work will also encompass crafting & developing solution designs for data acquisition/ingestion of multifaceted data sets (internal/external), data integrations & data warehouse/marts.
  • Advocate importance of data catalogs, data governance and data quality practices.
  • Outstanding problem-solving skills.
  • You are a self-starter with experience working in a fast-paced agile development environment.
  • Outcome focused with strong decision making and critical thinking skills to challenge the status quo which impacts delivery pace and performance and striving for efficiencies.


What you'll bring

  • University degree in Computer Engineering or Computer Science.
  • 5+ years of experience crafting solutions for Cloud, data lakes, data integrations, data warehouses/marts.
  • Proficient in AWS, Snowflake, Python and DBT to design, implement, and optimize data quality solutions for our enterprise data management initiatives.
  • Hands-on experience in developing and maintaining automated workflows and system operations using Python and Apache Airflow, with a focus on streamlining processes and optimizing performance.
  • Outstanding knowledge and experience in ETL/ELT development.
  • Experience implementing Data Governance principles and efficiencies.
  • Familiar with the Agile software development.
  • Excellent verbal and written communication skills.
  • Insurance knowledge is an asset - Ability to foundationally understand complex business process driving technical systems.


What you'll get

  • The salary band for this position ranges from $115,000 to $135,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.
  • Employee discount on home and auto insurance (where applicable).
  • Hybrid flexible work model.


This job advertisement is for an existing vacancy which has been posted both internally & externally.

#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
Finance & Insurance
NASDAQ
AVVIY
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Aviva

More Finance & Insurance Jobs

Find similar Data Engineer - AWS, Snowflake, DBT jobs:

NationwideMarkham, ON