Senior Power BI Engineer

Web Spiders; Kolkata District; On-site; INR 2,400,000 - 3,600,000; Full time

Job summary

Web Spiders seeks a senior Power BI analytics engineer to own the Power BI half of a centralised marketing and sales analytics platform. You will craft the semantic model, KPI logic, all report pages, and the executive PDF report generated from it, serving multiple markets from a single, governed data layer.

You will design scalable, secure, and reusable BI solutions with strong DAX, SQL, and data modelling skills, collaborating with stakeholders across marketing and sales teams in Kolkata on

Qualifications

• 6+ years in business intelligence or analytics engineering.
• Advanced DAX with time intelligence and performance-conscious design.
• Semantic model design over a dimensional warehouse with star schema and incremental refresh.
• Strong SQL and cloud data warehouse querying (BigQuery preferred).
• Experience modelling GA4 event-level exports in a warehouse.
• Paginated reports and export automation for pixel-accurate PDFs.
• Ability to design consistent, executive-friendly dashboards and KPI logic.
• Proficient in Power Query / M and deployment discipline.
• Excellent written and spoken English.

Responsibilities

• Design and own the certified Power BI semantic model end-to-end.
• Choose connectivity approach and implement incremental refresh and partitioning.
• Author the KPI layer and measures with robust year-on-year and period logic.
• Develop benchmarking measures for multi-market comparison.
• Maintain performance and implement security in the model and reports.
• Build real-time KPI trackers, market vs group benchmarking, and funnels.
• Automate the executive PDF reports from the platform.
• Ensure data quality, variances, and reconciliation with source systems.
• Write model and report documentation and handover material.

Skills

Power BI

DAX

Semantic model design

SQL

BigQuery

GA4 data modelling

Paginated reports

Power Query / M

English communication

Tools

Power BI Report Builder

BigQuery

Snowflake/Redshift/Synapse

Tabular Editor

Job description

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, market-versus-group benchmarking, product-level performance, an end-to-end lead-to-order funnel with banded performance thresholds, channel and traffic-source analysis, and social performance.
• Design for flexible self-service: independent metric selection per visual, multi-market comparison, switchable chart types, and free choice of reporting and comparison periods — without users needing to export anything.
• Apply a consistent, accessible visual language across every page: clear labelling, sensible visual hierarchy, and charts rather than dense tables.
• Configure workspaces, apps, audiences and deployment pipelines across development, test and production, and implement row-level security where required.

Executive reporting layer

• Build and automate the recurring executive PDF report generated directly from the platform, using paginated reports and export automation, so a market or period can be selected and a complete, correctly formatted pack produced in one action.
• Ensure exported visuals remain visuals — presentation-ready output, not screenshots of tables.

Quality, reconciliation and trust

• Build data quality and anomaly surfacing into the reporting layer: freshness indicators, missing-period detection, and outlier alerting on unexpected drops or spikes.
• Reconcile platform figures against the underlying source platforms, document the variances that are structurally expected, and explain them clearly to non-technical stakeholders before they are discovered in a meeting.
• Write and maintain the model and report documentation, KPI definitions and handover material.

Delivery

• Work to a gated, fixed-scope delivery plan with hard go-live dates, translating business requirements into agreed KPI definitions and report specifications.
• Run user acceptance testing on a reference market, manage a controlled review-and-revision cycle per report page, and support training and handover.

Required Skills & Qualifications

• 6+ years in business intelligence or analytics engineering, with at least 4 years hands-on in Power BI on production, business-critical reporting.
• Advanced DAX — time intelligence, calculation groups, context transition, performance-conscious measure design. You can explain why a measure is slow, not just that it is.
• Proven semantic model design over a dimensional warehouse: star schema, incremental refresh, composite models, aggregations, gateways and capacity considerations.
• Strong SQL, and practical experience querying a cloud data warehouse (BigQuery preferred; Snowflake, Redshift or Synapse considered) with an understanding of partitioning, clustering and query cost.
• Direct experience modelling digital analytics data — particularly GA4 event-level exports in a warehouse, including nested and repeated structures, sessionisation and conversion definitions. This is the single most important differentiator for this role.
• Paginated reports (Power BI Report Builder / RDL) and export automation for pixel-accurate PDF output.
• Report and dashboard design judgement — you can take a vague executive requirement and produce something that answers it in seconds, and you can defend your layout decisions.
• Power Query / M for shaping and troubleshooting, and comfort with source-control and deployment discipline.
• Confident written and spoken English, and the composure to present work directly to senior stakeholders and take feedback in the room.

Desirable

• Marketing, media or e-commerce measurement background — an understanding of what marketers and sales leadership actually need to see.
• Working knowledge of consent management and its effect on reported figures, and how modelled data behaves differently across interfaces and warehouse exports.
• Microsoft Fabric, Power BI Premium / Fabric capacity administration.
• Multi-market or multi-tenant reporting at scale, including row-level security design.
• dbt or an equivalent transformation framework; Python for supporting automation.
• Custom or advanced visuals (for example Deneb / Vega-Lite) where the standard library falls short.
• Relevant Microsoft certification (PL-300 or equivalent) — useful, but the portfolio matters more.

Interview Process

• Application review
• 5–10 minute initial screening call with the TA team
• Technical interviews {Domain specific}
• Practical test conducted in the presence of a panel member
• Role match & offer