Data Engineer with Snowflake

Aviva plc; Warszawa; Hybrid; PLN 180,000 - 240,000; Full time

Benefits offered by this job

Contract of employment

Performance Bonus

Private medical care (ENEL-MED)

Cafeteria system of benefits (e.g. Mul

Job summary

Aviva in Warsaw is seeking a Data Engineer to design, develop and optimize scalable data pipelines using Snowflake and the modern data stack. You will collaborate with cross-functional teams to translate data requirements into robust solutions.

The role emphasizes data quality, security, cost-efficient architecture, and opportunities to work with cutting-edge tools like DBT, Airflow, and Snowpark. Fluent English is expected; hybrid work with some days in the office.

Qualifications

• Experience in Snowflake scripting - stored procedures (PLSQL or python), UDFs, CTEs, window functions.
• Knowledge of ETL/ELT and Snowflake architecture.
• Fluent English.
• Knowledge of various file formats (Parquet, JSON, YAML).
• Understanding Snowflake data sharing, replication, masking policies, secure views, and time travel.

Responsibilities

• Design, develop, and optimize scalable data pipelines using Snowflake and modern data stack tools.
• Collaborate with cross-functional teams to understand data requirements and deliver robust solutions.
• Implement best practices for data modelling, performance tuning, and cost-efficient architecture in Snowflake.
• Conduct code reviews to ensure high-quality, secure data engineering solutions.
• Ensure data quality, reliability, and security across all data lifecycle stages.
• Automate data workflows and integrate diverse data sources into Snowflake.

Skills

Snowflake

Python

SQL

ETL/ELT

Data modeling

Git

DBT

Airflow

Snowflake certifications

Tools

Snowflake

DBT

Git

Azure DevOps

AWS

Airflow

Job description

Hi, we're glad you're here! We are hiring to our Aviva Services Excellence Centre! Take a look at our job description - maybe it suits you or one of your friends? The project is growing and the team needs you!

Why is it good to join Aviva?

Become a part of a team of enthusiasts where initiatives are more than welcome.

You’ll have the real influence on the shape of the project (everyone’s voice matters).

You’ll have fun creating and implementing high quality solutions that you can later leverage on - there will be more time to work on interesting features in the future (instead of putting out fires).

Experience friendly and supportive working culture.

Direct cooperation with the UK team.

Have lots of fun and satisfaction from your work without sacrificing work-life balance.

You’ll get access to high quality learning platforms with guaranteed time for self-development during working hours.

Internal upskilling programs available for Data Engineers.

Opportunity to use and experience modern technology stack used within Data Engineering.

Clear career path.

What will you be doing?

• Designing, developing, and optimizing scalable data pipelines using Snowflake and modern data stack tools.
• Collaborating with cross-functional teams to understand data requirements and deliver robust solutions.
• Implementing best practices for data modelling, performance tuning, and cost-efficient architecture in Snowflake.
• Conducting code reviews to ensure high-quality, maintainable, and secure data engineering solutions.
• Ensuring data quality, reliability, and security across all stages of the data lifecycle.
• Automating data workflows and integrating diverse data sources into the Snowflake platform.
• Monitoring and troubleshooting data pipeline issues, ensuring high availability and performance.

What we’re looking for?

• Approx. 2-3 years of experience in a relevant role.
• Experience in Snowflake scripting - stored procedures (PLSQL or python), user defined functions, Common Table expressions, Window functions.
• Knowledge of ETL / ELT and Snowflake architecture.
• Knowledge of various file formats (Parquet, JSON, YAML).
• Understanding Snowflake concepts like data sharing, replication, dynamic data, using masking policies, secure views, row access policies concepts, tags, streams, tasks, external tables, time travel, clone, storage integration, stages, clustering of larger tables on clustering keys, role-based access control.
• Familiarity with git concepts like creation of branches, cloning of repo, creation of pull requests, resolving conflicts, code reviews.
• Understanding basic principles of data structure and data modelling.
• Knowledge of Azure DevOps and/or AWS services (AWS Glue experience is preferred).
• Experience with software engineering best practices such as design patterns, code review, testing, and documentation.
• Fluent English.
• Nice to have: Knowledge of Apache airflow to schedule pipelines.
• Experience in using Snowpark.
• DBT (Data build tool or any other commercial ETL tool) hands on experience in creating models as per requirements, using macros, jinja scripting, hooks, automated tests, snapshots, DBT packages.
• Snowflake certifications.

Benefits & Perks

• Contract of employment
• Performance Bonus
• Private medical care (ENEL-MED)
• Cafeteria system of benefits (e.g. MultiSport card)
• Additional parent privileges: baby leave - 6 weeks leave for second parent
• Shortened working time after parental leave
• Employer-funded group insurance
• Employee Shares Plan
• Extra day off for birthday
• Paid time off to volunteer
• Additional leave acquired over the years in the company (even 5 days more in a year)
• Wellbeing Leave - additional two weeks paid leave after 10 years of service
• Psychological support consultations
• Access to the e-learning platforms Internal employee referral program
• Hybrid working model from Poland with a few days in Warsaw office per month
• Attractive office location in Warsaw - Gdański Business Center
• Additional entitlements for people with disabilities - Work Without Barriers
• Work environment that promotes diversity - Diversity Charter

Diversity & Inclusion

We’re inclusive - we welcome applications from people with diverse backgrounds and experiences.

Aviva is for everyone! We’ve been ranked the #1 Best Workplace in Poland for a second year in a row and a top choice for Millennials by Great Place to Work! As a signatory to the Diversity Charter, Aviva applies a policy of equal treatment and creates a work environment that is friendly to people with disabilities. We do not require from candidates the date of birth, marital status and attached photos to your CV. We encourage all individuals regardless of gender to apply. Most of our people are smart working – spending also time in our office - combining the benefits of flexibility, with time together with colleagues. We’re inclusive - we welcome applications from people with diverse backgrounds and experiences.

Excited but not sure you tick every box? Research tells us that women, particularly, feel this way. So, regardless of gender, why not apply and try! To find out more about current job offers at Aviva take a look here.

About Aviva

We help our 19.5 million customers to save for the future and manage the risks of everyday life. To give these customers the best possible products and service we know we must make Aviva the most attractive choice for talented, entrepreneurial people with diverse backgrounds and an evolving range of expertise and insight. So, we’re passionate about helping our 23,000 people to do the best work of their lives, to enable them to make a positive difference to the lives of our customers.