Job Title GCP BigQuery Developer Role Summary We are seeking a skilled GCP BigQuery Developer to design, build, and maintain curated data marts on Google BigQuery. The role focuses on transforming raw data from the enterprise data lake into high-quality, analyticsready datasets that support reporting, dashboards, and advanced analytics use cases. The ideal candidate has deep expertise in ANSI-SQL, strong experience with complex data transformations, and a solid understanding of data modeling principles in a cloud-based analytics environment.

Key Responsibilities
• Design, develop, and maintain data marts on BigQuery sourced from raw and semi-structured data in the data lake
• Perform complex data transformations, aggregations, normalization, and denormalization using ANSI-SQL
• Develop and optimize complex SQL queries for performance, scalability, and cost efficiency in BigQuery
• Implement and maintain BigQuery stored procedures and userdefined functions (UDFs)
• Apply data modeling best practices to support analytical and reporting requirements
• Ensure data quality, consistency, and reliability across curated datasets
• Collaborate with data engineers, analysts, and stakeholders to understand data requirements and translate them into scalable solutions
• Monitor and troubleshoot query performance and data pipeline issues




• Document data models, transformations, and SQL logic for maintainability and knowledge sharing 2 INTERNAL Required Skills & Competencies
• Solid hands-on experience with Google BigQuery
• Excellent proficiency in ANSI-SQL, including: o Complex joins and subqueries o Window functions o Aggregations and advanced transformations
• Working knowledge of BigQuery stored procedures and functions (UDFs)
• Solid understanding of data warehousing and data mart design concepts
• Experience working with large-scale datasets in a cloud data lake architecture
• Ability to optimize SQL for performance and cost in BigQuery Qualifications & Experience
• Bachelor’s degree from a reputed institution / university in Data Analytics, Computer Science, Information Systems, or a related field
• 3-4 years of working experience in GCP-BigQuery, while having
- o Familiarity with GCP-BigQuery’s Data Partitioning techniques o Query optimisation techniques o Understanding of data governance, security, and access controls in GCP o Experience supporting BI and analytics tools consuming BigQuery datasets Pay: ₹1,000,000.00
- ₹1,200,000.00 per year

Benefits:
- Paid time off Work

Location:
Hybrid remote in Mahape, Maharashtra

📌 GCP BigQuery Developer (Mahape)
🏢 FuGenEd(An Incubation Center)
📍 Mahape