Data Architect – GCP / Data Warehouse Migration

Position Description:

The Data Architect will design and govern data models, transformations, and integration patterns for migrating Data Hub to BigQuery and enabling analytics via Power BI.

Your future duties and responsibilities:

• Design logical and physical data models (Bronze/Silver/Gold) in BigQuery
• Translate SQL based Data Hub schemas and business rules into GCP models (1:1 where required)
• Define transformation patterns (DBT/Dataform), data quality checks, and lineage
• Design ingestion strategies for IDR (batch/CDC) and Salesforce integration
• Define partitioning, clustering, and performance optimization strategies
• Support semantic layer design for Power BI (views, aggregates, RLS approach)

Required qualifications to be successful in this role:

• 7+ years in data architecture / data modeling
• Strong SQL and experience with BigQuery (or similar columnar warehouses)