What makes us unique is the combination of optometry and tech. We are looking for tech talents who want to join us in disrupting the market with new digital solutions. Everything we develop is designed to help our customers find the perfect glasses or sunglasses easily, quickly, and with fun and joy, in the online shop as well as in person.
With innovative technology and agile methods, our development and product management teams are hard at work continuously optimising the customer journey and also growing their own knowledge and expertise. If you are passionate about innovation and think of yourself as an ambitious and resilient self-starter, we would like to see you at #teamspex!
We in the BI team help to connect the dots in the company, by combining all the necessary data sources to create a customer centric DWH serving various departments with their KPIs, reports, and Ad hoc analysis.
Be enthusiastic in modelling a traditional Data Warehouse driven by commercial numbers but at the same time passionate about using and developing Azure services to drive our future BI stack.
Benefits
- Yearly voucher for a pair of glasses and up to 40% discount on our products
- Relocation assistance and help with costs and visa
- 50% subsidy for public transport
- Highly skilled colleagues building innovative systems
- Flexible working hours, 10 days paid vacation for childcare and sabbatical options
- Warm and international culture based on respect, collaboration and giving your ideas a spotlight!
Job Description
- Consult with the business and gather requirements to maintain and improve the existing BI solution.
- Understand KPIs for the needs of various departments and program them for daily availability.
- Build ETL and ELT pipelines to integrate data from internal and external partners.
- Understand and connect various data sources through ETL processes and scripts.
- Aggregate and combine data to shape the central Data warehouse
- Develop T-SQL code to query complex database environments.
- Develop a data model that allows accurate and consistent reporting and self-service analysis.
- Development and maintain database systems, specifically Microsoft SQL Server databases.
- Proactively improve processes, monitoring and troubleshooting our BI solutions
Qualifications
- 4 years of experience as a BI/DWH developer
- Strong T-SQL / SQL skills, with proven ability to code effectively
- Practiced and proficient in ETL procedures, data migration, integration, or data quality concepts
- Expert knowledge of Microsoft BI solutions: SQL Management Studio, SSIS, SSAS (tabular and multidimensional) is required
- Knowledge of Azure, cloud environment, basic administration, and troubleshooting is required
- Speak English fluently
- Able to work independently with extreme user-orientation