Data Engineering Lead with Snowflake

Leading Data Engineer

As a Leading Data Engineer, you will shape and deliver the Financial Data Hub platform. You will lead a team of Snowflake Data Engineers delivering analytical and operational use cases, make strategic and tactical engineering decisions, ensure platform alignment with enterprise architecture and organisational standards, build scalable, secure, reliable engineering solutions with a focus on automation, collaborate with Product Managers, BAs, Architects, own CI/CD pipelines, platform maintenance, data security posture, and compliance with Aviva Controls, provide daily leadership, coaching, mentoring and oversight of other team members, and drive continuous improvement and engineering best practices across the platform.

Responsibilities

• Lead a team of Snowflake Data Engineers delivering analytical and operational use cases.
• Make strategic and tactical engineering decisions with long‑term impact.
• Ensure platform alignment with enterprise architecture and organisational standards.
• Build scalable, secure, reliable engineering solutions with a strong focus on automation.
• Collaborate with Product Managers, BAs, Architects to align technical delivery with business needs.
• Own CI/CD pipelines, platform maintenance, data security posture, and compliance with Aviva Controls.
• Provide daily leadership, coaching, mentoring and oversight of other team members.
• Drive continuous improvement, standardisation and engineering best practices across the platform.

Qualifications

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

Benefits

• 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

Equal Opportunity

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.