We are building a centralised marketing and sales analytics platform for a large multi-market consumer brand: a governed BigQuery data layer feeding a single, certified Power BI reporting product used by head-office marketing and sales teams and by every national market. It replaces a fragmented estate of hand-built, per-market dashboards and manual spreadsheet exports with one version of the truth.

You will own the Power BI half of that platform end to end — the semantic model, the KPI logic, every report page, and the executive PDF report generated from it. This is not a dashboard-assembly role. One model and one report template must serve every market through filtering, hold up under executive scrutiny, and reconcile to source platforms on demand.

Experience: 3 - 6 Years

Location: Kolkata (Onsite)

‍Key Responsibilities

‍

Strategic Marketing & Brand Building

• Design, build and own the certified Power BI semantic model over a governed star schema in the cloud warehouse — relationships, cardinality, role-playing dates, hierarchies and field-level documentation.




• Choose and justify the connectivity approach (Import, DirectQuery or composite), and implement incremental refresh, aggregations and partitioning to keep refresh windows and query response inside agreed service levels.
• Author the KPI layer in DAX: a frozen, documented catalogue of measures covering traffic, engagement, conversion and funnel performance, with consistent year-on-year, year-to-date, quarter-on-quarter and custom period-comparison logic.
• Implement weighted and normalised benchmark measures so small and large markets can be compared fairly against a group average.
• Keep the model performant and maintainable — calculation groups, variables, disciplined measure structure, and regular tuning with Performance Analyzer, DAX Studio and Tabular Editor.

‍

Report And Experience Design

• Build the report pages the business actually asked for: a real-time KPI tracker with progress-to-target

📌 Senior Power BI Engineer (Kolkata)
🏢 Web Spiders
📍 Kolkata