Marketing Analytics & BI Analyst

P9 Farms; Pune District; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Provilac Dairy / P9 Farms Pvt. Ltd. in Pune seeks a Marketing Analytics & BI Analyst with 4+ years of BI or marketing analytics to build and maintain Power BI dashboards and manage data pipelines from SQL databases and APIs.

You will work with large marketing datasets across online and offline channels, integrate data from Meta, Google Ads, GA4 and AppsFlyer, and translate analytics into actionable business recommendations.

Qualifications

• 4+ years in BI / Data / Marketing Analytics.
• Strong Power BI experience and dashboard development.
• Advanced SQL and data modelling skills.
• Experience with large datasets and marketing KPIs.
• Proficiency in Excel or Google Sheets.

Responsibilities

• Build and maintain Power BI dashboards tracking marketing, revenue, retention and CAC.
• Integrate data from multiple sources via SQL databases and APIs.
• Write complex SQL queries and maintain data models.
• Analyze campaigns across online and offline channels and provide insights.
• Present actionable business recommendations to stakeholders.

Skills

Power BI experience

SQL querying

Data modelling

DAX & Power Query

Marketing analytics

Large datasets handling

Excel / Google Sheets

Tools

Power BI

Tableau / Looker Studio

Google BigQuery

APIs

Job description

Marketing Analytics & BI Analyst

Company: Provilac Dairy / P9 Farms Pvt. Ltd.

Location: Pune

Experience: 5+ Years

Function: Marketing / Data Analytics

Employment Type: Full-Time

About Provilac

Provilac is a fast-growing premium dairy and nutrition brand focused on high-protein, everyday nutrition.

We are best known for our High Protein Milk (25g protein per 250ml, no added protein powder) and operate across Pune, Mumbai, Hyderabad, Jaipur and Delhi NCR via D2C, subscriptions, quick commerce and retail channels.

We are building a strong data-driven marketing organization where decisions are powered by accurate and actionable insights.

About the Role

We are looking for a Marketing Analytics & BI Analyst with 4+ years of experience in BI, Data Analytics or Marketing Analytics.

This is a hands-on, dashboard-first role focused on building and maintaining Power BI dashboards, while managing the full data pipelinefrom SQL databases and APIs to cleaning, modelling, visualization and insights.

You will work with large marketing and customer datasets across multiple online and offline channels.

Key Responsibilities

1. Power BI & Dashboards

• Build and maintain automated Power BI dashboards.
• Track marketing, revenue, retention and customer metrics.
• Create KPIs, filters, segmentation and visualizations.
• Improve and optimize existing dashboards.

2. Data Integration

• Integrate data from multiple sources into a central system.
• Work with SQL databases and APIs.
• Pull data from Meta, Google Ads, GA4, AppsFlyer and offline channels.
• Clean, transform and automate data pipelines.

3. SQL & Data Modelling

• Write advanced SQL queries.
• Work with large datasets.
• Build and maintain data models.
• Ensure data accuracy and consistency.

4. Marketing Analytics (Online + Offline)

• Combine digital and offline marketing data.
• Analyze campaigns, events, influencers, activations and partnerships.
• Build a unified view of marketing performance.

5. Insights & Reporting

• Track KPIs like ROAS, CAC, CTR, CPA, revenue, retention, AOV, etc.
• Identify trends and actionable insights.
• Translate data into business recommendations.

Required Skills

Must Have:

• 4+ years in BI / Data / Marketing Analytics
• Strong Power BI experience
• Advanced SQL
• Power Query & DAX
• Data modelling experience
• Experience with large datasets
• Marketing KPI understanding
• Excel / Google Sheets proficiency

Preferred

• Google BigQuery or cloud warehouses
• API-based data integration
• Meta, Google Ads, GA4, AppsFlyer experience
• Automated reporting systems

Good to Have

• Python (Pandas, NumPy)
• Tableau / Looker Studio
• Cohort & retention analysis
• D2C / FMCG / e-commerce experience

What We Are Looking For

Someone who can independently manage the full data workflow:

Data SQL Cleaning Modelling Power BI Insights

• Build clean, automated reporting systems
• Work independently with minimal support
• Turn complex data into simple dashboards
• Deliver actionable business insights

What This Role Is NOT

• This is not an Excel reporting or MIS role.
• We are looking for a hands‑on BI professional who builds systems, not just reports.

Why Join Provilac?

• Work with a fast-growing high-protein nutrition brand
• Own the marketing analytics ecosystem
• High visibility with leadership
• Work across multiple growth channels
• Strong ownership and learning opportunity