Senior Data Engineer (GCP, BigQuery, dbt)
Senior Data Engineer (GCP, BigQuery, dbt) Duration: 3 - 6 months contract to hire W2 Rate - $100-102/hr – NO 1099 NO CTC NO THIRD PARTY Remote but may need to attend meetings in Richmond, VA on occasion Technical skills and proficiency requirements 5+ years of data engineering experience with strong expertise in GCP (BigQuery, GCS) and modern data stack tools Advanced hands-on experience with dbt Core, including incremental models, snapshots, macros, testing, and semantic layer development Strong BigQuery SQL expertise, including window functions, complex CTEs, SCD modeling, and query/cost optimization techniques Experience building and managing data pipelines and orchestration workflows using Python and tools like Prefect or Cloud Composer (Airflow) Solid understanding of data platform engineering, including BigQuery administration (partitioning, clustering), BigLake, IAM security, and CI/CD for data workflows (GitHub Actions or Cloud Build) Day to Day Design and develop scalable data models using dbt Core, including incremental models, snapshots, macros, and testing frameworks Build and optimize BigQuery SQL transformations, leveraging advanced techniques such as window functions, complex CTEs, and SCD patterns Ensure cost-efficient query performance through partition pruning, clustering strategies, and query optimization Manage and configure BigQuery datasets, including partitioning, clustering, materialized views, and external tables Develop and maintain data pipelines and orchestration workflows using tools like Prefect or Cloud Composer Implement event-driven pipelines (e.g., GCS-triggered workflows) with proper retry logic, monitoring, and alerting Build and maintain data validation frameworks using Python and tools like Great Expectations Configure and manage BigLake external tables over GCS (Parquet/Iceberg), including metadata caching and partition management Implement secure data access controls using GCP IAM, including service accounts and authorized views Collaborate with cross-functional teams to ensure high-quality, reliable data delivery Pay: $100.00 - $102.00 per hour Work Location: Remote Apply To this Job