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 robust 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 visual selection, consistent formatting, drill-through, bookmarks, tooltips and accessible design.
Implement row-level secu

📌 Power BI SME (Bengaluru)
🏢 Avanade
📍 Bengaluru