Description

Responsibilities:

· Understand existing Excel reports, formulas, macros, pivot logic, and business rules.

· Document reporting logic, KPIs, metrics, and data definitions.

· Work with business stakeholders to clarify requirements and identify improvement areas.

· Ingest data from Excel, SQL databases, or other source systems into Power BI.

· Write DAX measures to replicate or improve current Excel calculations.

· Design intuitive, interactive Power BI dashboards and paginated reports.

· Apply best practices for UX, visual design, and performance.

· Ensure business logic aligns with the original Excel reports

· Publish reports to Power BI Service workspaces, manage access, and set up RLS if needed.

· Ensure data pipelines eliminate manual effort currently required in Excel.

· Conduct user training on new Power BI dashboards.

Requirements:

· 6-8 + years of experience with PowerBI

· Expertise in SQL for data extraction, manipulation, and reporting

· Experience with Azure

· Good understanding of Excel logic, including formulas, pivots, and macros

· Excellent analytical, problem-solving, debugging and communication skills

· Ability to work independently and collaboratively within a team environment

Good to Have:

· Experience in Azure – Data Factory, Fabric

· Setting up and management of Power BI Report Server

· Exposure to Python or R for advanced analytics

Key Skills

Education

Any Gradute