Services

Senior consultancy across the full Microsoft data stack — from on-premises SQL Server to cloud lakehouses.

Data Warehouse Design & Build

End-to-end delivery of dimensional warehouses on SQL Server or in the cloud — from blank slate to production.

  • Source system analysis & profiling
  • Kimball-style star schemas
  • Slowly changing dimensions (SCD 1/2/6)
  • ETL / ELT pipelines
  • Conformed dimensions across business areas

SQL Server Development

Production-grade T-SQL and SSIS development by an engineer who has been shipping it since 2008.

  • T-SQL development & refactoring
  • Stored procedures, functions, views
  • SSIS packages & project deployment
  • SSAS Tabular & Multidimensional cubes
  • PowerShell automation

Performance Tuning

Diagnose what is actually slow and fix it — without rewriting the whole database.

  • Query plan analysis
  • Index design & rationalisation
  • Statistics & parameter sniffing fixes
  • Wait stats & bottleneck analysis
  • TempDB and isolation-level tuning

Database Administration

Senior DBA cover for the platforms we build — or just for yours.

  • Backups, restores & DR testing
  • High availability (Always On)
  • Security & permissions hardening
  • Capacity & growth planning
  • Patch & upgrade management

Microsoft Azure

Modern cloud data platforms on Azure, designed for security, cost and scale.

  • Azure SQL Database & Managed Instance
  • Synapse Analytics
  • Azure Data Factory pipelines
  • Data Lake Storage Gen2
  • Key Vault, private endpoints, RBAC

Databricks & Lakehouse

Lakehouse architectures using Delta Lake and the medallion pattern.

  • Bronze / silver / gold layering
  • Delta Lake table design
  • PySpark & SQL transformations
  • Unity Catalog governance
  • Power BI on Databricks SQL

Star Schema & Dimensional Modelling

Models that BI users can actually use — consistent grain, conformed dimensions, predictable performance.

  • Bus matrix workshops
  • Fact & dimension design
  • Late-arriving and SCD handling
  • Semantic layer for Power BI / Tableau
  • Documentation & data dictionary

Team Leadership & Mentoring

Uplift your existing team. Code reviews, pairing, architecture coaching and standards.

  • Code review & standards
  • Pair programming & mentoring
  • Architecture decision records
  • Hiring & technical screening support
  • Roadmap & backlog shaping

Reporting & BI

Power BI and Tableau implementations sitting on top of warehouses we trust.

  • Power BI semantic models
  • Row-level security
  • Tableau data sources & dashboards
  • DAX optimisation
  • Report performance reviews

Engagement models

Fixed-scope project

Defined deliverable, defined price. Best for warehouse builds, migrations and performance reviews with a clear endpoint.

Time & materials

Day-rate consultancy for evolving work — embedded in your team for as long as the engagement needs.

Retained DBA

Monthly retainer for ongoing DBA cover, performance tuning and architecture office hours.

Not sure which service you need?

Book a free 30-minute call — we’ll help you scope it.

Book a consultation