Programming and Development
Permanent | Full Time
Senior Data Warehouse Engineer
King is the worldwide leader in mobile gaming, with more than 2 billion USD in yearly revenue and 340 million monthly active users thanks to brands like Candy Crush Saga.With 14 Petabytes of data and dozens of billion events generated every day, data at King is in the heart of the business. The Shared Tech organisation at King - split across Barcelona, London and Stockholm - is responsible for processing all the data we receive each day and to use it to drive all of King's data and analytics needs.You will be part of the Core Data Services team, in charge of providing data products and services to our Marketing, Advertising and Finance stakeholders. You will help develop new features and products, as well as maintaining the existing ones, working in very close collaboration with our users and your colleagues in a fast evolving and agile environment.
Your role within our Kingdom
You will engage directly with our Marketing and Advertising stakeholders to understand their business functions and their data needsYou will work in a highly collaborative team to devise solutions to business problems, bringing your skills and ideas into every discussionYou will contribute to the solutions both at the backend of the data pipeline, from the ETL to data modelling, as well as the front end on our self-service BI productsYou'll take ownership and responsibility for the quality of the solutions, testing them and ensuring best practices are used throughout the development process - particularly with regard to self-explanatory code, maintainability and scalabilityYou'll learn new technical skills when needed and use them to help the team achieve successYou will collaborate with other teams within the Shared Tech organisation to ensure the consistent and coherent growth of our data capabilities
Skills to create thrills
Relevant experience in a similar role.
Ability to work autonomously and coach more junior engineers on best practice techniques
Can write high-quality and super-efficient SQL in your sleep, and can optimise a complex SQL query standing upside-downAre comfortable creating and maintaining ETL jobs in both GUI and shell script environments
Experience working with massively parallel processing technologies (e.g BigQuery, Hadoop)
Integrating 3rd party data sources using APIsFamiliar with different data modelling techniques (e.g Star schemas, 3NF)
Ability to translate business needs into technical specificationsExperience of Business Intelligence (BI) tools such as Looker, Tableau or QlikView
Experience of digital marketingExperience in Apache Airflow or Google Cloud Composer
Experience working in an Agile workplace
A great saga needs diverse heroes
Making games is fun.
Keep Calm and waka waka...