Role Summary

Avanade India’s Data & AI practice is looking for a Power BI Consultant who can take a reporting requirement from the first conversation with a business user through to a published, refreshing, secured dashboard in production. This is a hands-on build role with real client exposure — you will gather requirements, design the data model, write the DAX, build the visuals and own the solution through go-live.

We are looking for someone who thinks about the model before the chart. Strong DAX and a clean star schema are what make a dashboard fast, accurate and maintainable, and this role is weighted towards that discipline as much as towards visual design. Programming exposure — particularly Python for data analysis — is a welcome addition and will be supported and developed in the role, but strong Power BI craft is what matters most.

Key Responsibilities

- Gather and clarify reporting requirements with business and IT stakeholders — understand the questions being asked, the decisions they support, the underlying data sources and the definitions behind each metric.

- Translate requirements into a solution design: data model, KPI and measure definitions, report structure, navigation, security model and refresh approach.

- Design and build robust Power BI data models — star schema design, fact and dimension tables, relationships and cardinality, date/calendar tables, hierarchies and role-playing dimensions.

- Write and optimise DAX — measures, calculated columns and tables, time intelligence, variables, context transition, and performance tuning of slow measures.

- Build and maintain Power Query (M) transformations — source connections, cleansing,



shaping, merges and appends, query folding awareness, parameters and incremental refresh setup.

- Develop KPI dashboards and analytical reports that are visually clear and decision-oriented — appropriate visualselection, consistent formatting, drill-through, bookmarks, tooltips and accessible design.

- Implement row-level security — role design, DAX filter expressions, static and energetic RLS patterns — and validateit thoroughly before release.

- Configure and manage Power BI Service operations: workspaces, apps, dataset publishing, scheduled refresh, on-premises data gateway configuration, refresh failure troubleshooting and access management.

- Profile, validate and reconcile data against source systems — using SQL, and Python where you have it — to investigate anomalies and support analysis that goes beyond the dashboard.

- Write and tune SQL against source systems and data warehouses to extract, validate and shape data for reporting.

- Test and validate reports — reconciliation against source, measure accuracy checks, performance testing on realistic data volumes, and UAT support with business users.

- Document solutions — data dictionaries, measure definitions, model documentation and handover material — and support end users through training and adoption.

- Follow deployment and governance practice: workspace lifecycle, deployment pipelines, version control, naming standards and dataset certification where applicable.

- Contribute to reusable practice assets — report templates, DAX pattern libraries, theme files and accelerators.

undefined undefined undefined undefined undefined

📌 Power BI SME (India)
🏢 Avanade
📍 India