GCP Bigquery

About the job:

Join a collaborative data engineering team where your work directly powers analytics, reporting, and smarter business decisions. In this role, you’ll help build and optimize cloud-native data solutions on Google Cloud, working hands-on with BigQuery, Dataproc, and GCS to deliver reliable, scalable pipelines. You’ll partner closely with analysts, engineers, and stakeholders to understand data needs, translate them into efficient datasets, and ensure data is accurate, secure, and ready for consumption. If you enjoy solving performance challenges, improving data quality, and creating clean, well-governed data models that teams can trust, this is a great opportunity to grow your impact while working in a supportive, high-ownership environment.

Responsibilities

Key Responsibilities:

Design, develop, and maintain BigQuery datasets, tables, views, and SQL transformations aligned to analytics and reporting needs.

Build and support ETL/ELT pipelines leveraging GCS for ingestion and Dataproc for distributed processing where required.

Optimize BigQuery performance and cost through partitioning, clustering, query tuning, and efficient data modeling practices.

Implement data quality checks, validation routines, and reconciliation processes to ensure trustworthy outputs.

Collaborate with cross-functional teams to gather requirements, define data contracts, and deliver curated datasets.

Monitor pipeline health, troubleshoot failures, perform root-cause analysis, and drive timely resolution.

Maintain clear technical documentation for pipelines, datasets, transformations, and operational runbooks.

Follow secure data handling practices and support access controls and governance standards within GCP.

Minimum Qualifications:

Education: BTECH, MTECH, MCA, MSC.

3–5 years of experience in data engineering or analytics engineering roles with hands-on BigQuery usage.

Strong SQL skills with experience building transformations, aggregations, and analytical datasets in BigQuery.

Experience working with ETL/ELT concepts, batch processing, and data pipeline troubleshooting.

Working knowledge of GCS for data storage, ingestion patterns, and lifecycle handling.

Exposure to Dataproc for Spark/Hadoop-based processing and job execution in GCP environments.

Technical requirements

Good to have skills:

Cloud Composer, Dataflow, Pub/Sub, Looker, Terraform

Additional responsibilities

Preferred Qualifications:

Experience designing dimensional or curated data models (e.g., star/snowflake) for analytics consumption in BigQuery.

Familiarity with orchestration and scheduling approaches for ETL workflows and dependency management.

Proven ability to improve pipeline reliability and performance through monitoring, alerting, and operational best practices.

Experience with data governance practices including dataset organization, access management, and documentation standards.

Strong stakeholder collaboration skills to translate business requirements into scalable, maintainable data solutions.

Education

MCA,MSc,MTech,Bachelor of Engineering,BTech