GCP Data Engineer

Hiring GCP Data Engineers having 6+ years of experience for big4 firm.
Location: Bangalore
Job Summary:
We are seeking a highly skilled Senior Google BigQuery Data Engineer to lead the design, development,
and optimization of our data platform. The ideal candidate will have a deep understanding of BigQuery's
architecture, capabilities, and best practices, including columnar storage, nested and repeated fields, and
separation of compute and storage. A proven track record of delivering complex data warehousing
solutions on the Google Cloud Platform (GCP) is essential.
Responsibilities:
• Architect, design, and implement scalable data solutions leveraging Google BigQuery as the
core data warehouse platform, utilizing features such as partitioning, clustering, and materialized
views for optimal performance.
• Develop and optimize complex SQL queries and data pipelines using BigQuery for efficient data
ingestion, transformation, and loading, including leveraging batch and streaming ingestion
methods.
• Utilize BigQuery ML or integrate with other GCP ML services to build predictive models and
derive insights from data.
• Implement data governance and security best practices within the BigQuery environment,
including data encryption, access controls, and auditing.
• Collaborate with data analysts and business stakeholders to understand data requirements and
translate them into BigQuery-based solutions, considering factors like data volume, query
complexity, and latency.
• Mentor and guide junior data engineers in BigQuery best practices, including query optimization,
performance tuning, and data modeling techniques.
• Lead data warehousing projects focused on BigQuery implementation and optimization,
considering cost-efficiency, scalability, and maintainability.
Qualifications:
• 6+ years of experience in data warehousing and business intelligence.
• In-depth expertise in Google BigQuery, including advanced query optimization, performance
tuning, and data modeling techniques.
• Strong SQL skills and proficiency in Python or other scripting languages for data processing.
• Proven experience in designing and implementing BigQuery data models and schemas,
considering normalization, denormalization, and data partitioning strategies.
• Hands-on experience with BigQuery data ingestion and extraction methods, including batch
loading, streaming ingestion, and external tables.
• Knowledge of other GCP services relevant to data engineering (e.g., Dataflow, Cloud Storage,
Looker) and their integration with BigQuery.
• Strong problem-solving, analytical, and communication skills.
• Ability to work independently and collaboratively in a fast-paced environment.
• Preferred: Google Cloud certifications (e.g., Certified Data Engineer) and experience with
machine learning or data science.
Pre-Sales Support:
• Cross functional collaboration to understand client requirements and design tailored solutions.
• Prepare and deliver technical presentations and product demonstrations to potential clients.
• Assist in the preparation of proposals and RFP responses, ensuring technical accuracy and
feasibility.
Project Delivery:
• Manage and oversee the delivery of data analytics and data warehousing projects from inception
to completion.
• Ensure projects are delivered on time, within scope, and within budget.
• Coordinate with cross-functional teams to ensure successful project execution and stakeholder
satisfaction.
• The ideal candidate should have managed and delivered complex large data sciences projects.

Work arrangement
No