13 Nov
|
SWITS DIGITAL Private
|
India
13 Nov
SWITS DIGITAL Private
India
Job Title-Google Bigquery & Looker Developer Experience-5+ years Location
- Bangalore
Job Description
• Strong hands-on experience in Google BigQuery, advanced SQL, and enterprise data warehousing.
• Proficiency in Looker and LookML development, including dashboards, data modelling, Explores, and reporting.
• Advanced knowledge of Python programming for data processing, automation, and integration.
• Hands-on experience with Google Dataflow and ETL/ELT pipeline development.
• Practical experience in data warehouse migration projects to GCP/BigQuery, including migration planning, data conversion, validation, and reconciliation.
• Solid understanding of data modelling, dimensional modelling, data integration, and data warehouse architecture.
• Experience in query optimization, performance tuning, data quality, cloud data security, technical leadership, and stakeholder management. Good-to-Have Skills
• Google Cloud Platform (GCP) services and architecture.
• Experience migrating SQL Server, Oracle, Teradata, or other enterprise data warehouse platforms to BigQuery.
• Cloud Storage, Cloud Composer, Dataform/dbt.
• Git, CI/CD, and deployment automation.
• Experience with cloud-based data modernization and legacy data warehouse transformation initiatives. Roles & Responsibilities
• Lead the design, development, and implementation of scalable data solutions using Google BigQuery, SQL, Python, and Google Dataflow.
• Design and develop data warehouse models, complex SQL queries, views, stored procedures,
and optimized data transformation processes.
• Develop and maintain ETL/ELT pipelines, including data ingestion, transformation, integration, and incremental data loading.
• Develop and maintain Looker dashboards, reports, LookML models, Explores, dimensions, and measures for business reporting and analytics.
• Collaborate with business stakeholders and cross-functional teams to understand requirements and translate them into effective technical solutions.
• Lead and contribute to data warehouse migration projects from traditional platforms such as SQL Server, Oracle, Teradata, or other enterprise data warehouses to Google Cloud Platform (GCP) and BigQuery.
• Perform migration assessment, source-to-target mapping, data transformation, reconciliation, validation, and performance optimization to ensure successful migration to GCP.
• Ensure data quality, data validation, security, and governance standards across data engineering and reporting solutions.
• Optimize BigQuery query performance, data processing, and cost efficiency through partitioning, clustering, and query optimization.
• Provide technical guidance, mentorship, and code review support to team members while ensuring adherence to development best practices.
• Monitor and troubleshoot data pipelines, scheduled jobs, dashboards, and production issues, ensuring timely resolution and continuous improvement.
• Drive technical design discussions, solution architecture, development standards, and deployment activities in collaboration with project stakeholders.
📌 Google BigQuery (India)
🏢 SWITS DIGITAL Private
📍 India