Data Engineer with Snowflake
Aviva Investors2 months ago
Warsaw, PolandEntry Level / Mid Level
Responsibilities
- Design, develop, and optimize scalable data pipelines using Snowflake and modern data stack tools.
- Collaborate with cross-functional teams to understand data requirements and deliver robust solutions.
- Implement data modeling, performance tuning, and cost-efficient Snowflake architecture best practices.
- Conduct code reviews and produce high-quality, maintainable, and secure data engineering solutions.
- Ensure data quality, reliability, and security throughout the data lifecycle.
- Automate data workflows and integrate diverse data sources into Snowflake.
- Monitor and troubleshoot pipeline issues to maintain availability and performance.
Requirements
- Approximately 2–3 years of experience in a relevant role.
- Experience with Snowflake scripting, including stored procedures using PL/SQL or Python, user-defined functions, common table expressions, and window functions.
- Knowledge of ETL/ELT processes and Snowflake architecture.
- Knowledge of Parquet, JSON, and YAML file formats.
- Understanding of Snowflake features including data sharing, replication, dynamic data, masking policies, secure views, row access policies, tags, streams, tasks, external tables, time travel, cloning, storage integrations, stages, clustering keys, and role-based access control.
- Familiarity with Git branching, repository cloning, pull requests, conflict resolution, and code reviews.
- Understanding of data structures and data modeling fundamentals.
- Knowledge of Azure DevOps and/or AWS services; AWS Glue experience is preferred.
- Experience with software engineering best practices including design patterns, code review, testing, and documentation.
- Fluent English communication skills.
- Nice-to-have experience with Apache Airflow, Snowpark, dbt, Jinja scripting, dbt macros, hooks, automated tests, snapshots, packages, commercial ETL tools, or Snowflake certifications.
Benefits
- Contract of employment with a performance bonus.
- Private medical care through ENEL-MED and a cafeteria benefits system such as a MultiSport card.
- Additional parental benefits, including six weeks of leave for a second parent and shortened working time after parental leave.
- Employer-funded group insurance and an Employee Shares Plan.
- Extra birthday day off, paid volunteer leave, and additional leave accrued over time.
- Two weeks of paid Wellbeing Leave after 10 years of service.
- Psychological support consultations and access to e-learning platforms.
- Internal upskilling programs, self-development time during working hours, a career path, and an employee referral program.
- Hybrid work from Poland with a few days per month in the Warsaw office.
- Inclusive and accessible work environment with additional entitlements for people with disabilities.
About Aviva Investors
Aviva Investors is the global asset management business of Aviva plc, headquartered in London and founded in 2008. It manages fixed income, equity, real assets, multi-asset, and alternative strategies, including ESG-oriented mandates, for institutional, wholesale, and retirement clients worldwide. Its business model centers on management and performance fees from pooled funds and segregated mandates across global markets.