Description

Key Responsibilities

• Design and implement enterprise-scale data warehouse and Lakehouse solutions using BigQuery
• Define canonical and dimensional data models and enterprise information architectures
• Architect large-scale data ingestion, transformation, and reporting pipelines
• Design partitioning, clustering, materialized views, and query optimization strategies
• Build metadata-driven, reusable ingestion frameworks using Dataflow, Dataproc, Pub/Sub, Cloud Composer, and Data Fusion
• Define enterprise data governance frameworks including IAM, row/column-level security, and data masking
• Ensure compliance with GDPR, HIPAA, and CCPA

Required Skills

• BigQuery, GCP, Data Warehousing, Lakehouse architecture
• Dataflow, Dataproc, Pub/Sub, Cloud Composer (Airflow), Data Fusion
• ELT frameworks, SQL-based transformations
• Data governance, IAM, data lineage, data quality
• Cloud migration from Oracle, Teradata, Snowflake, Redshift, Hadoop, or Azure

Preferred Skills

• BigQuery ML and Vertex AI integration
• Data Mesh and Data Product implementation
• Insurance or Banking domain experience
• Experience with petabyte-scale datasets

Key Skills

Education

Not specified