Senior GCP Data Engineer Consultant – BigQuery & Airflow

Keyhole Software is hiring Senior GCP Data Engineers with strong experience in Big Query, Apache Airflow, and cloud-based data pipelines to support a long-term enterprise healthcare client engagement. This consulting role is ideal for experienced data engineers who can quickly learn an established environment, independently implement complex data pipelines and loading logic, and contribute thoughtful design recommendations when needed.

• Location: Remote within the United States. Preference will be given to candidates located in the Kansas City metro area, followed by candidates residing elsewhere in Kansas, Missouri, or in Nebraska, Texas, Florida, or Arizona.
• Eligibility: Candidates must be authorized to work and reside in the United States. No Corp-to-Corp (C2C) or Contract-to-Hire (C2H). At this time, Keyhole Software is unable to provide visa sponsorship.

Keyhole Software is seeking experienced Senior GCP Data Engineers to join our team. Our consultants are full-time members of Keyhole Software, working across a variety of long-term client engagements throughout their careers.

For this engagement, you’ll join a client-led engineering initiative focused on complex data migration, extraction, transformation, and loading. You’ll work within established architectural patterns while bringing the experience and judgment to independently design solutions, navigate complex table structures and business rules, and improve implementation approaches when appropriate.

The environment is centered on Google Cloud Platform, with Big Query and Apache Airflow serving as core technologies. You may also work with Dataflow, Google Cloud Storage, Cloud SQL, Pub/Sub, Terraform, and relational databases such as Microsoft SQL Server and PostgreSQL.

A genuine enthusiasm for using AI throughout the software development lifecycle is important to this position. Our most successful consultants are incorporating AI-assisted development into their daily workflows to improve productivity, accelerate troubleshooting, understand complex systems, strengthen documentation, and solve engineering problems. We’re looking for someone who embraces these tools thoughtfully while continuing to exercise sound technical judgment.

If you enjoy solving complex data problems, building reliable cloud pipelines, and working directly with experienced client teams, we’d love to talk with you.

• Design, build, test, and maintain scalable data pipelines and data-loading processes in Google Cloud Platform.
• Develop and optimize data workflows using Big Query and Apache Airflow.
• Implement established client architecture and engineering patterns while identifying opportunities to improve reliability, performance, and maintainability.
• Analyze complex source tables, data relationships, transformations, and loading requirements.
• Develop and support data extraction, transformation, migration, and validation processes.
• Troubleshoot pipeline failures, data-quality issues, performance bottlenecks, and production defects.
• Partner with client engineers and stakeholders to clarify requirements and translate them into reliable technical solutions.
• Contribute sound design recommendations based on prior experience building cloud data platforms and pipelines.
• Write clean, maintainable, well-tested code and participate in collaborative Git Hub-based development workflows.
• Create clear technical documentation for pipelines, data flows, operational processes, and design decisions.
• Work independently, manage priorities effectively, and become productive within an established client environment quickly.
• Leverage AI-powered development tools to improve analysis, implementation, testing, documentation, troubleshooting, and delivery while…