Senior Data Engineer (GCP, BigQuery, dbt)
Senior Data Engineer (GCP, BigQuery, dbt) Duration: 3 - 6 months contract to hire W2 reputed company - $100-102/hr – NO 1099 NO reputed company NO reputed company 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, reputed company CTEs, SCD modeling, and query/cost optimization techniques Experience building and managing data pipelines and orchestration workflows using Python and tools like Prefect or reputed company Composer (Airflow) Solid understanding of data platform engineering, including BigQuery administration (partitioning, clustering), BigLake, IAM reputed company, and CI/CD for data workflows (reputed company Actions or reputed company Build) Day to Day Design and reputed company 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, reputed company 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 reputed company and maintain data pipelines and orchestration workflows using tools like Prefect or reputed company 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/reputed company), including metadata caching and partition management Implement secure data reputed company 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 tot his job Apply To this Job