Power BI Developer

KPG99 INC; India; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A leading analytics firm in India is seeking a skilled Power BI Developer to create and maintain reporting solutions. The candidate will design interactive dashboards, optimize data models, and work closely with the PMO and finance teams. Strong experience with SQL and Power BI is essential, along with familiarity with the Clarity PPM Data Warehouse. If you're eager to build effective data solutions independently, we encourage you to apply.

Qualifications

• Strong experience with relational databases and complex SQL queries.
• Experience in designing interactive dashboards using Power BI.
• Ability to implement security measures in Power BI reports.

Responsibilities

• Develop and optimize SQL queries for reporting.
• Design interactive dashboards and reports in Power BI.
• Collaborate with PMO leadership to define KPIs.

Skills

Advanced SQL development

Power BI Report Development

ETL processes

Data modeling

DAX calculations

Tools

Power BI

SQL Server

Clarity PPM Data Warehouse

Job description

We are seeking a highly skilled Power BI Developer to design, develop, and maintain enterprise reporting and analytics solutions that support project portfolio, resource, and financial management. This role will partner closely with the PMO, Finance, and IT teams to deliver actionable insights through scalable data models and intuitive dashboards.

The ideal candidate has strong experience working with relational databases, advanced SQL development, and building Power BI reports from structured data sources. Experience developing reports from the Clarity PPM Data Warehouse (DWH) is strongly preferred.

Key Responsibilities

Data & Database Development

• Design, develop, and optimize SQL queries, views, and stored procedures against relational databases.
• Extract, transform, and load (ETL) data from enterprise systems into reporting-ready datasets.
• Work with structured data models including star and snowflake schemas.
• Ensure data integrity, accuracy, and performance optimization.

Power BI Development

• Design and develop interactive dashboards and reports using Power BI Desktop and Power BI Service.
• Build robust data models using DAX calculations, measures, KPIs, and hierarchies.
• Implement row-level security (RLS) where appropriate.
• Optimize report performance and usability for business stakeholders.
• Publish and manage reports within Power BI Service environments.

Clarity PPM Reporting (Preferred)

• Develop reports using data sourced from the Clarity PPM Data Warehouse.

Understand Clarity objects including:

• Projects
• Investments
• Resources & Roles
• Allocations
• Timesheets
• Translate PMO reporting requirements into scalable Power BI solutions.
• Support portfolio capacity, demand, and resource forecasting reporting.

Business Collaboration

• Partner with PMO leadership to define KPIs and reporting metrics.
• Translate business requirements into technical data solutions.
• Provide documentation and knowledge transfer for developed reports.
• Support data governance and reporting standards.

Important:

• There will be a technical assessment prior to interview, so we are looking for someone who is deeply hands-on and comfortable building data models and reports independently.
• If this sounds aligned with your background, I’d love to connect and discuss further. Please share your updated resume and availability for a quick call.