Weekday is hiring a BI Developer to empower data-driven decision-making by transforming complex datasets into actionable dashboards and insights. This role focuses on campaign performance analysis, CRM analytics, and deriving post-campaign insights to optimize marketing strategies. The ideal candidate thrives in a fast-paced, cross-functional environment.

What You'll Do

Analyze marketing campaign effectiveness using key performance metrics (open rates, CTR, conversions, ROI).
Conduct Post Campaign Analysis (PCA) to evaluate impact, uncover trends, and recommend improvements.
Perform Root Cause Analysis (RCA) to identify what’s working, what’s not, and why.
Build and maintain scalable dashboards and reports using BI tools like Power BI, Tableau, or Looker.
Develop SQL queries to extract and transform data from relational databases for analytics.
Use Excel for quick data exploration, modeling, and presentation.
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 customer engagement program performance.
Provide insights that influence targeting, segmentation, personalization, and campaign timing.
Enable teams to make better decisions by providing evidence-backed insights.
Identify patterns in customer behavior to optimize communication strategies and campaign design.
Proactively identify anomalies and performance deviations and propose actionable solutions.
Improve campaign performance measurement frameworks by automating reporting.
Contribute to building data pipelines and analytics processes for efficiency and scalability.

What We're Looking For

5–7 years of experience as a CRM Analyst, Campaign Manager, Loyalty Consultant, or Marketing Operations Analyst.
Strong SQL skills with the ability to write, optimize, and debug complex queries across large datasets.
Hands-on expertise in at least one modern BI tool such as Power BI, Tableau, or Looker.
Advanced Excel skills, including data modeling, pivot tables, VLOOKUP/XLOOKUP, and charts.
Experience in Post Campaign Analysis, Root Cause Analysis, and customer segmentation.
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.