Data Analyst Power Bi

Tristone; Mumbai; On-site; INR 600,000 - 900,000; Full time

Job summary

Tristone is seeking a Power BI Specialist to design and maintain dashboards for internal and client reporting. You will build data models, implement DAX measures, and ensure data accuracy across sources.

You will optimise SQL queries, transform data with Power Query, and automate reports via dataflows and gateway configurations, while managing access and security for stakeholders.

Qualifications

• Design Power BI dashboards and reports for internal teams and clients.
• Build and optimise data models with star schemas and DAX measures.
• Write and optimise SQL queries across multiple source systems.
• Prepare and transform data using Power Query (M).
• Automate reporting with scheduled refreshes, dataflows and gateways.
• Manage workspaces, row-level security and user access.
• Gather requirements and translate business questions into reports.
• Perform data validation and reconciliation and ensure data accuracy.

Responsibilities

• Design, build and maintain Power BI dashboards and reports.
• Develop data models with star schema and relationships.
• Create and optimise SQL queries for data extraction and validation.
• Prepare data using Power Query (M) from diverse sources.
• Automate recurring reports via refreshes, dataflows and gateways.
• Manage workspaces, publish reports, and enforce row-level security.
• Collaborate with teams to define metrics and translate needs into solutions.
• Validate data and investigate variances before release, ensuring IT compliance.

Skills

Power BI

Data modeling

DAX measures

SQL

Data preparation

Problem solving

Stakeholder analysis

Tools

Power BI Desktop

Power BI Service

Power Query (M)

Job description

Job Description:

• 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