02/12/2026 updated
100 % available
Senior BigQuery & GCP Analytics Engineer | Data Platform Optimisation Specialist
Vila do Bispo, Portugal National Diploma in IT, Cape Peninsula University of Technology
About me
Senior BigQuery & GCP Data Engineer specialising in optimising and modernising production analytics platforms. Delivered 50%+ BigQuery cost reduction and 80%+ build improvements via incremental ELT (Dataform), event-driven modelling and CI/CD-managed workflows. EU-remote contractor.
BigQuery & GCP Analytics
Advanced SQL expertise with nested schemas, partitioning, clustering, performance tuning, Cloud Run, Cloud Functions, and IAM for production-ready analytics platforms
Data Transformation & Modelling
Incremental ELT workflows using Dataform with dbt-style patterns, modular models, automated testing, and semantic layer design for scalable data architectures
Infrastructure & DevOps
Terraform IaC implementation, CI/CD pipelines through GitHub and Azure DevOps, Git-based workflows, monitoring and release management for automated deployments
Programming & Integration
SQL advanced analytics engineering, Python for Cloud Functions, API integrations, GCS, boto3 cross-cloud transfer capabilities
Analytics Ecosystem
GA4/GA360, Google Ads, Funnel.io, Bloomreach integration and unified analytics across multiple platforms
Cost Optimisation
BigQuery processing cost reduction strategies, workload optimisation, and controlled platform spend management
Event Modelling
Nested event modelling, high-volume behavioural datasets, and real-time analytics workflow design
Data Governance
Audit-ready datasets in regulated environments, schema stability, analytical correctness, and regulatory compliance
Languages
EnglishNative speaker
Project history
Delivered and optimised event-driven BigQuery analytics platforms modelling behavioural, transactional and pricing data into scalable analytical structures. Migrated transformation workflows to incremental ELT reducing processing costs by 50% and improving build performance by 80%.
Delivered senior consulting engagements across regulated financial services and retail banking environments, focusing on production data reliability, reporting automation and controlled deployments in Regulated Financial Services.
Regulated & Domain-Critical Data Environments
Insurance & Actuarial Analytics
- Supported and enhanced a production mortality experience analysis platform used for annuity pricing.
- Designed ingestion, validation and reconciliation processes ensuring repeatable, auditable outputs suitable for regulatory and pricing decisions.
- Translated actuarial pricing logic into controlled production data pipelines and pricing systems.
Banking & Financial Services
- Delivered reporting and reconciliation pipelines for trade and derivatives data in audit-driven environments.
- Centralised and versioned reference data to strengthen governance and traceability.
- Implemented automated validation controls to improve reporting reliability.
Customer, Pricing & Marketing Analytics
- Designed SQL-based analytical warehouses supporting lifecycle, pricing and behavioural analytics.
- Built segmentation and lifecycle datasets supporting pricing-adjacent and risk-aware decision-making.
Tools: SQL Server, SSIS, SSRS, MDS, T-SQL, Agile delivery