Position: Business Intelligence (BI) Engineer
Company: Gelato
Experience required: 3y
English level: upper

**About Us**
Gelato has built the world's largest and most global network for on-demand production of customized items e.g. t-shirts, wall art, mugs, books, hoodies, and cards. We support a new wave of e-commerce entrepreneurs and the global shift towards local and more sustainable production.

In many ways, we at Gelato are rethinking how digital fabrication of customized products can be done on-demand. Just imagine what will happen when we add 3D printing capabilities to this global service. We are already empowering thousands of e-commerce entrepreneurs to grow and scale their businesses.

**Gelato Engineering**
We own no physical production assets, nor servers, instead our asset is a cloud-based connectivity platform that enables world-class on-demand production for e-commerce platforms and applications. This engineered platform needs to provide our customers access to more than 100 production partners in 32 countries and includes production plate design, routing to an appropriate partner, finally linking to logistics systems for delivery to the consumer. All this in 72 hours and reaching more than 5 billion people and potential consumers in a smarter, faster, and greener way.

We have a multicultural Engineering team of over 50 people working in 5 countries who build, grow and maintain our applications and platform. Our engineering landscape provides the technology to extend our capabilities and features across 3 customer-facing applications: Optimalprint, Globe, and Gelato API plus the digital connectivity platform. The employed technologies range from backends using PHP and GoLang to mobile apps built natively or with hybrid technology, running on cloud services and with a modern CI/CD pipeline.

We are flexible on location and building our teams in Norway, Estonia, Sweden, Russia, Ukraine,  UK, India, Pakistan and Spain. 

**What you will be doing**
- Responsible for the design, development, testing, implementation, and maintenance of BI solutions
- Develop next-generation operational and financial metrics or dashboards tailored to client needs.
- Extract, transform and combine data from multiple sources to deliver insightful BI to support business decision making.
- Ensure data quality, completeness, and accuracy across the data lake.
- Troubleshoot and support existing business intelligence solutions.
- Collaborate with team members in code reviews, discovering better practices and patterns and continuous improvement.
- Work with engineering and product teams distributed across multiple locations.
- Collaborate with engineering and product teams distributed across multiple locations to gather data and metric requirements, identify areas of improvement, and establish best practices.

**Who you are**
- Graduate with a Degree in Finance, Engineering, Computer Science, or quantitative field.
- Relevant experience in business intelligence or business analyst roles, including data warehousing and business intelligence tools.
- Strong Proficiency in SQL including a solid understanding of how to optimize query performance. Experience with manipulating large data sets in a database.
- Minimum 3 years experience working with standard BI and visualization tools like Looker, PowerBI, Tableau, Datastudio, or similar.
- Advanced proficiency in Excel (including VBA, Pivot Tables, array functions, Power Pivots, etc.)
- Analytical thinker and team player, a self-starter, willing to take responsibility for problem-solving.
- Demonstrated ability to meet deadlines while managing multiple projects.
- Excellent communication and presentation skills working with multiple peers and with different levels in the organization.
- Aptitude to learn new technologies and analytical methodologies relating to business intelligence and data analysis
- Good to have computer programming experience in Python, Ruby,  Golang, or Java

**You’ll get to work with:**
- Consumer-facing, as well as core platform, finance, and distribution business units
- Marketing and product teams, across to our engineering teams
- Modern infrastructure on cloud (Kubernetes, AWS, GCP)

**What we offer**
We offer you a chance to be part of a truly amazing journey in a company that sets very high targets and works hard to achieve them. You will be able to work with smart, motivated, and engaged co-workers from all over the world, in an intense and very energetic environment. This leads to you having a tangible impact on the way that we operate and expand our business.

Some of the highlights of the package include:

- Strong technical culture of continuous innovation and improvement
- Chance to become a shareholder of Gelato!
- Flexible festive holidays, swap days off according to your values and beliefs.
- Work at one of our hub city offices or even remotely 
- And much much more!

**To Sum Up**
As we continue to grow we want you to grow with us and for the right candidate, there is no limit to where this opportunity might take you. Together we can increase global GDP by effectively supporting local sustainable on-demand production.