Business Intelligence Analyst

About this role

Data owns the pipelines, the warehouse and the definitions the business argues about — funnel conversion, time to hire, source quality.

Build and maintain the reporting the commercial and people teams use weekly, and answer the questions those reports raise.

The hard part is not the pipeline; it is that two teams asking the same question must get the same answer. Most of the work is in the semantic layer and in being willing to say a number is not trustworthy yet.

Primary responsibilities

• Own the reporting layer the business runs on — the dashboards, the scheduled reports and the metric definitions behind them
• Build in the BI tool properly: governed datasets rather than a sprawl of one-off extracts
• Work with each function to define what they need to see and how often
• Keep reporting accurate through change in the underlying models
• Train stakeholders to self-serve rather than becoming a request queue

Skills required

Day to day this role works with SQL, Excel and Dashboards.

• One or more years with SQL and a BI tool
• Careful with definitions — you will be the one asked what a metric means
• Three or more years in business intelligence
• Strong SQL and dimensional modelling
• A BI platform administered rather than only used — governed datasets, permissions and performance
• Requirements gathering with business stakeholders
• Ability to train people to self-serve

Preferred