GCP Data Engineer - Senior Consultant

At EY, we’re all in to shape your future with confidence.

We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.

Join EY and help to build a better working world.

Job Title: Senior Consultant – GCP Data Engineering

Experience Level:

3–6 years

Role Overview

We are looking for a hands-on Senior Consultant with 3–6 years of experience in GCP Data Engineering to design and deliver scalable data solutions on Google Cloud. This role requires strong practical expertise in BigQuery, Dataflow, and core GCP data services, along with the ability to work closely with stakeholders in an agile consulting environment.

Domain exposure to Oil & Gas, Energy, or Banking will be an added advantage.

Key Responsibilities

• Develop and implement data pipelines (batch and streaming) using Dataflow (Apache Beam)

• Design and optimize BigQuery-based data warehouses and data marts

• Work on data ingestion, transformation, and loading (ETL/ELT) using GCP services like Cloud Storage, Pub/Sub

• Collaborate with business teams to understand requirements and convert them into scalable data solutions

• Ensure data quality, performance, and cost optimization across GCP workloads

• Support data modeling activities (dimensional and normalized models)

• Assist in solution design and architecture discussions

• Troubleshoot pipeline performance issues and optimize processing

• Contribute to CI/CD and deployment automation for data pipelines

• Work within agile teams and support sprint-based delivery

Required Skills & Qualifications

Core Technical Skills

Hands-on experience in:

• BigQuery (SQL, data modeling, performance tuning basics)

• Dataflow (batch pipelines; exposure to streaming is a plus)

• GCP services: Cloud Storage, Pub/Sub

Strong understanding of:

• ETL/ELT processes and data pipeline design

• Data warehousing concepts

Exposure to:

Cloud Composer (Airflow) or any workflow orchestration tools

Preferred Skills

Working knowledge of:

• Dataproc, Bigtable, Looker / Power BI

Basic understanding of:

• Infrastructure as Code (Terraform)

• CI/CD pipelines

• GCP certification (Associate or Professional Data Engineer) is a plus

Domain Experience (Good to Have)

Exposure to:

• Oil & Gas or Energy sectors (asset, operations, or IoT data)

• Banking / Financial Services (reporting, transactions, regulatory data)

Soft Skills

• Good problem-solving and analytical skills

• Effective communication and stakeholder interaction

• Ability to work in a collaborative and fast-paced agile environment

• Eagerness to learn and upskill on GCP technologies

EY | Building a better working world

EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.

Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.

EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.