Marketing Analytics & BI Analyst

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

You should be able to:

- 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

Apply

If you enjoy Power BI, data, and marketing analytics, and can turn data into insights, wed love to hear from you.

Apply with your CV and Power BI/dashboard samples.