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. 2-3 years of experience in a relevant role.
Experience in Snowflake scripting - stored procedures (PLSQL or python), user defined functions, Common Table expressions, Window functions.
Knowledge of ETL / ELT and Snowflake architecture.
Knowledge of various file formats (Parquet, JSON, YAML).
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.
Familiarity with git concepts like creation of branches, cloning of repo, creation of pull requests, resolving conflicts, code reviews.
Understanding basic principles of data structure and data modelling.
Knowledge of Azure DevOps and/or AWS services (AWS Glue experience is preferred).
Experience with software engineering best practices such as design patterns, code review, testing, and documentation.
Fluent English.
Nice to have
Knowledge of Apache airflow to schedule pipelines.
Experience in using Snowpark.
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.
Snowflake certifications.
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 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
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 for a second year in a row and a top choice for Millennials by Great Place to Work®!
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.
