5 years

0 Lacs

Posted:1 week ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

This role is for one of Weekday's clientsMin Experience: 5 yearsJobType: full-time

Requirements

We are looking for an experienced and detail-oriented

BI Developer

with a strong focus on

campaign performance analysis

,

CRM analytics

, and

post-campaign insights

. The ideal candidate will have 5-7 years of experience in

CRM, campaign management, marketing analytics

, or

loyalty operations

. You will be responsible for enabling data-driven decision-making by translating complex datasets into meaningful dashboards, performance insights, and optimization strategies.This role is ideal for someone who thrives in fast-paced environments, works well with cross-functional teams, and possesses a deep understanding of marketing campaign data. If you are passionate about digging into customer behaviors, uncovering actionable insights through root cause analysis, and enabling smarter campaign strategies—this role is for you.

Key Responsibilities:

Campaign Performance Analysis

  • Analyze marketing campaign effectiveness using key performance metrics (open rates, CTR, conversions, ROI, etc.).
  • Conduct Post Campaign Analysis (PCA) to evaluate impact, uncover trends, and recommend improvements.
  • Identify what's working, what's not, and why—through Root Cause Analysis (RCA) techniques.

Data Handling & BI Reporting

  • Build and maintain scalable dashboards and reports using BI tools (e.g., Power BI, Tableau, Looker, or similar).
  • Develop SQL queries to extract and transform data from relational databases for campaign and customer analytics.
  • Use Excel for quick data exploration, modeling, and presentation where appropriate.

Cross-functional Collaboration

  • Work closely with CRM, marketing, product, tech, and data teams to align campaign goals and define KPIs.
  • Partner with loyalty and retention teams to analyze the performance of customer engagement programs.
  • Provide insights that influence targeting, segmentation, personalization, and timing of future campaigns.

Data-Driven Decision Support

  • Enable teams to make better decisions by providing insights backed by data and evidence.
  • Identify patterns and trends in customer behavior to optimize communication strategies and campaign design.
  • Proactively identify anomalies and performance deviations and propose actionable solutions.

Continuous Improvement

  • Improve campaign performance measurement frameworks by automating reporting and insight generation.
  • Contribute to building data pipelines and analytics processes that improve operational efficiency and scalability.

Key Qualifications:

  • 5-7 years of experience in roles such as CRM Analyst, Campaign Manager, Loyalty Consultant, or Marketing Operations Analyst.
  • Strong SQL skills - able to write, optimize, and debug complex queries across large datasets.
  • Hands-on expertise in at least one modern BI tool (e.g., Power BI, Tableau, Looker).
  • Advanced Excel skills, including data modeling, pivot tables, VLOOKUP/XLOOKUP, and charts.
  • Experience in Post Campaign Analysis, Root Cause Analysis, and customer segmentation techniques.
  • Strong understanding of campaign lifecycles, marketing KPIs, and performance attribution.
  • Excellent problem-solving skills, analytical thinking, and the ability to communicate technical results to non-technical stakeholders.
  • Familiarity with customer lifecycle marketing, loyalty programs, and CRM systems is a plus

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You

Mumbai, Maharashtra, India

Gurugram, Haryana, India