Remote Senior GCP Data Engineer — BigQuery & Airflow

Keyhole Software

Lenexa (KS)

Remote

USD 140,000 - 190,000

Full time

2 days ago

Be an early applicant

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical insurance (traditional and HDP

Dental and vision insurance

FSA and dependent care options

Life and disability insurance

401(k) with discretionary employer-con

Supplemental insurance options

Job summary

Keyhole Software is seeking experienced Senior GCP Data Engineers to join our team for a long-term client engagement in healthcare. This consulting role is full-time and remote within the United States, with preference for candidates in the Kansas City metro area.

You will design, implement, and optimize cloud data pipelines using BigQuery, Airflow, Dataflow, and related GCP services, collaborate with client engineers, and contribute to architecture decisions while applying AI-assisted

Qualifications

7+ years of professional data engineering, data platform, or related software engineering experience.
Strong production experience with Google Cloud Platform and BigQuery.
Hands-on experience building and orchestrating production data pipelines with Apache Airflow.
Demonstrated ability to independently design and implement complex data pipelines, transformations, and loading processes.
Advanced SQL skills and experience working with complex relational data structures and large datasets.
Experience with data migration, data integration, ETL/ELT, and data validation.
Experience optimizing cloud data pipelines and queries for performance, reliability, and cost.
Proficiency with Git and collaborative development workflows, including pull requests and code reviews.
Strong software engineering fundamentals, including maintainable code, automated testing, debugging, and source control.
Demonstrated ability to quickly learn an existing architecture, follow established patterns, and contribute with limited ramp-up time.
Strong analytical and problem-solving skills with the ability to troubleshoot issues across data, pipeline, and infrastructure layers.
Excellent communication skills and the ability to work directly with technical and non-technical stakeholders.
Comfortable taking direction from a client team, working independently, and adapting to changing priorities.
Demonstrated experience using AI-assisted development tools such as GitHub Copilot, ChatGPT, Claude, Cursor, or similar as part of everyday technical work.

Responsibilities

Design, build, test, and maintain scalable data pipelines and data-loading processes in Google Cloud Platform.
Develop and optimize data workflows using BigQuery 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 GitHub-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 exercising sound engineering judgment.
Contribute to a collaborative Keyhole consulting culture by sharing knowledge and supporting fellow consultants.