Wat ga je doen
You support our Business Analysis and Data Science teams through your technical expertise and passion for data.
What you tell your friends you do
"I am a data investigator: I question data so I know what happened."
What you will really be doing
How will you be doing this?
- You work on Data Warehouse design, using SQL to build ETL processes based on OLTP sources, and a bit of Python.
- You provide technical support to our team of Business Analysts who provide Actionable Insights to Coolblue via Dashboards and reports.
- You help develop a brand new data warehouse using Kimball.
- You work together with the Product Owner, streamline your personal and team's work methodologies, and develop new design principles.
- You help business analysts to develop queries that are up to a 120 times more efficient.
- You experiment with new technologies, like Google Cloud Platform, and integrate them into your own ideas.
- You coach and provide feedback to your team members.
You'll work in a Scrum team of four to six members. Everyone has their own specialization, including DevOps,SQL Server gurus, and BI engineers. The team is managed by a Team Lead and a Product Owner. One team member (potentially you) also acts as a Scrum Master. Your team works close to 25 Business Analysts and a team of Data Scientists, providing them data structure they can easily use to support company decisions.
What a day in the office might look like
After your morning Scrum standup, Gerard sends you a Pull Request to update a Python script that took an unexpectedly long time to complete. After that, you attend a meeting where David, the Product Owner, asks the team to discuss and design a new architecture for Marketing Cost Allocation. Just before lunch, you pass by Andres, a data scientist who needs help with creating a new table for the BigQuery environment. So, you invite him to have lunch together with your team. On the way back, you share your concerns about the Google Adwords ingest process with David. It's losing records, so you want to refactor some of the python code. You add some automated tests, send the Pull Request to your team mate, Dirk, for review and at 16h30, the improvements are automatically deployed via our continuous integration pipeline. By 17:30, you're done for the day and to the pub for a drink with a few team members.
Required experience & skills
- You have a minimum of five years experience in Data Warehousing and OLAP.
- Agile and flexibility come naturally to you.
- You’re a team player.
- You're willing to investigate what users want and why.
- You think in data structures and Kimball methodology
- You're familiar with continuous integration systems that automate your code deployments.
- You're experienced when it comes to improving your colleagues’ craftsmanship and technical skills.
- You're excited to work in a diverse IT environment: Querying Oracle, deploying a cube on Analysis Services (SSAS), setting up a configuration for a new VM using Vagrant through puppet, uploading data to BigQuery, or setting up a new fact table and dimension structure on SQL Server.
- You get extra points if you've worked as a SQL Server DBA and/or really know the ins and outs of the query engine.
- You're willing to relocate to Rotterdam, or nearby.
- 25 leave days. As long as you'll promise to come back.
- Relocation assistance, from A to Z (If you live abroad).
- Dutch language courses. To help you become a Rotterdammert.
- Over 30 courses at our own Coolblue University.
- Discount on a new bicycle. Because that's how we roll.
- A 10% discount on all of our products.
- Travel allowance and a retirement plan.
- An office at the best possible location. It's only a hop and a skip away from Rotterdam Central Station. Or a 2-minute walk. Plenty of restaurants around.
- An awesome workplace. With freshly prepared meals, monthly TGIF drinks at our own bar, epic Coolblue parties, extra-curricular activities, and an informal, playful office space.