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 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.
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.