Power BI SME

About the role

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.

What you'll do

• Gather and clarify reporting requirements with business and IT stakeholders — understand the questions being asked, the decisions they support
• 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
• 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

What you need

• 3–6 yrs of experience
• Power BI
• SQL
• Dashboarding
• DAX
• Python
• Data analysis
• Any graduate

Good to have

• Pandas
• NumPy
• Power Query
• Data modelling
• Business analysis
• Azure