Senior SQL / BI Engineer

Engineering Team

SQL
Data Warehouses
Machine Learning
Data Mining
Data Transfomrations
Google BigQuery
Data Pipelines
ETL

At SegmentStream, we help companies get the maximum value from their data.

Founded in 2017, SegmentStream platform is already trusted by many leading brands such as United Colors of Benetton, New Balance, Nespresso, MyToys, Eventim, and many others.

In order to evolve our product and scale our business, we are looking for an experienced SQL / BI Engineer who will be integrated into our Engineering team, being responsible for helping maintain and improve the BI and Data Transformation architecture, Machine Learning algorithms, Data Mining processes and delivering scalable and beautiful data solutions within our core product.

Apply

not defined

salary

3–6 years

experience

in the office or remote

full time occupation

What we do:

  • We develop high-load data pipelines that allow to automate data collection across hundreds of different data sources.

  • We automate data transformation flow using our advanced Workflow Management System based on Kubernetes and Argo (the same stack is used by Tesla, Nvidia, Google, GitHub, and other great companies).

  • We love Clouds. We use Google BigQuery as our primary data warehouse, and our whole infrastructure is based on the Google Cloud Platform.

  • We develop our break-though solutions using Machine Learning to solve complex business problem and invent elegant applications for the technology.

  • We believe in using the right tool for the right task.

  • We are proud of the code we write. We prefer clean, structured, customisable and scalable solutions which fit all clients, versus ad-hoc, fast and dirty solution which is delivered just for one client.

  • We love when our products drive revenue to our customers, being complex under the hood, but very simple for the final user.

You fit us if:

  • You can turn complex business requirements into a working product that our customers will love.

  • You are proud of the SQL code that you write, but at the same time remain pragmatic and self-critical.

  • You know when to refactor and when to release.

  • You are inspired by the search for elegant solutions for complex technical problems.

  • You are passioned about Data, AI and ML.

  • You love elegant and scalable solutions and hate dirty ad-hoc work.

  • You are focused, motivated, independent and able to complete the job, no matter how difficult the task.

  • You're empathetic, patient and happy to help your teammates grow.

Examples of future challenges:

  • Improve the accuracy of our machine learning models and algorithms to predict user's probability to buy.

  • Find the best solution for cross-device and cross-platform data stitching on a user level.

  • Prepare a scalable end customisable data transformation for marketing channel groupings based on landing pages or UTM-parameters.

  • Improve the data schema of our Data Warehouse to make it more scalable and cheaper to process the data.

  • Refactor our "hits to sessions" web analytics data transformation to make it more elegant and expandable.

  • Prepare a data transformation which allows to migrate from a legacy schema to a new one.

  • Prepare re-useable and customisable data transformations for visualising user-level metrics like LTV, CAC, Retention Rate, etc.

Requirements:

  • You have a degree in Computer Science, Math, Statistics or similar.

  • Expert SQL knowledge.

  • 5+ years in a Data Warehouse environment with varied forms of data infrastructure, including relational databases, Hadoop, and Column Stores.

  • 5+ years experience in Python, R, Scala, Java, or similar data processing programming language.

  • 2+ years working with a BI reporting tools (Tableau, QlikView, PowerBI, Looker, Google Data Studio…).

  • Experience in Digital Marketing Analytics and Attribution is a huge bonus.

  • Experience in data pipelining technologies and ETL frameworks.

  • Experience with data analysis, processing, and validation.

  • Experience with Machine Learning is a huge bonus.

  • Proven ability to write code that solves real problems.

  • Experience implementing data solutions in public cloud technologies including configuration and deployment.

  • You value teamwork and agree with the statement that “a team is a group of people who are responsible for each other’s decisions”.

  • You write fluently in English without mistakes.

Apply

Interested in this position?

Leave your contact details and we'll
get in touch in 8 business hours.

Thank you!
We will get in touch with you shortly.