Role & responsibilities

Key Responsibilities:

- Design and develop BI solutions using Looker, Looker Studio, Power BI, and Tableau.
- Build and maintain LookML models, views, explores, dimensions, and measures.
- Design scalable data models using Star Schema, Snowflake Schema, and Data Vault.
- Develop and optimize SQL queries, CTEs, window functions, and reporting logic.
- Build data pipelines using dbt, Dataflow, Informatica, and Airflow.
- Create executive dashboards, KPI scorecards, operational reports, and self-service analytics solutions.
- Implement data governance, data quality standards, and security controls.
- Optimize BI performance through query tuning, caching, and aggregate awareness.

Required Skills:

- BI Tools: Looker, Looker Studio, Power BI, Tableau.
- LookML: Views, Explores, PDTs, Dimensions, Measures, Sets.
- Data Modeling: Star Schema, Snowflake Schema, Data Vault.
- SQL: Advanced SQL, Window Functions, CTEs, Query Optimization.
- Data Warehousing: BigQuery, Partitioning, Clustering, Materialized Views.
- ETL/ELT: dbt, Dataflow, Informatica, Airflow.
- Programming: SQL, Python.

Preferred candidate profile

📌 Looker Expert (Bengaluru)
🏢 Tata Consultancy Services
📍 Bengaluru