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.
10 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 (121)
dacpac10
python10
publish10
sqlpackage10
dac10
powershell-module10
sqlcmd10
ssas10
ssas-tabular10
azure-devops-pipelines10
microsoft-sql9
mqtt9
sql9
home-automation9
database9
Programming languages (10)
Github contributions (5)
DrJohnT/HomeAssistantPublicConfig
Mar 2020 - Jan 2021
Contributions:52 commits, 50 pushes, 1 branch in 10 months
DrJohnT/PublishDacPac
Mar 2019 - Jan 2021
PowerShell to publish (deploy) SQL Database using a DACPAC and DAC Publish Profile
Contributions:1 release, 44 commits, 3 PRs in 1 year 10 months
publishdacpacpowershellsqlsql-database
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.