Data Engineer

Fortnum & Mason; Greater London; On-site; GBP 60,000 - 90,000; Full time

Job summary

Fortnum & Mason seeks a Data and Reporting Engineer to build and optimise Power BI-based analytics. You will collaborate with stakeholders to translate business questions into scalable BI solutions, shaping data pipelines and semantic models within Azure Synapse, Data Lake, and Fabric.

You will lead reporting delivery, ensure data quality, and promote best practices for governance and end-user experience across the organisation.

Qualifications

• Minimum 5 years’ experience in BI/Reporting or Data Engineering roles.
• Experience designing and building ETL/ELT pipelines from ingestion to consumption.
• Strong programming in Python for data processing and automation.
• Proficient with Azure data services and Power BI governance.

Responsibilities

• Translate business requirements into clear reporting and analytics solutions.
• Design, build and maintain Power BI dashboards, reports and scorecards.
• Develop semantic models, relationships and DAX measures for consistent metrics.
• Create reusable datasets and governed self-service analytics content.
• Own the reporting lifecycle from discovery to adoption and improvement.
• Define KPIs with stakeholders and ensure accurate metric definitions.
• Monitor report usage, performance and refresh reliability; troubleshoot issues.
• Support Power BI and Fabric reporting assets including dataflows and semantic models.
• Lead data pipelines and data platform design feeding reporting needs.
• Collaborate with Data Engineering on architecture and quality improvements.
• Ensure data governance, security, and compliance across pipelines.

Skills

Power BI

Python

SQL

Data modelling

Analytics

Education

BSc/BA in Computer Science, Data/Business Analytics, or a relevant field

Tools

Azure Synapse

Azure Data Lake

Microsoft Fabric

Databricks

Spark

Job description

Our Head Office department is in the heart of Piccadilly and occupies the 5th & 6th floor of our beautiful flagship store. This central London location offers so much to explore including restaurants, bars, cultural sites, shopping and more, and only a short walk from the Green Park Tube Station and plenty of bus stops.

Role Purpose:

The Data and Reporting Engineer is primarily responsible for building, analysing, enhancing, and supporting best in class, business focused reporting and analytics, using Power BI and the wider Microsoft data platform to turn business questions and requirements into clear, trusted insight.

They must have the ability to lead on the translation of business needs into clear reporting and analytics requirements that enable the design, build and deployment of Power BI solutions and general reporting alongside more standard Data Engineering activities.

Working alongside the wider Data Engineering team, they will help shape, validate and consume the underlying pipelines, data warehouse and data lake that feed reporting, flagging data quality issues and new data needs as they arise.

Working closely with stakeholders across the business, they will lead requirements gathering (where applicable), define reporting measures and design user-friendly Power BI solutions. This includes developing semantic models, visualisations and governed reporting content, while promoting consistent definitions and a strong user experience.

They will be comfortable working across the platforms we operate (Power BI, Microsoft Fabric,

Azure Synapse and ADL) at a reporting and analytics level, and will be able to lead project work and requests from colleagues across the business for reporting, BI and custom reports.

They will stay up to date on the latest analytical, data management and business intelligence technologies, offering insight and assistance in their future adoption and alignment within the business.

Responsibilities

• Translate business requirements into clear, well-structured reporting and analytics solutions
• Partner with business stakeholders to understand reporting needs, define requirements and translate questions into practical Power BI solutions
• Design, build and maintain interactive Power BI dashboards, reports and scorecards that are clear, accessible and easy to use
• Develop and optimise semantic models, relationships, calculated columns and DAX measures to provide consistent business metrics
• Create reusable reporting datasets and certified content that support governed self-service analytics
• Own the reporting lifecycle from discovery and prototyping through testing, release, adoption and ongoing improvement
• Apply effective data visualisation and user‑experience principles so reports communicate insight clearly and support decision‑making
• Work with report owners and users to define KPIs, document metric definitions and resolve inconsistencies in reporting
• Monitor report usage, performance and refresh reliability, troubleshooting issues and improving the end‑user experience
• Support Power BI workspace, access, deployment and content‑governance processes in line with security and data standards
• Design, build and maintain data pipelines and the underlying data platform (Azure Synapse, Data Lake, Microsoft Fabric) that feeds reporting and analytics
• Monitor, troubleshoot and resolve data pipeline and platform issues, ensuring high availability and reliability for reporting and analytics consumers
• Work with the wider Data Engineering team on data architecture decisions, flagging opportunities to improve reporting performance, cost efficiency and data quality
• Design and implement scalable, high-performance data models to support analytics and reporting use cases
• Implement and enforce data quality frameworks, validation checks and governance standards across pipelines and reporting datasets, in line with secrity and compliance policies
• Support the development and maintenance of Power BI and Fabric reporting assets, including semantic models, dataflows and reports
• Manage multiple concurrent projects and priorities in a fast‑paced environment

