Senior Power BI Developer Loyalty & Customer Analytics

Experience: 5–7 years in BI and reporting, including at least 4 years of hands-on Power BI development

Location: Mumbai / Hybrid. Must be available for a daily overlap of 2–3 hours with US Eastern Time for client meetings.

Role Summary

We are looking for a Senior Power BI Developer to design and build a suite of loyalty, credit card and customer lifecycle dashboards for a US fashion retail client, replacing and improving their existing reports.

This is a hands-on role and the only BI developer on a three-person team. Every dashboard must be viewable by program, brand, channel, membership tier and cardholder status, across fiscal weeks, quarters, years and custom date ranges.

Key Responsibilities

- Review the client’s existing reports with the Business Analyst and recommend improvements in design and usability.
- Design and build Power BI semantic models (star schema) that support multiple views of every metric: total program, brand, channel, tier and cardholder status.
- Build time intelligence on a custom retail fiscal calendar, including year-over-year, month-over-month, quarter-to-date, year-to-date, rolling 12 months and custom date ranges.
- Develop advanced DAX measures for loyalty and customer KPIs, such as member penetration, retention, redemption, tier movement and points liability.
- Design clear, consistent dashboards, from one-page executive summaries to detailed drill-down reports and create mock-ups for client review.
- Implement Row-Level Security (RLS) and report access controls.
- Optimize performance for large datasets using aggregations, incremental refresh and efficient model design.
- Manage Power BI Service: workspaces, deployment pipelines, gateways, scheduled refresh and user access.
- Work with the Business Analyst and Data Engineer to validate dashboard figures, and troubleshoot data discrepancies and refresh failures.




- Set Power BI development standards for the project, and create documentation, user guides and training for handover to the client team.
- Support UAT, production deployment and ongoing enhancements.

Required Skills

- 5+ years of hands-on Power BI development in enterprise environments.
- Advanced DAX, including time intelligence with custom fiscal calendars.
- Data modeling (star and snowflake schema) and Power Query (M).
- Advanced SQL and query optimization.
- Performance tuning using tools such as DAX Studio and Tabular Editor.
- Row-Level Security, report governance and Power BI Service administration.
- Dashboard design and data visualization best practices.
- Data validation and reconciliation.
- Confidence presenting dashboards and gathering feedback directly from client stakeholders.
- Strong analytical and problem-solving skills.

Preferred Technologies

- Power BI Desktop and Power BI Service
- Microsoft Fabric
- DAX Studio, Tabular Editor
- SQL Server, Snowflake
- Git, Azure DevOps / JIRA

Preferred Domain Experience

- Retail or e-commerce analytics
- Loyalty and customer analytics
- CRM and customer engagement
- Marketing analytics

Good to Have

- Knowledge of loyalty and rewards programs and KPIs such as active members, CLV, retention, churn, redemption rate and incremental revenue.
- Experience building executive leadership dashboards.
- Exposure to Customer 360, campaign analytics and marketing performance reporting.

Education

- Bachelor’s degree in engineering, Computer Science, Information Technology, Statistics, Mathematics or a related discipline.
- Microsoft certifications such as PL-300 (Power BI Data Analyst) or DP-600 (Fabric Analytics Engineer) preferred.

Ideal Candidate

A senior, hands-on Power BI developer who can independently design data models and build polished dashboards for business users. They have robust experience with fiscal calendar time intelligence and performance tuning and are comfortable presenting their work directly to clients.

📌 Power Bi Developer (Mumbai)
🏢 Lumina Datamatics
📍 Mumbai