Analytics / BI Developer

About the role

The Analytics / BI Developer delivers the reporting the business relies on and builds and maintains the data layer underneath it. The role combines report and dashboard delivery with hands-on data engineering across the data warehouse and ETL estate, working within established design patterns.

Key responsibilities

• Build, maintain and improve reports and dashboards for business stakeholders, delivering output that is accurate, consistent and on time.
• Clarify reporting requests before building, challenge requirements where needed and own the quality of reporting, including consistent definitions and metrics.
• Develop and maintain the reporting layer of the data warehouse, including views, data models and data preparation.
• Monitor ETL pipelines and warehouse loads, troubleshoot failures and escalate causes outside established patterns.
• Make routine changes to ETL pipelines and the data warehouse, such as new fields, extended loads and new tables, within the granted change authority.
• Identify data quality issues early and document reports, data models, pipelines and changes.
• Mentor the Junior Data Analyst day to day and engage with internal stakeholders and vendors on reporting needs.
• Move over time from report delivery into interpretation and insight, investigating trends and raising findings.

Required profile

• Degree, diploma or equivalent in computer science, information systems, statistics, mathematics or similar, or equivalent relevant experience.
• Two to three years of experience across reporting, analytics and data engineering.
• Ability to work within an existing architecture and follow established patterns.
• Good written and verbal communication with technical and non-technical stakeholders.

Required skills

• Strong SQL, including complex queries, views, stored procedures and performance tuning.
• Hands-on experience with an ETL or orchestration tool, ideally Azure Data Factory.
• Hands-on experience building reports and dashboards in a mainstream BI tool.
• Understanding of data warehouse modelling, including dimensional models.
• Advantageous: Exasol, Yellowfin BI, SQL Server, Azure Logic Apps or the wider Azure data stack.