Mister Spex

Mister Spex

Berlin, DE

Business Intelligence Engineer (m/f/x)

Your Impact

We in the Business Intelligence 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.

We support many departments of the company and think of ways in which data can help them and try to make ways to get meaningful insights as easily as possible.

The company is data-driven by heart, so your work will change the daily business.

Job Description
* Be enthusiastic in modelling a traditional Data Warehouse driven by commercial numbers but at the same time being passionate about using and developing Azure services to drive our future BI stack.
* 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.
* Take a driving role in projects to ensure all requirements, including security and performance.
* Build ETL and ELT pipelines to integrate data from internal and external partners.
* 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.
* Partner with our Data Scientist Team to integrate new tools and data models into the DWH environment.
* Proactively improve processes, monitoring and troubleshooting our BI solutions.

* Ideally 3 years of experience as a BI/DWH developer or Data Engineer.
* Strong T-SQL / SQL skills, with proven ability to code effectively.
* Practiced and proficient in ETL procedures, data migration, integration, or data quality concepts.
* Proven knowledge of Microsoft BI solutions: SQL Management Studio, SSIS, SSAS (tabular and multidimensional) is required.
* Speak English fluently and German is a Plus.
* Able to work independently with extreme user-orientation.

What we offer
* 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 remote working envireonment, 10 days paid vacation for childcare and sabbatical options
* Warm and international culture based on respect, collaboration and giving your ideas a spotlight!

More about Mister Spex

We are transforming the optical industry. Ready to join the revolution?

With our consistent digitalisation strategy, we have significantly changed an entire industry and established a new way of buying eyewear. We have created optimal links between contemporary e-commerce solutions and traditional brick-and-mortar retail. This success has come hand-in-hand with our rapid growth and makes us one of the most innovative employers in the industry. Our spirit of innovation is your chance to shape the traditional market and change it for good.

Our diverse teams from over 50 nationalities are the focal point of Mister Spex and they are what makes our environment so dynamic. We treat every new applicant on an equal footing and live by the principle of equal opportunities, regardless of origin, skin colour, gender, age, sexual orientation, religion, disability, political opinion or any other characteristic.