Opportunity Description
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)
Interested in this opportunity? Apply now through Expertini.
Apply for this Position