Lead GCP Data Engineer - Cloud Modernization & Analytics

Long Finch Technologies; Town of Pelham (NY); On-site; USD 180,000 - 240,000; Full time

Job summary

Long Finch Technologies is seeking a Senior GCP Data Engineering Lead responsible for guiding large-scale cloud data modernization, migrations, and analytics initiatives on Google Cloud Platform. The role emphasizes hands-on expertise in BigQuery, Airflow, Python, and SQL optimization while partnering with stakeholders and offshore delivery teams to ensure successful outcomes.

The candidate will act as the technical anchor for the engagement, leading data engineering efforts, ensuring data

Qualifications

• 10+ years of experience in Data Engineering, Analytics, and Cloud Data Platforms.
• Strong hands-on experience with Google BigQuery.
• Hands-on Cloud Composer / Airflow using Python.
• Advanced SQL development, debugging, and performance tuning.
• Experience in large-scale Data Migration and Data Modernization programs.
• Understanding of data modeling, ETL/ELT frameworks, and data warehousing concepts.
• Experience with structured and semi-structured datasets.
• Knowledge of GCP services such as Cloud Storage, Dataflow, Dataproc, IAM, Monitoring, and Logging.
• Experience with CI/CD pipelines and DevOps practices in cloud environments.
• Understanding of Agile delivery methodologies.

Responsibilities

• Lead end-to-end design and delivery of GCP-based data engineering and migration solutions.
• Design, develop, and optimize scalable data pipelines using Cloud Composer (Airflow) and Python.
• Build and manage enterprise data warehouses and analytics solutions using BigQuery.
• Perform complex SQL troubleshooting, query optimization, and data validation across large datasets.
• Drive data migration initiatives from legacy platforms to GCP while ensuring data integrity and regulatory compliance.
• Conduct data analysis to identify quality issues, transformation requirements, and optimization opportunities.
• Collaborate with business users, data architects, and cross-functional teams to translate requirements into scalable solutions.
• Review code, enforce engineering best practices, and provide technical leadership to development teams.
• Coordinate with QA teams to define test strategies, perform data reconciliation, and support defect resolution.
• Support production deployments, troubleshooting, performance tuning, and operational excellence initiatives.

Skills

BigQuery

Airflow

Python

SQL

Data Modeling

ETL/ELT

GCP

Data Migration

CI/CD

Tools

Cloud Composer

Cloud Storage

Dataflow

Dataproc

IAM

Monitoring

Job description

Long Finch Technologies is seeking a Senior GCP Data Engineering Lead responsible for guiding large-scale cloud data modernization, migrations, and analytics initiatives on Google Cloud Platform. The role emphasizes hands-on expertise in BigQuery, Airflow, Python, and SQL optimization while partnering with stakeholders and offshore delivery teams to ensure successful outcomes.

The candidate will act as the technical anchor for the engagement, leading data engineering efforts, ensuring data