Data and Visualisation Engineer

Jobtailor; City of Edinburgh; On-site; GBP 65,000 - 90,000; Full time

Job summary

Jobtailor in Edinburgh is seeking a data-focused BI engineer to design and maintain ELT pipelines, build governed data products, and deliver Power BI models that empower stakeholders.

You will collaborate with operations and analytics teams, implement data quality rules, document definitions, and ensure semantic models are versioned and released in line with enterprise standards.

Qualifications

• 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).

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 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

Skills

Data modeling

Power BI

SQL

DAX optimisation

Data quality checks

Requirements gathering

Stakeholder collaboration

Tools

Azure

Databricks

Python

JSON

Job description

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)