Reports Analyst (Power BI)

Job Summary

The Reports Analyst (Power BI) supports the Data Analytics Lead in delivering accurate, timely, and decision-ready reporting across all business units and operating companies. The role designs, builds, and maintains Power BI reports, interactive dashboards, and semantic models sourced from cloud data platforms and enterprise systems (ERP/POS/HRIS). Serving as a critical bridge between business stakeholders and the data team, the Reports Analyst translates business reporting needs into reliable, self-service analytics.

This position focuses on four key pillars: Report & Dashboard Development , Data Modeling & DAX , Data Quality & Report Governance , and Stakeholder Support & User Enablement . The role also trains end-users, monitors report usage and data refresh health, and continuously optimizes existing reports to eliminate manual reporting processes across the organization.

Key Responsibilities & Essential Functions

1. Report & Dashboard Development

• Design, build, and publish interactive Power BI reports and dashboards across core business functions (e.g., Sales, Operations, Supply Chain/Inventory, Procurement, Finance, and HR).
• Translate complex business questions into clear key performance indicators (KPIs), visual representations, and actionable drill-down paths that support unit-, brand-, and group-level decisions.
• Apply consistent enterprise report design standards, UI/UX layouts, naming conventions, color themes, and accessibility best practices.

2. Data Modeling & DAX Optimization

• Build optimized star-schema semantic models sourced from curated data lakehouse layers and enterprise data repositories.
• Write, debug, and optimize complex DAX (Data Analysis Expressions) measures, including time-intelligence calculations, period-over-period comparisons, and variance analyses.
• Tune report and model performance using appropriate storage modes, incremental refresh policies, aggregations, and proper data relationship design.

3. Data Quality & Report Governance

• Write and execute SQL queries to explore, validate, and shape source data for reporting.
• Reconcile report metrics against primary source systems (ERP, POS, HRIS) and resolve data discrepancies directly with data owners.
• Manage Power BI workspaces, apps, deployment pipelines, scheduled refresh gateways, and Row-Level Security (RLS) by entity, location, and user role.
• Maintain comprehensive documentation for data definitions, business rules, calculation logic, and metric definitions within the enterprise data dictionary.

4. Stakeholder Support & User Enablement

• Gather, clarify, and document reporting requirements with business stakeholders while consolidating duplicate or overlapping report requests.
• Train end-users on self-service reporting features, dashboard navigation, and basic analytics tools.
• Resolve report-related support tickets, troubleshoot data refresh failures, and perform root-cause analysis on data errors.
• Support ad-hoc data analysis requests and recurring management reporting deliverables (weekly, monthly, and period-end).