Design, build, and optimize scalable GCP data pipelines and BigQuery data warehouses. Develop ETL/ELT workflows, implement data modeling, ensure data quality, optimize query performance and costs, maintain orchestration with Cloud Composer/Dataflow/Pub‑Sub, and automate deployments with CI/CD while enforcing security and governance.
Job Summary
ResponsibilitiesWe are seeking a skilled GCP BigQuery Data Engineer to design, develop, and optimize scalable data solutions on Google Cloud Platform (GCP). The ideal candidate will have strong expertise in BigQuery, data warehousing, ETL/ELT development, and cloud-based analytics platforms. The role involves building robust data pipelines, ensuring data quality, and enabling business insights through efficient data management practices.
Key Responsibilities
Qualifications- Design, develop, and maintain scalable data pipelines using GCP services.
- Build and optimize data warehouses and data marts using BigQuery.
- Develop ETL/ELT workflows for ingesting data from multiple sources.
- Implement data modeling techniques to support reporting and analytics requirements.
- Optimize BigQuery performance, query costs, and storage utilization.
- Work with structured, semi-structured, and streaming data sources.
- Develop and maintain workflows using Cloud Composer (Airflow), Dataflow, and Pub/Sub.
- Ensure data quality, consistency, security, and governance standards.
- Partner with business stakeholders, data analysts, and data scientists to understand data requirements.
- Monitor, troubleshoot, and enhance data platform performance.
- Implement CI/CD processes and automate deployment of data solutions.
- Follow data security and compliance best practices within GCP environments.
- BigQuery
- Cloud Storage (GCS)
- Dataflow
- Pub/Sub
- Cloud Composer (Airflow)
- Cloud Run / Cloud Functions
- Dataproc (preferred)
- Data Warehousing Concepts
- ETL/ELT Design & Development
- Data Modeling (Star Schema, Snowflake Schema)
- Data Migration and Data Integration
- Batch and Real-time Processing
- SQL (Advanced)
- Python
- Shell Scripting
- BigQuery
- SQL Databases (MySQL, PostgreSQL, SQL Server)
- NoSQL Databases (Preferred)
- Git
- CI/CD Pipelines
- Terraform (Preferred)
Required Qualifications
About UsAt Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.- Bachelor's or Master's degree in Computer Science, Information Technology, or related field.
- 4+ years of experience in Data Engineering.
- Minimum 2+ years of hands-on experience with GCP and BigQuery.
- Strong expertise in SQL query optimization and performance tuning.
- Experience building large-scale data processing solutions.
- Knowledge of cloud security, governance, and data management best practices.
- Google Cloud Professional Data Engineer Certification.
- Experience with dbt.
- Experience with Looker, Tableau, or Power BI.
- Exposure to Machine Learning data pipelines.
- Experience in Agile/Scrum development methodologies.
- Strong analytical and problem-solving skills.
- Excellent communication and stakeholder management.
- Ability to work independently in a fast-paced environment.
- Attention to detail and commitment to data quality.
- Collaborative team player with a continuous learning mindset.
Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.
We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.
Zensar Technologies Pune, Mahārāshtra, IND Office
Zensar Knowledge Park, Kharadi, Plot # 4, MIDC, Pune, Maharashtra, India, 411014
Zensar Technologies Pune, Maharashtra, IND Office
Pune, India
Similar Jobs
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Own the end-to-end testing strategy for a large, multi-market banking program. Plan incremental testing, coordinate market test leads, manage defects, define UAT and production release criteria, oversee test governance and environments, and provide executive reporting across parallel SIT and UAT cycles.
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Business Analyst supporting MREL regulatory reporting controls within Treasury Capital Management. Responsibilities include maintaining process documentation, designing and implementing controls in HELIOS, documenting data dictionaries and lineage, capturing data quality controls, and recording regulatory rules and interpretations. The role requires finance controls expertise, audit experience, stakeholder engagement, process and data analysis, and participation in change and transformation initiatives.
Top Skills:
ArisHelios
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Assess FINREP end-user computing reports for accurate data sourcing, transformation, manipulation, regulatory mapping, and Saracen upload. Produce detailed report production assessments, maintain documentation, and support end-to-end traceability to regulatory requirements. The role requires strong analytical, communication, stakeholder management, and organizational skills, with the ability to work independently and deliver under pressure amid changing priorities.
Top Skills:
FinrepGrca CodesIfrsIfrs 9ExcelMicrosoft PowerpointSaracen
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
