Gcp Developer - BigQuery SQL, Looker, LookML

Tata Consultancy Services; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Tata Consultancy Services in Bengaluru seeks a skilled BI specialist to develop and manage intelligent BI solutions using GCP, BigQuery, Looker, and Looker Studio. You will design semantic layers with Look-ML, write optimized SQL, and build interactive dashboards while enabling natural language data queries and AI-driven insights.

Experience with LookML, Looker, and Generative AI integrations will help you deliver real-time analytics to business stakeholders while ensuring data governance and

Qualifications

• Must have solid SQL and data modeling skills.
• Experience with LookML models and Looker projects is required.
• Proficiency with BigQuery and Looker Studio for dashboards.

Responsibilities

• BI development and data modeling.
• Design, develop, and maintain data models in Look-ML.
• Write complex SQL in BigQuery to support data transformations.
• Build and maintain dashboards using Looker and Looker Studio.
• Translate business needs into LookML models.
• Utilize Generative AI for conversational analytics and insights.
• Build conversational analytics agents integrated with Looker and BigQuery.
• Enable users to query data via natural language.
• Develop conversational agents leveraging semantic layer and data sources.
• Use AI to provide automated insights and narratives from reports.
• Manage roles and access controls in Looker to ensure governance.
• Collaborate with data engineering to integrate data sources.
• Maintain Looker projects with Git and follow best practices.
• Train users to promote platform adoption and data literacy.
• Strong SQL proficiency across the role.
• Experience developing LookML and dashboards in Looker.
• Experience with cloud data warehousing concepts and BigQuery.
• Familiarity with Generative AI tools for data analysis.

Skills

SQL proficiency

Data modeling

LookML mastery

Looker & Looker Studio

Generative AI applications

Analytical mindset

Stakeholder communication

Education

Cloud certification (AWS/GCP/Azure)

Tools

Looker

Looker Studio

BigQuery

Look-ML

Git

Cloud SQL

Spanner

AlloyDB

Job description

Role & responsibilities

• Looking for a skilled and innovative BI specialist to develop and manage our business intelligence solutions. The ideal candidate will combine strong data modeling and visualization skills with expertise in advanced analytics, leveraging Generative AI and conversational interfaces to provide real‑time, actionable insights to our stakeholders.
• This role will primarily use Google Cloud Platform (GCP) technologies, including Big Query, Looker, and Looker Studio
• BI development and data modeling
• Design, develop, and maintain data models in Look-ML to create a reliable and governed semantic layer.
• Write complex and optimized SQL queries, primarily within Google BigQuery, to support data transformation and analysis.
• Build and maintain interactive dashboards, reports, and data visualizations using Looker and Looker Studio.
• Translate complex business requirements into technical data specifications and scalable Look-ML models.
• Generative AI and conversational analytics
• Utilize Generative AI, integrated with Big-Query and Looker, to build conversational analytics agents.
• Enable business users to query data using natural language, helping them receive real‑time, plain‑language insights without extensive technical knowledge.
• Develop and configure conversational agents to provide rich, context‑aware answers by leveraging the Looker semantic layer and BigQuery data.
• Use AI to provide automated insights, summaries, and narratives based on report and dashboard data.
• Manage user roles, content permissions, and access controls within the Looker environment to ensure data security and governance.
• Work with data engineering and IT teams to ensure seamless integration of data sources and a robust data pipeline.
• Maintain and optimize Looker projects using Git for version control and adhere to best practices for development and deployment.
• Train and support technical and non‑technical end‑users to promote platform adoption and enhance data literacy.
• Strong proficiency in SQL for data manipulation, analysis, and optimization.
• Proven experience developing and maintaining LookML models and projects.
• Extensive experience building dashboards and reports in Looker and Looker Studio.
• Solid understanding of cloud data warehousing concepts, with hands‑on experience using Google BigQuery.
• Strong analytical mindset with the ability to translate business needs into technical solutions.
• Experience in designing scalable and secure BI environments.
• Familiarity with Generative AI tools and their application in data analysis and reporting.

Data Visualization (Data & Analytics)

• Data specific Hands‑on experience in at least one GCP Data Services like Big Query, Cloud SQL, Dataflow etc.
• Professional cloud certification with any CSP including AWS, GCP or Azure.
• Expert in Databases Cloud SQL, Alloy DB, Spanner etc.
  Design and implement data migration strategies for various database types (PostgreSQL, Oracle, Alloy DB etc.)
• Deep understanding of at least 1 Database type with aubility to write complex SQLs
• Deep understanding of migrating databases using various methodologies, leveraging distributed data processing frameworks, including modern analytical and transactional data stores. Hands‑on experience in implementing data pipelines that move data from source systems/databases to target datastores/databases