Data and Visualisation Engineer

Responsibilities

• Design, build and maintain ELT pipelines and curated data models aligned to best practice and enterprise strategy/policy
• Produce well-governed data products that include documentation and relevant data quality checks
• Build clean, performant Power BI models and reports using best-practice DAX, data modelling, and visual storytelling
• Design self-service-ready BI assets with intuitive navigation, drill paths, KPIs, and filters
• Document metric definitions, business rules, and logic in clear, reusable formats
• Profile, validate, and reconcile source data; embed data quality rules and monitoring
• Investigate issues using structured root-cause analysis and partner with SMEs to resolve
• Maintain documentation, lineage and controls as part of the delivery lifecycle
• Ensure semantic models and datasets are versioned, documented and released in line with team and enterprise standards
• Contribute to backlog refinement, estimation and planning
• Deliver iteratively with quick feedback loops
• Collaborate closely with stakeholders and SMEs across the business, technology partners, and the wider team
• Communicate impacts, risks, and trade-offs clearly and early
• Partner with business teams (Operations, Propositions, Advice, Distribution, Marketing, Finance and others) to understand desired outcomes, key decisions, and constraints
• Lead discovery sessions to map current reporting, source systems, dependencies, and pain points
• Run structured requirement gathering workshops, interviews, and data walkthroughs
• Translate ambiguous requests into clear requirements (metrics, dimensions, logic, refresh cycles, SLAs)
• Challenge and refine requirements, reconciling conflicting definitions and negotiating pragmatic scope
• Support and execute testing, incorporating feedback into iterative improvements

Requirements

• Hands-on experience designing data models for the creation of data products and/or the delivery of analytics
• Experience designing and maintaining shared datasets and semantic layers with versioning and ownership
• Strong skills in designing Power BI models, including relationship design, DAX optimisation, and calculation reuse
• Proficiency in SQL including window functions, set-based logic, optimisation
• Experience with modern data platforms (Azure, Databricks, Lakehouse patterns)
• Knowledge of ELT/ETL pipelines, incremental processing, job orchestration and version control
• Exposure to API-based integration, JSON and other programming languages (e.g. Python)

• Hands-on experience designing data models for the creation of data products and/or the delivery of analytics
• Experience designing and maintaining shared datasets and semantic layers with versioning and ownership
• Strong skills in designing Power BI models, including relationship design, DAX optimisation, and calculation reuse
• Proficiency in SQL including window functions, set-based logic, optimisation
• Experience with modern data platforms (Azure, Databricks, Lakehouse patterns)
• Knowledge of ELT/ETL pipelines, incremental processing, job orchestration and version control
• Exposure to API-based integration, JSON and other programming languages (e.g. Python)