Job Summary:
The BI Report Designer is an embedded member of the Business Intelligence reporting team, sitting at the intersection of data and design. This role supports the Power BI reporting delivered across the Inspire Brands portfolio, including Dunkin’, Arby’s, Sonic, Jimmy John’s, Buffalo Wild Wings, and Baskin-Robbins, leveraging semantic models produced by the BI Developer team. The BI Report Designer is responsible for the visual quality, usability, and consistency of reports produced by the BI Report Developer team. This includes reviewing and refining reports created by other developers, establishing reusable templates and design components, and defining the visual standards the team follows. While not primarily responsible for building reports from scratch, this role ensures that all reporting output meets a high bar for clarity, usability, and design polish. The work supports more than 22,000 restaurants, so consistency, readability, and user experience are critical. This role partners closely with BI Report Developers on active builds and with the BI Developer team to ensure model design supports effective reporting. Success is measured by the quality and consistency of reporting output, adoption of design standards, and user satisfaction with report usability.
This position reports to the BI Report Developer Lead.
RESPONSIBILITIES
Review Power BI reports built by BI Report Developers before release, providing clear and actionable feedback on layout, visual hierarchy, color usage, typography, interactivity, and user experience.
Refine and rework reports as needed, making direct updates in Power BI Desktop to ensure alignment with Inspire visual standards prior to stakeholder delivery.
Build and maintain a library of reusable report templates used by BI Report Developers, covering common reporting use cases across guest experience, operations, people, and finance domains.
Design and maintain a component library of reusable visual elements, including Deneb or Vega-Lite specifications, HTML Viewer configurations, navigation patterns, and bookmark structures.
Define, document, and evolve Inspire’s Power BI visual design system, including standards for layout, color, typography, iconography, and interaction patterns.
Use HTML, CSS, and JavaScript within Power BI to create custom visual elements that extend beyond native capabilities, and document those solutions for reuse.
Partner with the BI Report Developer Lead to identify recurring design challenges and address them through improved templates, standards, or reusable components.
Support BI Report Developers during active builds, providing design guidance and iterative feedback prior to formal review.
Partner with the BI Developer team to understand semantic models and identify cases where model structure limits effective report design.
Gather feedback from business stakeholders and end users on report usability, translating that feedback into improvements to templates, standards, and existing reports.
Stay current on Power BI capabilities, Deneb, Vega-Lite, and broader data visualization trends, and incorporate relevant advancements into the team’s work.
EDUCATION QUALIFICATIONS
Minimum: 4 year degree in Information Systems, Computer Science, Visual Design, Interaction Design, Digital Media, Business, or a related field.
Preferred: Microsoft Power BI Data Analyst Associate or Fabric Analytics Engineer Associate certification. Formal training or credentials in UX/UI design, data visualization, or front-end development.
EXPERIENCE QUALIFICATION
Minimum: 2+ years of experience building or designing Power BI reports in a professional setting, supported by a portfolio demonstrating strong visual design and usability judgment. At least 1 year of experience using HTML and CSS.
Preferred: 3+ years of Power BI or data visualization experience, ideally in a multi brand, retail, restaurant, or franchise environment. Experience with Deneb or Vega-Lite and a background in UX/UI design, front-end development, or digital product design.
REQUIRED KNOWLEDGE, SKILLS or ABILITIES
Strong visual design judgment, with the ability to quickly assess and improve report usability and aesthetics.
Hands-on expertise with Power BI Desktop, including bookmarks, drill-through, tooltips, field parameters, dynamic titles, and conditional formatting.
Proficiency in HTML and CSS, with the ability to create and document reusable custom visual components.
Working knowledge of JavaScript sufficient to build or adapt custom interactions within Power BI.
Experience using Deneb or Vega-Lite for advanced or custom charting a plus.
Working knowledge of DAX, sufficient to interpret measures and validate report output.
Understanding of dimensional modeling and star schema design, and the impact of model structure on reporting capabilities.
Strong SQL skills for data validation and troubleshooting.
Knowledge of data visualization principles, including chart selection, color accessibility, and effective information design.
Ability to provide clear, constructive feedback that improves output while supporting team collaboration.
Experience building design systems, template libraries, or reusable components for developer teams.
Strong written and verbal communication skills, including the ability to explain design decisions to both technical and non-technical audiences.
Ability to manage multiple priorities across reports and developers, maintaining quality and responsiveness.
Familiarity with Power BI governance concepts, including row-level security, workspace management, and deployment pipelines.
DECISION-MAKING AUTHORITY
Owns Inspire’s Power BI visual design standards, including templates, component libraries, color systems, typography, and interaction patterns, within the broader BI strategy. Aligns this to the broader company design standards.
Determines whether reports meet design standards prior to release.
Defines and evolves template and component design approaches, including introduction of new patterns and retirement of outdated ones.
Recommends adoption of new visualization tools, capabilities, or design approaches, with final approval from the BI Report Developer Lead.
Escalates persistent design issues, model limitations, or capacity constraints impacting report quality to the BI Report Developer Lead.
