Data engineering & warehousing
Python and SQL pipelines into BigQuery, Snowflake, Amazon Redshift or PostgreSQL, split into raw, staging, curated and reporting layers. Incremental loads, scheduled refreshes, automated backfills, Parquet extracts and query tuning. Includes cross-chain transaction data decoded with contract ABIs and Web3.py.
- Python
- SQL
- BigQuery
- Snowflake
- Redshift
- PostgreSQL
- dbt-style modelling
- Parquet
- On-chain data
Analytics, BI & semantic models
Fact and dimension models with an agreed grain, conformed dimensions and curated SQL views behind every dashboard. Reporting in Power BI, Tableau, Looker Studio, Streamlit and Plotly, plus review of existing SSAS or Analysis Services models and Salesforce CRM Analytics datasets, recipes and dataflows.
- Power BI
- Tableau
- Looker Studio
- Streamlit
- Plotly
- Semantic models
- SSAS / Analysis Services
- Salesforce CRM Analytics
Cloud, delivery & automation
Google Cloud, AWS and Azure services for storage, compute, orchestration and warehousing: BigQuery, Cloud Run, Cloud Logging, Secret Manager and Apps Script; S3, EC2 and Redshift; Azure Data Factory, Azure SQL, Blob Storage and Data Lake ingestion. Scheduled jobs, containers, monitoring and reviewable deployments.
- Google Cloud
- AWS
- Azure
- Docker
- GitHub Actions
- CI/CD
- Scheduling
- Monitoring
Software & web applications
TypeScript, JavaScript and Python behind responsive interfaces, client portals, admin panels and internal tools. REST APIs, OAuth flows and webhooks into business systems, plus Streamlit and Plotly data apps with filterable tables, date ranges and live record counts when the audience is internal.
- TypeScript
- JavaScript
- Python
- REST APIs
- Portals
- Streamlit apps
- Accessibility
AI automation, RAG & MCP
Retrieval-augmented generation over a defined knowledge set, Model Context Protocol servers in Python, custom AI connectors, plugins and reusable AI skills, and agentic workflows that retrieve context, generate SQL, validate the result and stop for approval. GPT, Claude, Llama and Qwen integrated behind your own access rules.
- RAG
- MCP servers
- AI connectors
- LLM APIs
- Agentic workflows
- Embeddings
- Evaluation
- Guardrails
Data quality, governance & access
Validation and reconciliation frameworks comparing record counts, date coverage, nulls, duplicates, totals and metrics between stages and systems. Metadata profiling, dependency and lineage analysis, outlier detection and alerting, and access control with OAuth and managed secrets that supports SOC 2 programmes.
- Data quality
- Reconciliation
- Metadata profiling
- Lineage analysis
- OAuth
- Secret management
- Audit trails