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?
As a Leading Data Engineer you will play a pivotal role in shaping and delivering the Financial Data Hub platform.
What will you be doing?
Leading a team of Snowflake Data Engineers delivering analytical and operational use cases.
Making strategic and tactical engineering decisions with long‑term impact.
Ensuring platform alignment with enterprise architecture and organisational standards.
Building scalable, secure, reliable engineering solutions with a strong focus on automation.
Collaborating with Product Managers, BAs, Architects to align technical delivery with business needs.
Owning CI/CD pipelines, platform maintenance, data security posture, and compliance with Aviva Controls.
Providing daily leadership, coaching, mentoring and oversight of other team members.
Driving continuous improvement, standardisation, and engineering best practices across the platform.
What we’re looking for?
Deep hands‑on experience with Snowflake, including advanced capabilities such as Dynamic Tables, Snowpipe Streaming, Cortex AI, data sharing, replication, secure views, masking policies, row access policies, tags, streams, tasks, external tables, time‑travel, clone, stages, and storage integrations.
Proficiency in Snowflake scripting (stored procedures in Python/SQL, UDFs, CTEs, window functions).
Experience designing reusable frameworks, UDFs, and components using Snowpark or SQL.
Good understanding of reliability patterns and performance optimisation for large‑scale data workloads.
Proficiency in Python, SQL, and Airflow for orchestration and scheduling.
Experience with ETL/ELT development, automation, and monitoring frameworks.
Strong understanding of data modelling, data structures, and DBMS platforms (Redshift, Postgres, etc.).
Experience implementing data quality rules, validation frameworks, and robust testing approaches.
Familiarity with Git (branching, cloning, pull requests, conflict resolution, code reviews).
Understanding of SDLC, CI/CD, and modern engineering practices, including Azure DevOps pipelines, agents, and repos.
Knowledge of data formats such as Parquet, JSON, and YAML.
Experience integrating data pipelines with cloud services and storage layers.
Nice to have:
Hands‑on experience with dbt (models, macros, Jinja scripts, hooks, automated tests, snapshots, and dbt packages).
Strong expertise in AWS, cloud‑native architectures, and serverless/data‑pipeline design and cloud cost optimisation approaches (AWS Glue experience is preferred).
In Aviva Services Excellence Centre, we provide:
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 leaveEmployer-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
Do you see yourself in Aviva Services Excellence Centre? Be sure to apply!
Aviva is for everyone!
We’ve been ranked the #1 Best Workplace in Poland and #5 for Women by Great Place to Work®! Join a place where you’re empowered to grow, thrive, and shine bright!
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.
Skills Required
- Deep hands-on experience with Snowflake and advanced Snowflake features (Dynamic Tables, Snowpipe, data sharing, replication, secure views, masking/row access policies, streams, tasks, external tables, time-travel, clone, stages, storage integrations, tags)
- Proficiency in Snowflake scripting (stored procedures in Python/SQL), UDFs, CTEs, window functions
- Experience designing reusable frameworks and components using Snowpark or SQL
- Proficiency in Python and SQL for data engineering
- Experience with Airflow for orchestration and scheduling
- Experience with ETL/ELT development, automation, monitoring frameworks, and performance optimisation for large-scale workloads
- Strong understanding of data modelling, data structures, and DBMS platforms (Redshift, Postgres, etc.)
- Experience implementing data quality rules, validation frameworks, and robust testing approaches
- Familiarity with Git workflows (branching, pull requests, conflict resolution, code reviews)
- Understanding of SDLC, CI/CD and experience with Azure DevOps pipelines, agents, and repos
- Knowledge of data formats such as Parquet, JSON, and YAML
- Experience integrating data pipelines with cloud services and storage layers
- Proven leadership experience: team leadership, coaching, mentoring, and driving engineering best practices
- Hands-on experience with dbt (models, macros, Jinja, automated tests, snapshots) — nice to have
- Strong expertise in AWS, cloud-native architectures, serverless/data-pipeline design and cloud cost optimisation (AWS Glue preferred)
What We Do
Aviva is a multinational insurance and financial services company, offering a diversified range of products including insurance, wealth management, and retirement solutions. It is the UK's leading diversified insurer.
