Senior Data Engineer

As a Snowflake Senior Data Engineer at Aviva you will be responsible for building and maintaining scalable data pipelines and infrastructure to support data-consuming applications. You possess advanced skills in data engineering, software development, and system architecture. 

We are searching for experienced Data Engineer who can demonstrate:

What we are looking for:

Ideally:

• Proficiency in Snowflake scripting – Snowflake development.
• Experience in using Snowpark.
• Knowledge of ETL / ELT and Snowflake architecture.
• Knowledge of various file formats (Parquet, JSON, YAML)
• 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.
• Understanding Snowflake concepts like data sharing, replication, dynamic data masking 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.
• Knowledge of Apache airflow to schedule pipelines.
• Understanding basic principles of data structure and data modelling.
• Knowledge of Azure Devops pipelines, agents, repos.
• Understanding of AWS services S3, EC2, EMR, Lambda
• Qualifications nice to have: Snowflake certifications.
• Experience with software engineering best practices such as design patterns, code review, testing, and documentation.
• Understanding of software development lifecycle (SDLC) methodologies like Agile or Scrum.
• Excellent communication skills with the ability to collaborate effectively in multinational teams including the main stakeholders, data analysts, and software engineers (gather requirements, prioritize tasks, and deliver solutions)
• Demonstrated ability and willingness to learn new technologies and adapt to evolving tools and practices in the data engineering ecosystem.

What you will be doing:

• You will be building data pipelines using Agile approach
• You will be Snowflake scripting
• You will be transforming data using DBT
• You will be programming in Python
• You will be Providing guidance on best practices and sets up standards in development, mentoring less experience developers and reviewing their codes

In Aviva Services Excellence Centre, we provide:

• Contract of employment

• Performance Bonus

• Private medical care (ENEL-MED)

• Emotional support consultations

• 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

• Access to the e-learning platforms

• Internal employee referral program

• Possibility to work remotely

• 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

Do you see yourself in Aviva Services Excellence Centre? Be sure to apply!

Aviva is for everyone!

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.