Collaborate with stakeholders to define reporting requirements, KPI logic, and acceptance criteria; build wireframes based on stakeholder requirements and translate approved wireframes into production-ready Power BI dashboards; iterate on feedback.
Build and maintain custom Power BI visuals beyond native capabilities, including KPI scorecards, timelines, analytical tables, and trend views; implement filtering, drill-through, tooltips, and conditional formatting.
Develop and maintain DAX measures and calculated columns for aggregations, time-based comparisons, status logic, and target/variance analysis.
Configure semantic models over supplied Gold tables, including relationships, date tables, and report-level Power Query shaping; preserve data grain and consistent metric definitions.
Test dashboards and validate results against Gold tables using SQL; reconcile counts and totals, check duplicates and missing values, and verify filter context, visual interactions, and refresh behavior.
Publish and maintain reports, apply approved access controls, troubleshoot report/model issues, and coordinate upstream defects with data engineers. Document metrics, mappings, reusable visual specifications, and releases.
Track requirements, acceptance criteria, status in Jira within a small scrum-light agile team
Skills
Proven Power BI dashboard delivery experience, including Power Query, semantic modeling, DAX measures and calculated columns, testing, and data validation.
Hands-on experience building custom Power BI visuals. Strongly preferred: Deneb with Vega/Vega-Lite, including authoring and maintaining JSON specifications; Python/R-based experience also welcome.
Strong DAX understanding of row/filter context, relationship-driven filtering, distinct counts, and correct totals across different levels of detail.
Strong SQL querying skills for relational databases and lakehouse SQL endpoints, including joins, CTEs, window functions, aggregations, and reconciliation.
Strong understanding of dimensional modeling, fact-table grain, relationship cardinality, and medallion architecture (Bronze/Silver/Gold), with Client on consuming reporting-ready Gold tables.
Experience consuming data from Databricks and/or Microsoft Fabric Lakehouse in Power BI; familiarity with semantic-model connectivity and refresh troubleshooting.
Strong dashboard design, analytical thinking, attention to detail, and communication skills; ability to build readable, reusable visuals, create wireframes from stakeholder requirements, and translate wireframes into production-ready Power BI dashboards.
Preferred: Python and PySpark experience for data inspection, validation, and collaboration with upstream data engineers.
Preferred: Experience in working with the following datasets: JIRA data, audit & issue management data, project management data, service now data (changes, incidents, vulnerabilities), financial and HR data