Bagel Brands is seeking a Business Intelligence (BI) Specialist with expertise in Power BI and data visualization to transform complex data into actionable insights, providing analytic support across the organization with a focus on Marketing and Financial KPIs. The role aims to inform performance management, strategic decisions, and planning through impactful reporting solutions and visualizations.
Requirements
- Expert-level proficiency in Power BI
- Experience with DAX development and dynamic measure creation.
- Experience working with databases (dimensional and relational) and in visualizing large and complex datasets in a commercial/business environment.
- Experience with data modeling, analytics, and presentation creation
- Familiarity with UI/UX principles for dashboard design.
- Experience in Retail analytics with preferred experience in QSR or Fast-Casual analytics having a deep understand of POS data
- Experience working with large volumes of data, combining and reconciling data from different sources, and knowledge of ETL process
Responsibilities
- Design, build, document, and maintain accurate, consistent and interactive Power BI dashboards and reports from various data sources.
- Perform data analysis, including data profiling into data warehouses, to obtain a good understanding of data availability, relationships, and nuances for consideration of reporting design.
- Administer/Support Bagel Brands’ reporting environment and published report processes.
- Triage, troubleshoot and resolve report issues from end users as well as support data integrity tickets with urgency.
- Ensure data integrity and accuracy through checking values, metrics, and calculations displayed in Power BI reports.
- Develop functional specifications and reporting design specifications for assigned projects.
- Identify data needs and driving data quality improvement projects while staying current on PowerBI and BI Industry trends to continuously improve analytics capabilities.
Other
- Collaborate with stakeholders across departments (Finance, Marketing, Operations, HR etc.) to translate business questions into analytical solutions.
- Collaborate effectively with internal end-users, cross-functional software development teams, Data Engineering teams etc. to solve problems and implement new solutions.
- Educate and support business users on the use of Power BI reporting assets
- Develop training materials and train end users on available reporting and usage.
- Produce regular and ad-hoc analyses, reports and presentations.
