Data Engineer

About the team

The Data and Analytics unit’s main responsibility is to enable the use of data in If. We build data products, develop data & analytics platforms for the Private, Commercial, and Claims business areas. We are responsible for data lake, data warehouse, analytics, and business intelligence solutions. Our overall data platform is a cornerstone in If’s data strategy, and we work according to agile development principles with product owners and scrum teams. You will be joining a unit with more than 60 enthusiastic developers, engineers, architects, and managers. Our squads are mostly located at the If offices in Turku, Espoo, Stockholm, Oslo, and Riga. You will be working in a data squad inside the Data and Analytics unit.

What are you going to do?

•    You will build, maintain, and monitor state-of-the-art cloud-based analytics solutions. 
•    You collaborate with data engineers and data scientists on building production-ready solutions and defining best practices. 
•    You contribute to defining data & analytics target architecture and roadmap. 
•    You secure good relations with internal customers and other stakeholders.

What do we expect from you?

Must have

•    We are looking for someone with extensive SQL knowledge and experience. 
•    Experience with dbt is essential. 
•    You should be fluent in English and possess good communication skills.
•    You will be a great fit for the role if you enjoy working as part of a team, but you're also happy to design and develop solutions on your own. You push your team forward on best practices and ways of working and you enjoy working with people from different backgrounds.

Nice to have

•    It is beneficial if you have experience with dbt and other programming languages like Python or .Net (C#). 
•    Familiarity with modern cloud-based data and analytics solutions, preferably on Microsoft Azure and/or Databricks 
•    It is a plus if you have previous experience in developing, deploying, and owning batch and real-time data pipelines, preferably using Databricks, Data Factory, and dbt.
•    Experience with CI/CD and ADO pipelines is appreciated.
•    If you have previous experience with resource deployment using Terraform, PowerShell, Bash, or experience in implementing processes supporting data transformations, metadata, and data governance – you are of extra interest to us!

Our promise to you

•    Monthly salary: 3300 - 4500€ gross depending on your qualifications
•    Various financial benefits: annual bonus, discounts on our products for you and your family, gifts, etc.
•    Job location: Riga (hybrid working model)
•    Extra vacation days
•    Compensation for an ergonomic home office
•    Strong company culture: company events, interesting speakers, and other inspiring initiatives
•    Career and development opportunities in the biggest insurance company in the Nordics
•    Challenging and exciting projects with autonomy to plan own tasks
•    A recently renovated office in Riga centre with a 24/7 gym on the premises
•    Business trips to Nordic countries