Role Briefing with:
Date: 07.05.2025
Recruiter: PL
TEAM PURPOSE: Build data dashboards - growing - now 10/12 people. Have developed their platform (OTS produtc), which is giving them 2/3 year contracts. Plug and play for fast access to analytcs platforms - but mainly geared towards automotive sector customers.
Start up business - 6+ years in business.
TEAM STRUCTURE:
6 in team that are technical and building the dashboards plus a couple of remote workers.
ROLE LOCATION: Houlton - hybrid but need to be fluid 2 to 4 days per week as needed. Not set days - must live locally and be able to drive. There will be a train station at some point. Opposite lovely pub / restaurant "Tuning Fork£, Loads of parking available. Co-op - great spot. Large park etc.
ROLE SALARY: Upt to £52, possibly slightly higher if exceptional candidate. Benefits are limited.
HOURS:
ROLE SUMMARY:
Current CV's have been too data enegineery or too front end power BI - needs a good mix. Only has run an Indeed advert.
Great small company culture - ideally candidate will have worked for smaller companies. Small business mentality.
Young team.
TECHNICAL ENVIRONMENT:
**Power BI
** DAX
** SQL Server backend
* Azure Data Platform
Python beneficial.
IDEAL CANDIDATE PROFILE:
TEAM CULTURE:
WHAT's EXCITING ABOUT THIS ROLE:
Potential for long term groth into a Head of ...role.
CV SUBMISSION PROCESS:
Send to Phil.
years of relevant technical experince and level.
Know the basics of the Azure Data Platform - Data Bricks etc.
ANYTHING ELSE THAT WE NEED TO KNOW?:
SEARCH STRINGS / BOOLEAN SEARCHES:
spoken to Mike. Here are my notes:
- Salary is £42k - £53k. Might consider someone above (say £5k?) but needs to ideally stick in the budget
- They are now in offices in Houlton, Rugby. Will be hybrid (ill explain on call)
- Business is going well. Previously they just focused on project work, but have recently launched their platform which is giving them 2 / 3 year commitment from customers
- Still work in automotive sector – platform is gear towards dealers
- This role is to focus on their platform and they are looking for someone who has a good mix of front end (Power BI, Tableau) and back end (SQL Server) skills
- Don’t get too bogged down in the Azure experience. Not looking for an expert there – just exposure
- Role still very hands on but will also be a problem solver / whiteboard sessions
- Good comms are essential – will be customer facing
- Mike sees this role evolving in to a “head of data” / “head of engineering” long term
- Power BI – not just creating dashboards. But someone that talks about Power BI Service, Building pipelines
- SQL Server – not just a DBA but need experience of SQL capabilities for data transformation and querying. Need the mix of front and back end skills
Power BI questions you could ask – examples from Chat GPT
🧠 DAX (Data Analysis Expressions)
- "Can you describe a complex DAX measure you’ve created and what problem it solved?"
→ Follow-up: Ask how they optimized it for performance.
- "How would you calculate a year-to-date (YTD) value, excluding weekends or holidays?"
→ This reveals understanding of time intelligence and conditional logic.
🛠️ Power Query (M Language)
- "Have you used Power Query to clean and transform messy data? What specific transformations did you perform?"
- "Describe a scenario where you used custom M code instead of the GUI. What did you need to achieve?"
🧱 Tabular Modelling
- "How do you design your data model in Power BI? What are your best practices for relationships and performance?"
- "Have you worked with star schema or snowflake models in Power BI? Which do you prefer and why?"
📊 Advanced Visualisation Techniques
- "What advanced visualisation features do you regularly use — e.g. drill-through, tooltips, bookmarks, or custom visuals?"
- "Can you describe a time when you had to design a dashboard for non-technical stakeholders? How did you ensure it was effective?"
🔄 Bonus (End-to-End Workflow)
- "Can you walk me through how you’ve taken a dataset from raw source to published dashboard in the Power BI service?"
→ Listen for use of Power Query, DAX, modelling, visuals, and publishing/deployment.
- "Have you used Power BI deployment pipelines? If so, how do you manage Dev/Test/Prod stages?"
Slide i took a screenshot of: