Senior Analyst BI – Retail/CPG Domain

Job Summary

We are seeking an experienced BI Consultant to support the migration of enterprise supply chain and finance reports from MicroStrategy to Metabase. The role involves rebuilding and optimizing BI reports, validating data accuracy, and partnering closely with supply chain, finance, and data engineering teams to ensure seamless business continuity and improved analytics performance.

The ideal candidate brings strong SQL expertise, practical BI best practices, and the ability to translate complex business requirements into scalable, high-quality dashboards.

Responsibilities

Key Responsibilities

· Lead migration of invoice, receipt, and procurement reports from MicroStrategy to Metabase

· Translate MicroStrategy metrics, filters, prompts, and hierarchies into Metabase models and dashboards

· Design and develop interactive Metabase dashboards that deliver actionable, business-ready insights

· Design and optimize semantic layers / views for Metabase consumption

· Rebuild, enhance and optimize enterprise BI dashboards using Metabase (SQL editor, dashboards, filters, permissions)

· Perform data validation, reconciliation, and UAT support to ensure accuracy

· Write and optimize complex SQL queries (joins, CTEs, window functions, performance tuning)

· Collaborate with Analytics and Data engineering teams to gather requirements and resolve data issues

· Ensure BI best practices for performance, scalability, security, and usability

· Troubleshoot reporting issues and proactively recommend improvements

· Lead client communication, manage project deliverables, and actively participate in an Agile delivery model to ensure timely and high-quality outcomes

· Support documentation, knowledge transfer, and handover activities

Qualifications

Required Skills & Qualifications

· Strong hands-on experience with BI: Dashboards, SQL editor, parameters/filters, permissions

· Experience working with MicroStrategy (or similar BI tools such as Tableau, Cognos, BusinessObjects)

· Advanced SQL expertise

o Complex joins, CTEs, window functions

o Query optimization and performance tuning

· Experience with cloud data warehouses, preferably IBM Db2

· Experience working on BI reports for invoices, receipts, purchase orders (PO), GRN, AP aging, and vendor performance metrics.

· Strong understanding of BI architecture and reporting best practices

· Proven experience in data validation, reconciliation, and accuracy checks

· Strong communication and stakeholder management skills

· Ability to translate business requirements into technical solutions

· Strong problem-solving and analytical thinking

· Ability to work independently in fast-paced, deadline-driven environments