Terraform (nice to have)
DBT (nice to have)
programming language (junior)
Data modeling (regular)
SQL (advanced)
We are looking for people who want to tackle Data Modelling and Transformation challenges using a modern technology stack.
Project
Our main goal is to develop a Data Lake platform for a new, highly funded, UK-based, speciality insurance company. We work across two teams : one responsible for ingesting and curating hundreds of datasets from various providers;
the second one creating Data Marts used by analysts, business users and Data Science teams. There are lots of greenfield areas and possibilities to impact the whole company.
Tech Stack :
AWS, Snowflake, dbt, SQL, Terraform, Prefect
Challenges :
Delivering high quality code for data processing and transformation using Snowflake and dbt
Automating and optimising day-to-day work while making sure the process remains reliable
Working closely with Data Architects and Business Analysts to create Data Marts using Kimball Dimensional Modelling
Connecting to multiple data sources and sinks to support complex business processes
Team :
The Data Engineering team consists of around 20 engineers of which about a half are Snowflake and the other half are Scala / Spark engineers.
Many of them are from well known consultancies. Apart from that teams consist of Data Architects, Business Analysts, Product Owner and a Delivery Lead.
What we expect in general :
Strong SQL skills
Dimensional modelling (Kimball)
Strong engineering skills
Demonstrated ability of design, build and implementation of software solutions in Snowflake with an unwavering focus on quality
Ability to work in an agile environment, partnering with team members and peers to find solutions to challenging problems with transparency
Experience of working using CI / CD and DevSecOps approach
We do not expect you to qualify for all of the above points. A good understanding of some of these areas and a willingness to develop expertise in others may be sufficient.
What's on offer?
Private healthcare
Stretching
Training package
Funding of language lessons
Transparent rules of getting promoted - transparent environment that gives opportunities for personal growth, a promotion and a pay rise
Virtusity - in-house training division - knowledge sharing is an important part of our actions so we provide internal workshops and rich knowledge base
Building tech community in Poland - we create a space for the exchange of experience and ideas
Open source initiatives - we contribute to open source projects and enhance software that is used by software developers around the world
Flexibility in projects - we make a room for your autonomy and provide you with mentoring and guidance from the first day
Flexible hours - you decide when you work efficiently
Integration, sport events and tournaments
Office in the center of Kraków, Kielce or Rzeszów and soon in Wrocław, Katowice and Gdańsk
Chillout zones
MacBook with all additional accessories needed