(Junior or Mid) Data Engineer with Snowflake

Aviva Services Excellence Centre

We are hiring a Data Engineer to join our growing team in the Aviva Services Excellence Centre.

Why is it good to join Aviva?

• Become a part of a team of enthusiasts where initiatives are welcome.
• You’ll have real influence on the shape of the project.
• Enjoy creating and implementing high‑quality solutions and more time for interesting features.
• Experience a friendly and supportive working culture.
• Direct cooperation with the UK team.
• Enjoy a healthy work‑life balance.
• Access to high‑quality learning platforms with guaranteed time for self‑development during work hours.
• Internal upskilling programs available for Data Engineers.
• Opportunity to use and experience a 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. 1‑3 years of experience in a relevant role.
• Experience in Snowflake scripting – stored procedures (PLSQL or Python), user‑defined functions, CTEs, window functions.
• Knowledge of ETL/ELT and Snowflake architecture.
• Familiar with various file formats (Parquet, JSON, YAML).
• Understanding of Snowflake concepts such as data sharing, replication, dynamic data masking, secure views, row‑access policies, tags, streams, tasks, external tables, Time Travel, cloning, storage integration, clustering, and role‑based access control.
• Familiarity with git concepts (branching, cloning, pull requests, conflict resolution, code reviews).
• Understanding of basic data structure and data modelling principles.
• Knowledge of Azure DevOps and/or AWS services (AWS Glue is preferred).
• Experience with software engineering best practices, including design patterns, code review, testing, and documentation.

Nice to have

• Knowledge of Apache Airflow to schedule pipelines.
• Experience using Snowpark.
• Hands‑on experience with DBT (Data Build Tool) or other commercial ETL tools, including model creation, macros, Jinja scripting, hooks, automated tests, snapshots, and DBT packages.
• Snowflake certifications.

Benefits

• Contract of employment.
• Performance bonus.
• Private medical care (ENEL‑MED).
• Employee benefits cafeteria (e.g. MultiSport card).
• Additional parental privileges: baby leave – 6 weeks 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 accrued over years (even 5 extra days per year).
• Wellbeing leave – additional two weeks paid leave after 10 years of service.
• Psychological support consultations.
• Access to e‑learning platforms.
• Internal employee referral program.
• Hybrid working model from Poland with occasional travel to Warsaw office.
• Attractive office location – Gdański Business Center, Warsaw.
• Additional entitlements for people with disabilities – Work Without Barriers.
• Work environment that promotes diversity – Diversity Charter.

Equal Employment Opportunity

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.