Senior Developer / Data Engineer - SQL & Terraform
Remote role
Compensation: $55 - $65 per hour
ABOUT THE ROLE
Our client is launching a new Enterprise Data Platform (EDP), an AI-ready data foundation built on a medallion architecture in BigQuery. This platform will ingest data from all DaVita source systems—both on-premises and cloud—leveraging a modern Google Cloud Platform (GCP) stack including Dataflow, Dataform, Terraform, and CI/CD automation. Data governance is managed through Google Knowledge Catalog (formerly Dataplex). This is a newly funded initiative with strong momentum and a clear path to team growth as internal funding is approved. As a Senior Developer / Data Engineer, you will play a critical role in building and optimizing data pipelines, ensuring robust infrastructure, and collaborating closely with technical leads to establish standards and best practices in a fast-paced, newly established platform team.
WHAT YOU'LL DO
- Develop and optimize data pipelines and transformations within the BigQuery medallion architecture
- Write and tune complex SQL queries for large-scale data transformation and validation
- Build and maintain Terraform-based infrastructure to support pipeline deployment
- Implement and manage data ingestion from on-prem and cloud source systems using GCP tools (Dataflow, Dataform)
- Collaborate with technical leads on pipeline standards, testing, and CI/CD automation
- Ensure data governance and cataloging through Google Knowledge Catalog (Dataplex)
- Participate in technical Q&A sessions and communicate solutions clearly to panel and team members
- Contribute to a culture of hands-on technical excellence and proactive problem-solving in a newly established team
WHAT YOU BRING
- Expert-level SQL skills: complex queries, performance tuning, and data validation (must be recent and hands-on)
- Strong hands-on experience with Terraform in a GCP environment, including authoring and owning modules (not just running existing ones)
- Production experience with Dataflow and/or Dataform for pipeline development (hands-on, not just conceptual)
- Experience developing and optimizing data pipelines within BigQuery medallion architecture
- Familiarity with CI/CD automation and pipeline standards
- Ability to work effectively in a fast-paced, newly established platform team
- Experience with Google Knowledge Catalog / Dataplex (nice to have)
- Background in healthcare or other highly regulated data environments (nice to have)
- Clear, confident communication skills, especially in technical Q&A settings (nice to have)
- Demonstrated ability to acknowledge unfamiliarity rather than guess through technical questions
WHAT WILL DISQUALIFY A CANDIDATE
- Lack of recent, hands-on delivery with SQL or Terraform (theory-only backgrounds will not be considered)
- Medium-level skills in SQL, Terraform, or Dataflow/Dataform (the bar is set at strong, hands-on expertise)
- Guessing through technical questions instead of acknowledging unfamiliarity
INTERVIEW PROCESS
- Panel interview with three client technical leaders
- One-hour session, primarily technical Q&A
- Priority given to hands-on Dataflow, Dataform, Terraform, and SQL experience over architectural or theoretical backgrounds
#LI-AH2