Lead Data Engineer 2

Job Title - Lead Data Engineer – Specialist - ACS SONG 

Management Level: Level 9 - Specialist

Location: Kochi, Coimbatore, Trivandrum

Must have skills:  GCP services, BigQuery, Python, and SQL. 

Good to have skills: BI and Analytical Tool          

Experience: 5 -8 years of experience is required

Educational Qualification: Graduation

Job Summary

We are seeking a Lead Data Engineer specializing in Google Cloud Platform (GCP) and BigQuery with 5+ years of experience in data engineering, cloud-based data platforms, data pipelines, SQL development, and large-scale data processing. The role will focus on designing, developing, and optimizing scalable data pipelines and analytics solutions using BigQuery and other GCP data services. 

Roles and Responsibilities

• The ideal candidate should have strong hands-on experience with BigQuery, Python, SQL, Cloud Storage, Dataflow, Pub/Sub, Dataproc, and Cloud Composer, along with a solid understanding of ETL/ELT, data warehouse, data lake, and modern cloud data architecture principles. 
•  This position requires the ability to independently design and deliver production-grade data solutions, optimize performance and cost, troubleshoot complex data issues, and collaborate closely with architects, data scientists, analysts, application teams, and business stakeholders. 
• Design, develop, and maintain scalable data pipelines and data processing solutions using GCP services, BigQuery, Python, and SQL. 
• Build reliable and high-performance data transformation and integration workflows supporting reporting, analytics, machine learning, and downstream business applications. 
• Drive improvements in data quality, pipeline performance, BigQuery optimization, cost efficiency, monitoring, security, and production stability. 
• Provide technical guidance and contribute to the adoption of modern GCP data engineering architecture, standards, and development best practices. 
• Design, develop, and maintain batch and real-time data pipelines using BigQuery, Cloud Storage, Dataflow, Pub/Sub, Dataproc, Cloud Composer, Python, and SQL. 
• Develop ETL/ELT solutions for ingesting, transforming, and integrating structured, semi-structured, and unstructured data from multiple source systems. 
• Design and maintain scalable BigQuery datasets, tables, views, materialized views, partitioning, clustering, and data models for analytics and reporting workloads. 
• Optimize BigQuery SQL queries, storage structures, data processing workloads, and pipeline architecture to improve performance and control cloud consumption costs. 
• Build and maintain batch and streaming data processing solutions using services such as Dataflow, Pub/Sub, Dataproc, and BigQuery. 
• Design curated data layers, reusable datasets, and data models supporting enterprise analytics, BI, machine learning, and downstream applications. 
• Implement data validation, reconciliation, data quality checks, error handling, lineage, monitoring, alerting, and operational controls. 
• Orchestrate data pipelines and workflows using Cloud Composer / Apache Airflow, Workflows, or equivalent orchestration technologies. 
• Collaborate with solution architects, data architects, data scientists, analysts, application teams, and business stakeholders to translate requirements into scalable technical solutions. 
• ·  Follow and promote engineering best practices covering Git-based development, automated testing, CI/CD, Infrastructure as Code, documentation, monitoring, security, and production support.