Data Warehouse Developer

Description
As our new Data Warehouse Developer you will be a part of the team responsible for maintenance and further development of the existing company data warehouse system in cloud environment (AWS), which acts as a single point of truth for making data driven business decisions. The work will consist of data modelling and data transformation design, development of new and improving existing data load processes, ensuring that the data warehouse has the best architecture, data quality, and that the system is performant, scalable & maintainable, while processing high volumes of data and executing complex ETL and reporting queries. As part of your responsibilities you will also be expected to review and develop further current technology stack and ensure the use of industry and business best practices.


What will you get up to day to day?
Propose and build re-usable solutions, develop and maintain processes while applying best practices to maintain Data Load to/from upstream/downstream systems
Design and extend further existing data warehouse model
Design and develop: - Data load ETL / ELT processes with large and complex data sets, making sure the solution is maintainable, built with reusable components and with optimal performance - Reporting layer data sources and BI reports for data delivery to business - Data / reports delivery automation - Integration / data load processes from/to different upstream/downstream systems
Follow and apply best practices while building the data model, data warehouse data load processes and reporting framework maintaining efficiency and robustness of the process.
Design data structures and data load processes for optimal performance and scalability
Focus on data quality assurance, verification of accuracy and consistency of data
Maintain and support data load processes ensuring regular loads on time
Troubleshoot and resolve issues with the data warehouse and external data feeds
Support, assist, establish and maintain appropriate communication channels with business users in the context of company data assets
Performing ad hoc data analyses when required
Maintain and promote collaboration with other technical teams responsible for upstream/downstream systems
Maintain transparent communication within the team / other business departments within the company
Participate in brainstorming meetings to discuss existing issues and new ideas
Participate in daily / weekly team meetings
Develop further current skill set both from technological and soft skills perspective



Requirements
What experience do you bring?
4+ years of extensive Data Warehouse/Data Integration focused work experience
Hold an academic degree in a quantitative discipline such as statistics, computer science or mathematics
Strong experience in designing and managing large Data Warehouse, minimum 1TB
Advanced knowledge and understanding of data warehouse concepts (such as Kimball or Inmon methodologies)
Strong experience in business analysis and requirements gathering from business users
Experience with columnar databases such as Amazon Redshift, Big Query or similar is desired
Experience with AWS or GPC cloud platform services is desired
Experience with big data solutions in cloud environment will be considered an asset
Extensive hands on experience using one of the mainstream data integration products such as Talend or similar
Experience in managing semantic layer of Business Intelligence/Analytical platforms such as Tableau or similar is desired
Extensive experience in SQL query writing and optimization experience
Strong experience of the mainstream DBMS like MySQL, PostgreSQL etc.

And what kind of person are you?
Ability to obtain, analyse and synthesize information from multiple sources
Strong problem-solving skills
Comfortable working in a fast-paced environment whilst interacting with a variety of different disciplines
Proven ability to prioritise and deal with problems systematically and provide clear communications regarding the issues, resolution times and solutions
Keen attention to detail and data quality
Fluent in English

& then some nice to haves...
It would be a great asset if you have previously worked with big data solutions in a cloud environment and on supporting a Data Warehouse system within the iGaming industry.
Knowledge of Python or have experience on supporting a data warehouse system this would be considered a plus!



Benefits
At ComeOn Group we put a lot of trust in every individual, we know that if we get the tools and space to do what we do best, we will be both happy and deliver great things. This is why we have some of the greatest minds in the industry working here.
Working hard also means that we need to be able to recharge our batteries once in a while, this is the reason why we want our office atmosphere to be relaxed and cosy, come by and challenge us in a game of ping pong or Fifa and if you're not into that, a studio session at the local gym or a cold drink from the fridge on a Friday late afternoon might be your type of melody.
I’m interested, what do I do next?
Waste no time and complete your application expressing your interest and why you want to work for us today, we like individuality so let your personality come through!
Applications might take a few weeks to review so please stay cool. We shall get back to you ;)