Data Warehouse Specialist

Job description

Are you a data enthusiast with strong experience in data warehousing? Do you have a practical mindset and strong attention to detail? Are you eager for an opportunity of learning more about performance-based marketing and contribute to the growth of our scale up company? If so, we have the perfect job opportunity for you.

As a Data Warehouse Specialist, you will work with our current data warehouse in Microsoft SQL Server together with our internal ETL tool. Your main challenge will be improving and developing a better Data Warehousing and BI solution using modern cloud-based technologies. You will get the freedom to assess our current infrastructure, evaluate different tools available (whether it is Azure or Amazon or any other tool) and proceed with the best solution that suits the business need. We always try to use the right tool for the right job and are open for new technologies. You will use your expertise and selected tools to create new database architectures, build the ETL processes, and set up the infrastructure (in the cloud).

No week will be the same, because you are working on many different projects. One day you are setting up a cloud infrastructure, the other you are developing some new functionalities in SQL and another you're learning about a new technology like Chef, Ansible or Puppet. You’re the go to person when a colleague or client has a tech related problem or question, which you love to help and explain, spread the tech enthusiasm.


  • Drive projects to improve our Data Warehouse and ETL processes using Microsoft Stack and Azure Cloud technologies.
  • Maintenance and development of the SQL server data warehouse, including but not limited to data quality, data pipeline integrations, new data source synchronizations, query optimizations, etc.
  • Develop practices for efficient design, deployment and documentation of our BI environment.
  • Work together with our product teams to improve the quality of our database.
  • Work together with different stakeholders to understand the business processes and translate them into powerful Business Intelligence solutions.
  • Maintain and improve the monitoring and refinement of data models and reports.
  • Keep up to date with the developments in the source systems and recommend opportunities for an enhanced Data Warehouse.

    About us

    At Creative Clicks, we breathe entrepreneurial air. This isn’t optional, it’s an absolute necessity. Started in 2009, we now work with more than 120 employees within 6 offices worldwide and we are active in 65+ countries across six continents. Still, we are one team, with one dream: building the largest mobile marketing platform in the world. We have mastered the science of mobile performance-based advertisement and bring outstanding return on investment for our publishing and advertising partners. We identify opportunities in the field of mobile performance-based marketing and execute them internationally via our unparalleled marketing and distribution network.

    How we do this? We believe everyone is unique. So: be you. Our success is a result of our Triple E Philosophy. Be the Energetic and Entrepreneurial Expert. Dream big, everything is possible. We give our people autonomy and accountability, without internal politics. And we celebrate our successes together, every day.

    What do we offer you?

    We would also like to offer you an international and innovative environment and freedom to contribute your own inspirations. Working at Creative Clicks means working in a very ambitious environment with a lot of responsibility. It is a place to learn, experiment, discover and develop yourself in a fast-growing company. The results are important, but that is another great part too! We celebrate our successes with boat trips, parties and weekly Friday drinks on our roof terrace! Also, the perfect place for our fresh lunches. Who would not want to work in a beautiful office in the heart of Amsterdam?

    Job requirements

    • Bachelor or master's degree in Computer Science, Engineering or any related field of study.
    • 4+ years of experience as a data warehouse specialist or equivalent position, working with Business Intelligence solutions, data integrations and ETL pipelines.
    • Expert level on data warehousing and data modelling.
    • Expert in SQL. Experience working in Microsoft SQL Server is strongly preferred.
    • Strong understanding of server maintenance tasks (performance optimization, indexing, backups, access management, etc.).
    • Experience with Cloud-based environments (Azure, AWS, etc.).
    • Previous experience working with Scrum/Agile methodologies.
    • Experience working with Azure Analysis Services and SSAS Tabular models is strongly preferred.
    • Being able to translate business needs into future-proof data models.
    • Knowledge in other programing languages as Python or R is a plus.
    • Experience integrating end-to-end automation processes is a plus.
    • Self-motivated and comfortable operating in a rapidly changing environment.
    • Great attention to detail.
    • You see the opportunity in situations where others would see a setback.
    • You are a ‘fixer’, think outside the box and are not afraid to try new things that you never did before.