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: 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 visuals, marke

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