Business Intelligence Engineer

Marcus
Ward

35+ years of domain knowledge · Full-stack analyst mindset · MJW Technical Consulting Ltd.

+44 (0) 7434 376033 marcus@mjwtechicalconsulting.com Admaston, Telford, Shropshire

Scroll to explore

Who I Am

Professional Profile

Business Intelligence Engineer with a full-stack analyst mindset and over 35 years of domain knowledge. Combines deep industry experience with technical expertise to bridge data engineering and analytics, delivering end-to-end solutions that transform business operations.

Skilled in automating pipelines, building self-refreshing dashboards, and designing alert-driven systems that guide strategic decisions. Applies advanced data storytelling (e.g. Pyramid Principle) to ensure clarity and impact.

Recognised for enabling enterprise-wide self-service analytics through a builder mindset and practical business insight.

50%
Government
25%
Healthcare
20%
Finance
5%
Utilities

Expertise

Core Technologies

BI & Visualisation 90%
Power BI (Advanced DAX)
Power BI Embedded
Power BI Paginated Reports
Power Query (M)
Data Architecture & Engineering 80%
Microsoft SQL Server
Azure Data Factory
Azure Cosmos DB
Synapse Analytics
Data Modelling & Warehousing 90%
Azure Analysis Services
Tabular Modelling
Star Schema Design
Microsoft Fabric 30%
Fabric Dataflows Gen2
Fabric Semantic Modelling
Medallion Architecture
AI / ML / Cognitive Services 40%
Azure Machine Learning (AutoML)
Azure Cognitive Services
LLM / Generative AI
Copilot Studio / Azure OpenAI
Development & Scripting 70%
Microsoft T-SQL
DAX
Python
VBA / Visual Basic

Experience

Career History

December 2021 – Present
Business Intelligence Engineer / Consultant
TTC Group Ltd. (Contract)
Led the redesign and delivery of TTC's enterprise BI ecosystem, transitioning from a fragmented reporting landscape to a unified, scalable data platform on Microsoft technologies.
  • Rebuilt Enterprise Power BI Ecosystem: Consolidated 147+ siloed datasets into unified shareable models.
  • Performance & Reliability: Migrated to Azure Analysis Services — refresh times dropped from 1.5 hrs to 4–5 min, 60% failure rate eliminated.
  • Data Engineering & Architecture: Built medallion architecture using Microsoft Fabric, ADF, Cosmos DB mirroring, and Dataflows Gen2.
  • Embedded Analytics: Developed Power BI Embedded in Continuum platform — 70% reduction in development effort.
  • Conversational BI with Copilot: Deployed Microsoft Copilot Agents via Fabric Data Agents for natural language querying in Teams.
December 2018 – December 2021
Lead Data & BI Solutions Architect
Digital Innovation – Fujitsu Services Ltd.
Designed and delivered a hybrid cloud analytics platform using Azure Data Services.
  • Standardised modelling via Tabular Models, Power BI, and Power Apps — BI delivery time cut by over 50%.
  • Led Agile teams shaping scalable architectures tailored to evolving business needs.
  • Architected end-to-end ETL workflows with Azure Data Factory and Logic Apps.
  • Founded and chaired internal user groups, fostering knowledge sharing and innovation.
⭐ Fujitsu Distinguished Engineer
June 2017 – December 2018
Data Innovation Architect
Digital Innovation – Fujitsu Services Ltd.
  • Led end-to-end BI architecture delivering cloud-native solutions across Microsoft Azure.
  • Drove technical R&D and PoCs across the full BI lifecycle.
  • Delivered tailored analytics platforms using Azure SQL, Synapse, Cosmos DB, and Data Factory.
November 2015 – June 2017
Lead Technical Services Manager
Technical Services Directorate – Fujitsu Services Ltd.
  • Led modernisation of the enterprise BI platform, driving adoption of Power BI, SSAS, and Power BI Report Server.
  • Re-engineered legacy SQL Server and Excel-based solutions into scalable, optimised data models.
September 2013 – November 2015
Head of Strategy Operations
Strategy & Capability Unit – Fujitsu Services Ltd.
  • Managed a 160+ person team across UK and Ireland for HMRC Aspire programme.
  • Led resource planning, capacity, and service continuity across strategic programmes.
July 2005 – September 2013
Technical Design Manager
Infrastructure Design – Fujitsu Services Ltd.
  • Held primary responsibility for planning and delivering low-level infrastructure technical designs across enterprise and management solutions projects within the HMRC Aspire account.
June 2003 – July 2005
Technical Lead – Infrastructure Delivery
Barclay's Bank Account – Electronic Data Systems (EDS)
  • Led implementation of a large-scale Windows Server 2003 environment at the DSMC.
  • Delivered what was, at the time, the largest Citrix farm deployment in Europe.

Education & Development

Training & Courses

  • Transfer Data using Data Factory (Advanced)
  • Introduction to Microsoft Fabric
  • Data Analytics & Engineering with Microsoft Fabric
  • Advanced Microsoft Fabric Implementation & Governance
  • Intro to RAG with Azure AI
  • Implement Generative AI Solutions
  • Advanced Azure AI Engineering with AI Search & OpenAI
  • Azure OpenAI: Generative AI Models and How to Use Them
  • Microsoft Azure Machine Learning Fundamentals
  • Advanced Power BI: DAX Language, Formulas & Calculations
  • Advanced Power Query Techniques
  • Microsoft Power Platform Fundamentals
  • Introduction to Microsoft Dataverse
  • Microsoft Azure Cloud Concepts
  • ITIL Version 3 Foundation
  • Prince 2 Foundation
  • Business Diversity
  • Global Anti-Corruption
  • Global Security Awareness
  • Risk Management
  • Data Protection Awareness
  • Managing Performance & Productivity
  • BTEC HNC in Computer Science – Wolverhampton University (1992)
  • BTEC ONC in Computer Studies – Shrewsbury College of Art & Technology (1989)
  • Secondary Education – 5 O'Levels, Charlton School, Shropshire (1987)

Get in Touch

Contact

Location
32 Donnerville Gardens, Admaston, Telford, Shropshire TF5 0DE

Available for contract and consulting engagements. Specialising in enterprise BI transformation, Power BI, Microsoft Fabric, and Azure data platforms.

Operating through MJW Technical Consulting Ltd.