Key Responsibilities:
- Design, develop, and optimize interactive dashboards using Looker and LookerML.
- Work with BigQuery to create efficient data models and queries for visualization.
- Develop LookML models, explores, and derived tables to support business intelligence needs.
- Optimize dashboard performance by implementing best practices in data aggregation and visualization.
- Collaborate with data engineers, analysts, and business teams to understand requirements and translate them into actionable insights.
- Implement security and governance policies within Looker to ensure data integrity and controlled access.
- Leverage Google Cloud Platform (GCP) services to build scalable and reliable data solutions.
- Maintain documentation and provide training to stakeholders on using Looker dashboards effectively.
- Troubleshoot and resolve issues related to dashboard performance, data accuracy, and visualization constraints.
- Maintain and optimize existing Looker dashboards and reports to ensure continuity and alignment with business KPIs
- Understand, audit, and enhance existing LookerML models to ensure data integrity and performance
- Build new dashboards and data visualizations based on business requirements and stakeholder input
- Collaborate with data engineers to define and validate data pipelines required for dashboard development and ensure the timely availability of clean, structured data
- Document existing and new Looker assets and processes to support knowledge transfer, scalability, and maintenance
- Support the transition/handover process by acquiring detailed knowledge of legacy implementations and ensuring a smooth takeover
Required Skills & Experience:
- 5-8 years of experience in data visualization and business intelligence using Looker and LookerML.
- Strong proficiency in writing and optimizing SQL queries, especially for BigQuery.
- Experience in Google Cloud Platform (GCP), particularly with BigQuery and related data services.
- Solid understanding of data modeling, ETL processes, and database structures.
- Familiarity with data governance, security, and access controls in Looker.
- Strong analytical skills and the ability to translate business requirements into technical solutions.
- Excellent communication and collaboration skills.
- Expertise in Looker and LookerML, including Explore creation, Views, and derived tables
- Strong SQL skills for data exploration, transformation, and validation
- Experience in BI solution lifecycle management (build, test, deploy, maintain)
- Excellent documentation and stakeholder communication skills for handovers and ongoing alignment
- Strong data visualization and storytelling abilities, focusing on user-centric design and clarity
Preferred Qualifications:
- Experience working in the media industry (OTT, DTH, Web) and handling large-scale media datasets.
- Knowledge of other BI tools like Tableau, Power BI, or Data Studio is a plus.
- Experience with Python or scripting languages for automation and data processing.
- Understanding of machine learning or predictive analytics is an advantage.
