Data Analyst/Visualization - Looker Expert

We are looking for a sharp, articulate Data Analyst who can do much more than build dashboards. You will own the entire data journey — from pulling raw data through pipelines to delivering clear, actionable insights directly to clients. If you are someone who is equally comfortable writing a BigQuery query and presenting findings to a client, this role is built for you. What You Will Do Data Infrastructure & Pipelines • Build and maintain ETL pipelines to move data from multiple sources into a central data warehouse • Use Airbyte to connect and sync data from marketing platforms, CRMs, ad platforms, and other sources • Manage and optimize datasets in BigQuery — write clean, efficient SQL queries for reporting and analysis • Ensure data accuracy, consistency, and freshness across all client dashboards and reports • Identify and fix pipeline failures proactively before they affect reporting Reporting & Visualization • Build and maintain client-facing dashboards in Looker Studio and Power BI • Write LookML to create reusable data models, dimensions, and measures in Looker • Design dashboards that tell a clear story — not just numbers on a screen • Automate recurring reports so teams spend less time pulling data and more time acting on it Analysis & Insights • Go beyond reporting — identify trends, anomalies, and opportunities in the data • Conduct deep-dive analyses on campaign performance, traffic trends, funnel drop-offs, and conversion patterns • Translate complex data into plain language recommendations that non-technical stakeholders can act on • Work with SEO, paid media, and content teams to connect data dots across channels Python & Automation • Use Python to automate repetitive data tasks — pulling reports, cleaning data, scheduling jobs • Write scripts to connect APIs, process large datasets, and feed data into dashboards or warehouses • Build reusable Python utilities that save the team time on recurring data operations AI & Machine Learning Applications • Apply predictive analytics and forecasting models to help clients anticipate performance trends • Build or assist in building ML models relevant to marketing — customer churn prediction, lifetime value estimation, and multi-touch attribution • Use AI tools to enhance reporting — automated anomaly detection, natural language summaries of performance data, and intelligent alerts • Explore NLP techniques to analyze text data — ad copy performance, customer feedback, search query patterns What We Are Looking For • 2–4 years of experience in a data analyst role, preferably in a digital marketing or agency environment • Strong hands-on experience with BigQuery and SQL • Experience building dashboards in both Looker Studio and Power BI • Working knowledge of LookML for building data models in Looker • Hands-on experience with ETL tools — Airbyte experience is a strong plus • Understanding of marketing data sources — Google Ads, Meta Ads, GA4, Search Console, CRMs • Excellent communication skills — written and verbal, with the ability to present data clearly to non-technical clients • Detail-oriented with a strong sense of data ownership and accountability Nice to Have • Python experience for automation, API integrations, or data processing • Exposure to ML concepts — forecasting, churn modeling, LTV, or attribution models • Experience with AI-powered reporting tools or anomaly detection • Basic NLP knowledge — text classification, sentiment analysis, or search query analysis • Experience with dbt for data transformation • Familiarity with marketing attribution models • Knowledge of GA4 events, goals, and custom dimensions setup Pay: ₹25,000.00 - ₹45,000.00 per month Benefits: • Health insurance Work Location: In person