GCP Data Architect
Posted 1 day ago by Hunter Bond
Negotiable
Undetermined
Undetermined
London Area, United Kingdom
Summary: The GCP Data Architect role involves consolidating fragmented reporting and eliminating "tribal knowledge" within Finance and Executive BI processes. The position requires hands-on engagement to define reporting requirements, design a clean data model, and build ETL pipelines for centralizing data into BigQuery. The role emphasizes collaboration through workshops and delivering validated dashboards. Strong technical skills in BigQuery and ETL pipeline development are essential for success in this position.
Key Responsibilities:
- Run onsite workshops to define KPIs and reporting requirements
- Design a scalable BigQuery schema (finance-grade, single source of truth)
- Build automated ETL/ELT pipelines (Python preferred)
- Centralise and reconcile Stripe + operational data
- Deliver validated dashboards in Looker Studio
- Document data logic and architecture
Key Skills:
- Strong BigQuery + advanced SQL
- Proven ETL pipeline development experience
- Experience working with financial/reporting data
- Confident leading stakeholder discovery sessions
- Comfortable operating autonomously in short, high-impact engagements
Salary (Rate): undetermined
City: London Area
Country: United Kingdom
Working Arrangements: undetermined
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Data Architect
We’re supporting a business looking to consolidate fragmented reporting and remove “tribal knowledge” from its Finance and Executive BI processes. This is a hands-on discovery engagement focused on defining reporting requirements, designing a clean data model, and building initial ETL pipelines to centralise data into BigQuery for trusted executive reporting.
Tech Stack
- GCP: BigQuery, Looker Studio
- Languages: Python, JavaScript
- Data Sources: Stripe, production database(s)
Responsibilities
- Run onsite workshops to define KPIs and reporting requirements
- Design a scalable BigQuery schema (finance-grade, single source of truth)
- Build automated ETL/ELT pipelines (Python preferred)
- Centralise and reconcile Stripe + operational data
- Deliver validated dashboards in Looker Studio
- Document data logic and architecture
Required Experience
- Strong BigQuery + advanced SQL
- Proven ETL pipeline development experience
- Experience working with financial/reporting data
- Confident leading stakeholder discovery sessions
- Comfortable operating autonomously in short, high-impact engagements