Business Intelligence Engineer at OnBuy

Job Description:

Your role will involve:

• Being responsible for designing and documenting solutions and business metrics
• Being responsible for designing and building analytics capabilities using leading BI and Analytics tools.
• Being responsible for designing, integrating and maintaining all semantic level datasets using business logic for one version of the truth
• Designing and releasing business reports in a user accessed manner in line with requirements and existing business outputs

Requirements

We’re looking for:

• The ability to design warehouse and data lake structures and manage them effectively and understanding of location management (preferably BigQuery).
• An understanding of ETL / ELT functions as well as Data pipeline creation.
• The ability to create and manage multiple data pipelines in production.
• The ability to transform raw data into usable business datasets that have multi-purpose uses and bring the data to life for the end user (preferably DBT).
• An understanding of data orchestration – an understanding of orchestration procedures and principles, scheduled queries at a minimum - Airflow or other DAG led solutions preferable.
• A basic understanding of MySQL architecture for data transfer purposes.
• Experience with API structures and how to test using tolls such as postman, automation of API calls and JSON and API Methods.
• Use of Visualisation Tools in previous positions (e.g. Google Data Studio, Tableau, Looker).
• Basic GCP administration experience.
• Coding Skills:
• SQL - ability to write complex SQL queries for data model creation.
• Python – basic understanding.
• Commercial experience of versioning control software would be advantageous.
• An understanding of Data security and storage (cross country/continent).

Benefits

The salary range on offer for this role is £52,000 - £55,000 per annum, depending on experience.

In return for helping us to grow, we’ll offer you company equity. That’s on top of your salary and in addition to our other benefits, from our inclusive company culture to discounts on our website. So apply now, and let’s explore how we might work together!

Interview Process

2 stage interview process