Job Summary

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

Responsibilities

- 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 - clear 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 - Valuable communication skills, with the ability to work across teams and explain data and findings clearly to non-technical stakeholders.

Job Type

Full time

Location

Maharashtra, India

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 Data Analyst, Power Bi (Mumbai)
🏢 Tristone Strategic Partners
📍 Mumbai