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 solid 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 r

📌 Power BI SME (Bengaluru)
🏢 Avanade
📍 Bengaluru