Senior Full-Stack BI Engineer

Job Title: Senior Full-Stack BI Engineer

Function: Data, Analytics & BI

Reports To: BI Manager

Level: Senior

Role Purpose

The Senior Full-Stack BI Engineer owns end-to-end slices of BI work - from source to transform, model, semantic layer, report/app, and release - with minimal supervision. You are trusted to deliver products stakeholders actually use and to stabilise and improve existing solutions.

You also start to coach Associates, enforce standards, and deepen business domain expertise in at least one key area.

Key Responsibilities

• 1. Own End-to-End BI Deliverables
  • Take defined outcomes (e.g. "give us visibility of X KPI across regions") and deliver the full data product:
  • Data ingestion / pipeline adjustments.
  • Transform and model design or enhancement.
  • Semantic layer (measures, relationships, RLS).
  • Reports / dashboards / paginated reports / simple apps.
  • Publication, access configuration, and basic usage guidance.
• 2. Transformation & Modelling
  • Design and refine Fit for purpose dimensional/star schemas or other models that address real stakeholder questions.
  • Improve or refactor existing models to simplify logic and reduce report level "gymnastics."
  • Implement robust refresh logic and monitor data quality across the pipeline.
• 3. Semantic Layer & KPI Logic
  • Define and maintain measures, calculated columns, and relationships in Power BI datasets and Fabric/Databricks models.
  • Implement and maintain RLS and access rules that reflect business requirements.
  • Rework metric definitions to match how the business actually talks about performance, closing gaps between legacy definitions and current needs.
• 4. Reporting, Dashboards & Apps
  • Build high quality Power BI dashboards using agreed themes, layouts, and navigation patterns.
  • Design and maintain paginated/operational reports for detailed or regulatory needs.
  • Where appropriate, build or extend Power Apps or other delivery mechanisms that embed BI into workflows.
• 5. Stakeholder Engagement
  • Run requirements conversations directly with business stakeholders, translating loosely defined asks into clear BI deliverables.
  • Communicate trade offs, constraints, and timelines in plain language.
  • Walk stakeholders through new or updated reports, explaining structure, metrics, and how to interpret them for decisions.
• 6. Incident Management & Support
  • Diagnose and fix data quality issues, refresh failures, and performance problems across the stack without heavy supervision.
  • Trace issues from the report layer back through the semantic layer, transformations, and source systems, and fix them at the correct layer.
• 7. Standards, Coaching & Collaboration
  • Review Associates' work, providing clear feedback on why changes are needed, not just what to change.
  • Help enforce shared standards for themes, naming conventions, KPI definitions, security rules, and documentation practices.
  • Support continuous improvement of platform patterns and reporting frameworks.

Skills & Experience Essential Technical Skills

• Strong proficiency in SQL and practical experience with one or more of: Python, PySpark.
• Hands on experience with Databricks and/or Microsoft Fabric, including pipelines/notebooks/jobs or equivalent orchestration.
• Deep experience using Power BI for:
  • Data modelling, measures, and relationships.
  • RLS and dataset refresh.
  • Building production dashboards and reports.
• Experience with paginated reports (e.g. Report Builder) and familiarity with Power Apps or comparable delivery tools.

Business & Domain Skills

• Deep understanding of at least one key business domain (e.g., sales, marketing, operations, finance), including:
  • Processes and workflows.
  • Core KPIs and how they're defined.
  • Source systems of record.

Behaviours & Mindset

• Operates with end-to-end ownership - does not stop at "my layer."
• Uses a forensic approach to problems, finding root causes instead of patching symptoms.
• Models "no time zone blame" - resolves most issues within their day or escalates with clear context.
• Uses AI tools deliberately as leverage for productivity, while validating outputs.

Qualifications

• Degree or equivalent experience in a relevant field (Data, Computer Science, Engineering, Business Analytics, etc.).
• Proven experience delivering BI products in a modern BI environment (e.g. Azure, Fabric, Databricks, Power BI).

Career Progression

This role sits at the Senior level of the Full Stack BI ladder. You are ready to move toward Staff Full Stack BI Engineer when:

• You can turn messy, ambiguous requests into defined data products without someone else shaping them first.
• You are comfortable working across multiple business domains, not just your "home" domain.
• Other engineers are regularly unblocked by you.
• When you fix something, it stays fixed and the pattern is reusable for others.