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! As a Senior Data Engineer, you will be responsible for designing, building, and maintaining scalable data pipelines and infrastructure to support data-driven applications. You should have strong expertise in data engineering, software development, and system architecture.

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?

• Develop scripts using SQL and Python.

• Work with Informatica to extract, transform, and load (ETL) data.

• Automate data workflows and processes.

• Support changes in the existing ecosystem and participate in migrating legacy tools (Visual Basic, Informatica) to Snowflake and dbt.

• Design and develop scalable data pipelines, troubleshoot data issues, and ensure high availability and performance.

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

• Ensure data quality, reliability, and security across all stages of the data lifecycle.

• Conduct code reviews to maintain high-quality, secure, and maintainable solutions.

• Mentor data engineers and contribute to the team’s technical growth and standards.

What we’re looking for?

• Approx. 5 years of experience in a relevant role.

• Hands-on experience with Informatica.

• Advanced proficiency in Python and SQL.

• Knowledge of VB6 (legacy systems).

• Proficiency in Snowflake scripting - stored procedures (PLSQL or python), user defined functions, Common Table expressions, Window functions.

• Experience in using Snowpark.

• 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

• DBT (Data build tool) hands on experience in creating models as per requirements, using macros, jinja scripting, hooks, automated tests, snapshots, DBT packages.

• Strong understanding of ETL/ELT tools and processes.

• Familiarity with Git concepts (branching, cloning, pull requests, conflict resolution, code reviews).

• Understanding of data structures and data modelling principles.

• Knowledge of various file formats (CSV, Parquet, JSON, YAML).

• Experience with Azure DevOps (pipelines, agents, repos) or AWS services.

• Strong foundation in software engineering best practices, SDLC methodologies (Agile/Scrum), and active participation in Agile ceremonies.

• Excellent communicator with proven experience working in multinational, cross-functional teams and partnering with technical and non-technical stakeholders.

• Ability to translate business requirements into effective technical solutions through close stakeholder collaboration.

• Proactive self-starter who is open to continuously learning and adapting to evolving data engineering tools and technologies (e.g., Snowflake, dbt).

• Experience leading or mentoring less seasoned team members, providing guidance on best practices, code reviews, and technical skills development.

• Fluent English.

Nice to have:

• Experience with Apache Airflow.

• Familiarity with C#.

Location: Poland - Warsaw - ASEC