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.
Nice to Have
- Familiarity with customer lifecycle marketing, loyalty programs, and CRM systems.
Technical Stack
- SQL
- Power BI
- Tableau
- Looker
- Excel
Team & Environment
You will work closely with CRM, marketing, product, tech, and data teams.
