· Designing,
building and maintaining Power BI dashboards and reports for internal teams and
client reporting requirements

· Building and
optimising data models in Power BI - star schema design, relationships and DAX
measures - to ensure accurate and performant reporting

· Writing and
optimising SQL queries to extract, join and validate data across multiple
source systems

· Preparing and
transforming data using Power Query (M) - cleaning, shaping and consolidating
inputs from Excel, CSV files, databases and APIs

· Automating
recurring reporting through scheduled refreshes, dataflows and gateway
configuration in the Power BI Service

· Managing
workspaces, publishing, row-level security and user access so that the right
stakeholders see the right data

· Working with
teams across the firm to gather requirements, define metrics and translate
business questions into reporting solutions

· Performing
data validation and reconciliation so that reported numbers tie back to source,
and investigating variances before reports are released

· Complying
with IT policies and procedures

· Maintaining
security of information at all times

Requirements

· Power BI - Strong hands-on experience building
production dashboards in Power BI Desktop and publishing, scheduling and
administering them in the Power BI Service.





· DAX - Ability to write and debug DAX measures,
including time intelligence, calculated columns and tables, and issues arising
from filter and row context.

· Data
Modelling - Sound understanding of
dimensional modelling (star schema), relationships and cardinality, and the
impact of model design on report performance.

· Power
Query / Data Preparation -
Proficiency in Power Query (M) for cleaning, shaping and combining data from
varied and inconsistent sources.

· SQL - Strong SQL skills for querying relational databases, including joins,
aggregations, window functions and basic query tuning.

· Excel - Advanced Excel skills (pivot tables,
lookups, Power Pivot) for ad-hoc analysis and reconciliation.

· Visualisation
& Reporting Design -
Ability to structure a dashboard around the decision it supports - explicit
layout, appropriate chart selection and consistent formatting.

· Data
Quality - Detail-oriented
approach to validation and reconciliation, with the discipline to check outputs
thoroughly before they reach internal or client-facing use.

· Communication
& Collaboration - Good
communication skills, with the ability to work across teams and explain data
and findings clearly to non-technical stakeholders.

📌 Data Analyst, Power Bi (Mumbai)
🏢 Recognized
📍 Mumbai