Cloud data platforms (GCP, AWS & Azure)
Storage, compute, orchestration and warehouse design on Google Cloud, AWS or Azure: BigQuery, Cloud Run, Cloud Logging and Secret Manager; S3, EC2 and Redshift; Azure Data Factory, Azure SQL, Blob Storage and Data Lake ingestion.
Data warehousing & modelling
Snowflake, BigQuery, Redshift and PostgreSQL with raw, staging, curated and reporting layers, fact and dimension models at an agreed grain, conformed dimensions, naming standards, query tuning and documentation.
Warehouse migration & cutover
Moving legacy databases such as SQL Server, data lakes and manual spreadsheet reporting into a cloud warehouse, with database discovery, source-to-target mappings, dependency and impact analysis, and stage-by-stage reconciliation before anything is switched off.
Analytics, BI & semantic layers
Power BI, Tableau, Looker Studio and Streamlit reporting over curated views and semantic models, with metric definitions, refresh checks and alerts. Existing SSAS and Analysis Services models reviewed before they are rebuilt.
Data quality, validation & reconciliation
Checks that compare pipeline stages and source systems on record counts, date coverage, nulls, duplicates, totals and metrics, with outlier detection, alerting and a documented override path for the figures people adjust by hand.
API, webhook & spreadsheet integrations
REST APIs, OAuth flows, webhooks, blockchain RPCs and scheduled pulls from SaaS, finance and operational systems, with retries and transformation logic. Google Apps Script jobs and Sheets add-ons where the process genuinely lives in a spreadsheet.
Web scraping & data extraction
Maintainable Python collection from dynamic pages and authenticated portals, respecting source terms and rate limits, plus LLM-assisted extraction from documents whose layout keeps changing.
Business app & portal development
Operational apps, admin panels and customer portals with role-based access, forms, approvals and API-backed workflows, plus Streamlit and Plotly data apps for internal analysis.
Custom chatbots & AI assistants
Support and internal Q&A assistants connected to databases and APIs, with role-aware behaviour, source grounding and a clear answer when the source material cannot answer.
MCP servers & custom AI connectors
Model Context Protocol servers in Python, custom connectors, plugins and reusable AI skills that expose approved business tools and data to AI applications, with OAuth, managed secrets and logging designed in.
Blockchain & on-chain analytics
Cross-chain transaction data consolidated into a warehouse: transactions, logs and events decoded with contract ABIs and Web3.py, token valuation with FX reference data, fee proration, categorisation and staking-reward reconciliation.
Support, security & optimisation
Performance passes, monitoring, least-privilege access, OAuth and managed secrets that support SOC 2 programmes, deployment hygiene and support plans for systems already in production.