At a glance
Working arrangement: Fully remote, with in-person meetups roughly once a month in London or Manchester.
Contract: Permanent.
Hours: Full-time, 38 hours a week. Flexible hours, with no core hours requirement.
Team: Data and consulting delivery. Reports to the Chief Technical Officer and the Chief Product Officer.
Why this role exists
We are looking for a technically capable mid-level or senior data analyst to help our consulting team deliver client sales reports from our new data warehouse and online analytical processing (OLAP) cube environment. You will share responsibility for the end-to-end data lifecycle across our infrastructure and data engineering. Day to day, you will work with our consulting team to design and publish sales and market reports and dashboards, partner with a DevOps engineer to build and deploy robust extract, transform and load (ETL) pipelines, and maintain the integrity of our analytical schemas. You will also work closely with our backend engineering team to put data flows into production and provide precise, actionable insights.
This is not a pure reporting role. When you have capacity, you will help shape bespoke consulting proposals, manage the semantic layer, optimise dbt and Cube models, and keep our analytical schemas fast and robust. You can also work beyond reporting, helping us design and deliver other parts of the online transaction processing (OLTP) core data estate, including data modelling and artificial intelligence processing. As part of a small business, you will have opportunities to work across the company.
What success looks like
In the first 6 to 12 months:
The consulting team publishes client sales and market reports from the warehouse without needing an engineer.
ETL pipelines for client data run on a schedule you built with our DevOps engineer, and you can prove data quality with reports.
Client sales data sits under a documented security and retention policy, separate from our public datasets, and the engineering team has adopted it.
What you will do
Build client sales and strategy dashboards in Metabase, Apache Superset or a similar open-source tool.
Design and maintain the analytical schemas behind them, mostly star schemas, and keep them fast as data volumes grow.
Build and deploy ETL pipelines with our DevOps engineer, and work with the backend engineers to move those flows into production.
Produce data quality reports, then act on what they tell you about the schema design.
Build self-service tools so the consulting team can run its own ad hoc queries.
Spend roughly 20 to 30 percent of your time on live consulting projects, working directly with clients.
Make the case for data governance and security policies that treat client sales data differently from our public data.
Coach the consulting analysts on writing modular, reusable Python.
What you need
Strong Python for data work and automation. Pandas and NumPy are the day-to-day tools.
Strong Structured Query Language (SQL) skills, including query performance.
Experience designing analytical schemas for reporting, particularly star schemas.
Experience building dashboards in a business intelligence (BI) tool. Metabase and Superset are what we use.
Confidence working in notebooks, including Jupyter or Colab, for prototyping and sharing work.
The ability to talk to non-technical people about data, and to hold your position with engineers. Half this job is translation.
That is the list. If you can do these six things you are qualified to apply, and we would rather hear from you than not.
Useful, but not essential
dbt and Cube, or a similar semantic layer.
Postgres beyond standard SQL: PostGIS, pgvector, or hashing extensions such as tlsh_pg.
Data architecture, including contributing to decisions about how data is structured and flows through a product.
Graph data models. We plan to use them for some datasets.
Healthcare customer relationship management (CRM) or sales execution data, or an interest in healthcare markets.
Moving machine learning or large language model prototypes into production.
The team
Rare. is about fifteen people, split between a consulting business and a software as a service product, Rare.Monitor. Everyone is remote, mostly across the UK, the Republic of Ireland and Spain, with a growing delivery team in Paraguay.
You will sit between the two halves of the business, reporting jointly to the Chief Technical Officer and the Chief Product Officer. Day to day, that means working with the consulting team on one side, and a DevOps engineer and the backend engineering team on the other. There is no layer of management between you and the work. If you have contracted or freelanced before, this will feel familiar.
Right to work
You need the existing right to work in the UK or the Republic of Ireland. We are not able to sponsor visas for this role.
How to apply
Send your CV and a short note to [email protected]. In the note, tell us about one dataset or reporting problem you have solved and what you would do differently now. You do not need to send a cover letter.
Questions before you apply go to the same address.