Are you a data enthusiast with strong experience in data warehousing and eager for an opportunity to learn more about performance-based marketing? If so, we have the perfect job opportunity for you.
Our new Chief Data is looking to expand his team with bright-minded specialists, in this case, we are looking for our new Junior Data Warehouse Specialist. A new role in an existing team that is rapidly growing. To give some insights into the job, your time will be divided into parts of 30-70. Where 30% are day-to-day data related use-cases presented by colleagues or clients, your main challenge will be improving and developing our Data Warehouse in Microsoft SQL Server, optimize the internal ETL tool and create innovative BI solution using modern cloud-based technologies. You have the freedom to assess our current infrastructure, evaluate different tools available (whether it is Azure or AWS or any other tool) and proceed with the best solution that suits the business. We always try to use the right tool for the right job and are open to new technologies, ideas and solutions. Your expertise and research will contribute to new database architectures, ETL processes, Cloud Architecture.
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 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.
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.
2+ years of relevant work experience in Analytics, Business Intelligence, or Data warehousing
Fluency in SQL(Microsoft SQL Server) and ETL using big data tools
Strong understanding of server maintenance tasks (performance optimization, indexing, backups, access management, etc.).
Experience with Cloud-based environments (Azure, AWS, etc.).
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 programming languages as Python or R is a plus.
Self-motivated and comfortable operating in a rapidly changing environment.