Senior Power BI Engineer

Web Spiders Group

Kolkata

On-site

INR 1,000,000 - 1,800,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Web Spiders Group is building a centralised marketing and sales analytics platform. You will own the Power BI half of the platform end‑to‑end, delivering a single, scalable semantic model and the executive PDF reports used across markets.

You will craft KPI logic, optimize performance, enforce security, and enable self‑service reporting for marketing and sales leadership. Onsite in Kolkata, 3–6 years BI/analytics engineering experience required.

Qualifications

  • 4+ years in business intelligence or analytics engineering.
  • Advanced DAX — time intelligence and performance‑conscious measures.
  • Semantic model design over a dimensional warehouse: star schema and incremental refresh.
  • Strong SQL and cloud data warehouse querying (BigQuery preferred).
  • Experience with GA4 event‑level exports and nested structures.

Responsibilities

  • Design and own the certified Power BI semantic model in the cloud warehouse.
  • Implement incremental refresh, aggregations and partitioning to meet SLAs.
  • Develop KPI measures with consistent time intelligence and cross‑market comparability.
  • Build self‑service friendly reports with flexible period and market comparisons.
  • Automate executive PDF reports and ensure visuals stay pixel‑perfect.
  • Apply data quality, anomaly detection and variance reconciliation in reporting.

Skills

Power BI
DAX
SQL
BigQuery
GA4 data
Paginated reports
Power Query
Fabric
dbt
Python
Deneb/Vega-Lite
PL‑300

Tools

Power BI
Power BI Report Builder
DAX Studio
Tabular Editor
BigQuery

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.

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 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:
  • 4+ years in business intelligence or analytics engineering, with at least 3 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.
  • 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
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

BI Lead (Power BI / Tableau)
BI Lead (Power BI / Tableau)

EXL • Gurugram District

On-site
INR 1,800,000 - 2,400,000
PowerBI Developer
PowerBI Developer

Anthesis Group • Pune District

On-site
INR 1,500,000 - 2,500,000
Power BI Lead
Power BI Lead

EXL • Gurugram District, Bengaluru

On-site
INR 3,000,000 - 4,000,000
Power BI Developer
Power BI Developer

Weekday • Gurugram District

On-site
INR 1,200,000 - 2,400,000
Power BI Developer
Power BI Developer

Weekday • Maharashtra

On-site
INR 900,000 - 1,300,000
Power BI Developer
Power BI Developer

Weekday • Bengaluru

On-site
INR 1,400,000 - 2,200,000
PowerBi Developer
PowerBi Developer

Anthesis Esp • India

On-site
INR 1,800,000 - 3,200,000
Senior Power BI Developer
Senior Power BI Developer

Willware • Bengaluru

Hybrid
INR 2,800,000 - 4,200,000
LEAD POWER BI DEVLOPER
LEAD POWER BI DEVLOPER

AxiTex Software • India

Remote
INR 4,000,000 - 6,000,000
Senior Data Analyst
Senior Data Analyst

SalVentureTech • Nagpur City

On-site
INR 1,200,000 - 1,800,000