John Tunnicliffe
BI Architect - Data Solution Designer
London, England, United Kingdom
Summary
👤
Senior🎓
Top SchoolJohn Tunnicliffe is a BI Architect and Data Solution Designer with decades of hands-on experience designing and automating enterprise data warehouses across finance, insurance, retail and healthcare. He specialises in the Microsoft BI stack—SSIS/SSAS/SSRS, Power BI, SQL Server and Azure—combined with strong C#, PowerShell and DevOps skills to deliver end-to-end continuous integration and automated deployments. John is known for creating metadata-driven, code-generated ETL and deployment frameworks (BIML, C#, Octopus, TeamCity/VSTS) that turn repetitive plumbing into repeatable, testable pipelines. He has repeatedly modernised legacy warehouse teams and platforms—bringing systems to near-real-time processing and replacing brittle migration scripts with declarative, automated processes. A PhD chemist by training, he pairs rigorous analytical thinking with practical engineering, and is a regular SQLBits and PASS speaker who publishes his conference material for peer reuse. Currently based in London, he focuses on architecting scalable, auditable BI solutions that let developers concentrate on value rather than hand-coding.
11 years of coding experience
21 years of employment as a software developer
BSc Hons, Chemistry, BSc Hons, Chemistry at Nottingham University
English
Stackoverflow
91reputation
2kreached
2answers
1question
Github Skills (83)
analysis-services10
dacpac10
python10
home-assistant-integration10
publish10
home-assistant10
sqlpackage10
dac10
powershell-module10
database10
sqlcmd10
multidimensional10
ssas10
ssas-tabular10
azure-devops-pipelines10
Programming languages (10)
Github contributions (5)
DrJohnT/HomeAssistantPublicConfig
Mar 2020 - Jan 2021
Dr John's Home Assistant Configuration covers Velux windows, Drayton Wiser heating, Audio / Visual equipment, lighting and humidity controlled fans
Contributions:52 commits, 50 pushes, 1 branch in 10 months
audiohome-assistantveluxdraytonwiser
DrJohnT/DeployCube
Apr 2019 - Mar 2021
Publish / Deploy a Tabular or Multidimensional Cube to SSAS or AAS
Contributions:2 releases, 63 commits, 4 PRs in 1 year 11 months
analysis-servicesssasssas-tabularmultidimensionalcube
Find and Hire Top DevelopersWe’ve analyzed the programming source code of over 60 million software developers on GitHub and scored them by 50,000 skills. Sign-up on Prog,AI to search for software developers.