BI Developer Intern (Merchant), Summer 2023

Company Description

Wolt is a technology company that makes it incredibly easy to discover and get the best restaurants, grocery stores and other local shops delivered to your home or office. Wolt is not just a delivery app – we’re a technology company building a commerce platform to seamlessly connect our millions of customers with thousands of merchant and courier partners, in real-time across 23 countries and 250+ cities. Our apps (iOS and Android) have the industry’s highest ratings, largely thanks to our customer-first-mindset, which shows in how we build products and run operations. In June 2022 we officially joined forces with DoorDash. Combined, we have a presence in 27 countries, 23 of which operate with the Wolt brand and app. Wolt and DoorDash continue largely independently, with Wolt’s name, brand, product, technology and team.

Working in Product Development at Wolt

At Wolt, we’re about getting things done. You’ll probably enjoy it here if you like taking ownership, developing yourself and being around friendly, humble and ambitious people. 

The behind the scenes of Wolt is run by an awesome bunch of over 400+ planners, builders, designers and data crunchers. We call ourselves Product+, as we’re the very core of Wolt’s products, tools and platforms. To build our products, we work in over 40  cross-functional, independent and autonomous teams. Teams are made up of a mix of talented individuals: engineers, designers, data scientists, analysts, and product leads. Each team takes ownership for solving customer problems in the best possible way.

Our Commitment to Diversity, Equity & Inclusion

We want to have all sorts of people in our team – people like you and me, and people different from you and me. To be able to work with diverse teammates – when it comes to gender, age, ethnicity, life background, sexual orientation, political views, religion, or any other personal trait – we consciously aim to offer equal opportunity for everyone to work with us. This is because we believe diverse teams make the most thought-through decisions and build things in the most inclusive way.

Join us today to build Wolt together!

#LI-ZF1

Job Description

About the program

The program will last for 4-6 months — you can decide the duration within this frame. The start date of the program is set for June 2023 (we can be flexible here).

The internship is paid (3300€/month) and you’ll be assigned to our Merchant group where your existing skills will find their best match in terms of mentorship and tech.

We are preferring candidates who are able to continue full-time after the internship period, so this is truly a chance for a career path - today we have numerous members in different product teams who originally started as interns!

Analytics at Wolt is a business-critical area that covers three different teams — data science, product data analytics, and business intelligence. The complexity of online delivery, differences between the economics and dynamics of the cities we operate in and vast amounts of data make our work truly interesting!

About the team

As a BI developer intern, you’ll join our awesome analytics team of BI developers and Data analysts. You’ll be exposed to various business metrics related to merchants from a B2B point of view and build reporting infrastructure that can help these businesses grow on Wolt. During the internship, your role will be to work on one of the Merchant group's projects together with a couple of teammates, who will also serve as your onboarding buddies.

The Merchant team is responsible for all data needs related to the Merchant domain and helps various product teams in setting up the right metrics and enabling data-driven decision-making.

You will be embedded in the Merchant product team along with your teammates. This means you will work as close as possible where the decisions are made, and hence get to participate in decision-making yourself.

Your responsibilities

• Working on all sorts of Merchant related data, which involves maintaining and building data pipelines with Airflow and exposing the data in our data warehouse (Snowflake) and providing data in an understandable, ready-to-use format in Looker (our BI tool).

• Implementing business metrics and KPIs to create visibility on business or product performance.

• Exposing new data points from Snowflake to Looker in an easy-to-use format for further analysis and dashboard development.

• Cooperation with other BI developers, analysts and data engineers at Wolt, as well as more direct project-related stakeholders within the Merchant domain.

• You would have a chance to contribute to a variety of projects, such as:

• Building data pipelines for our Merchant Insights tool, where we provide valuable information for our Merchants about their performance
• Helping our product teams to collect vast amounts of app analytics data and turn that into insights about the new product features.
• Creating pipelines for possible 3rd party integrations and developing ways to connect that data to our data

Qualifications

We use SQL for data collection and processing, and Python for managing this data flow within our data warehouse. Most of the work during the internship relies on the former, thus SQL knowledge is also tested in the application phase. We also hope that you are familiar with the basics of Python or a similar language.

Studies in a relevant field (programming, mathematics or finance) might be helpful in excelling in this role, but are not a hard requirement, as we are firm believers in the growth potential of our next teammate. This also means that we want to provide long-term career paths, and thus are prioritizing candidates who are able to continue with us full-time after the internship.

We want to welcome people from diverse backgrounds, with an open mindset and curiosity. We hope you are a person who does not refrain from asking questions and proposing improvements, nor a person who is scared of diving deep into the Merchant datasets. 💙

Ideally, you’re already located in Helsinki or close by to have the possibility to visit the office at least once a week, to work as close as possible with your mentor and team members that are located in Helsinki.

We are unfortunately unable to offer relocation or visa support for internships, so you should be eligible for work in Finland for the duration of the program. If you’re offered to stay with us on a permanent basis after the internship, we’ll take care of your work visa if that’s needed.

Additional Information

👀 The process is easy:

1 - Read through the assignment instructions carefully. When your solution is ready, put it as a zip file to Google Drive, Dropbox, OneDrive (or similar). Remember to check permissions! If we cannot access the file, we cannot review your solution. Please don’t store your solution in a public GitHub repository during the application period.

2 - Click “Apply now”, fill in your details, and attach your solution. If you have a CV, want to tell us more about yourself and your interests in a cover letter, or have some interesting projects that you’d like to share with us, feel free to include those as well.

3 - Send your application!

Please note that the assignment is a mandatory part of the process. Applications without attached solutions won’t be accepted.

The deadline is the 22nd of February (end of the day).

If you have any questions you can turn to our Talent Acquisition Partner, Zhanna at zhanna.filintseva@wolt.com.

Please note that we do not accept applications via email or LinkedIn messages.