Experience and Qualifications:

• A minimum of 5 years’ demonstrable experience in a BI Developer, Reporting Analyst, Data Analyst or Data Engineer role
• Proven experience designing and building ETL/ELT pipelines and managing the data lifecycle from ingestion through to reporting and consumptionStrong programming experience in Python, with a focus on data processing and automation
• Solid, hands‑on experience with Azure cloud data services, including Azure Synapse, Azure Data Lake and Microsoft Fabric
• Proven, hands‑on experience delivering data visualisation and reporting solutions using Power BI, including semantic models, DAX measures and governed reporting content
• Strong experience developing enterprise-scale BI, data warehousing, and analytics solutions
• Strong SQL skills, including query writing, performance tuning and data modelling for reporting purposes
• Proven ability to work with a diverse group of stakeholders across multiple business functions, translating requirements into practical reporting solutions
• Ability to independently own and deliver end‑to‑end reporting solutions
• Experience implementing data validation and quality checks within reporting datasets and pipelines
• Strong understanding of data modelling concepts (e.g. star schema, dimensional modelling
• BSc/BA in Computer Science, Data/Business Analytics, or a relevant field (or equivalent experience)
• Exposure to big data processing frameworks such as Spark or Databricks
• Experience implementing CI/CD pipelines for data or reporting workflows
• Familiarity with data governance, security, and compliance frameworks
• Retail industry experience is preferred but not mandatory

Competencies, Behaviours and Skills

• Strong technical expertise in Power BI, SQL, and Python, with the ability to apply these tools to solve both reporting and data platform challenges
• Solid understanding of customer data, including Customer Experience (CX) and Customer Relationship Management (CRM) concepts
• Ability to operate effectively in a fast‑paced, delivery‑focused environment with changing priorities
• Strong organisational skills with the ability to manage workload independently and deliver to deadlines
• Proven ability to work collaboratively across multiple teams and business functions
• Strong stakeholder engagement skills, with the ability to translate business needs into practical technical solutions
• Ability to think from an end‑user perspective, ensuring solutions are intuitive, usable, and aligned to business needs
• Confidence to challenge requirements and propose alternative solutions to ensure scalability, performance, and long‑term value
• Strong problem‑solving and analytical thinking skills, with a focus on delivering robust and resilient solutions
• Commitment to quality, governance, and following defined standards, processes, and best practices
• Team‑oriented mindset, with a focus on delivering value to both customers and the wider business
• Strong communication skills, both technical and non‑technical, with the ability to explain complex concepts clearly
• Experience working in a retail or customer‑focused industry
• Familiarity with modern data engineering practices, including DevOps, CI/CD, and agile delivery methods
• Exposure to cloud‑based data platforms and distributed data processing (e.g. Databricks, Spark)

We are committed to developing your career and nurturing your talent, regardless of age; disability; gender reassignment; marriage and civil partnership; pregnancy and maternity; race; religion or belief; sex; sexual orientation. We respect and embrace each other's differences, to create a truly inclusive environment.

In the last year alone, our people have been recognised and celebrated, winning awards for their outstanding contributions to Retail, Technology, Global Hospitality & Tourism, Visual Merchandising & Display, Customer Service and Local Community Awards