BI Developer

The BI Developer is responsible for building, maintaining, and enhancing enterprise reporting and analytics solutions, with a primary focus on Microsoft Power BI and Microsoft Fabric. This role combines hands-on dashboard development, DAX and data modeling, and SQL-based data validation, working within data architectures and standards established by senior team members. Working across domestic, international, corporate, and franchise data domains, this position supports cross-functional teams by turning data into clear, reliable, and actionable reporting.

Essential Functions

BI Delivery & Power BI Development

• Power BI Solution Development: Support the Sr. Manager and senior team members in developing and enhancing interactive dashboards and paginated reports; assist with executive scorecard updates as directed.
• Report Performance: Build and optimize DAX queries and Power BI reports connected to Microsoft Fabric data sources (including Direct Lake mode) to support fast, reliable refresh performance.
• Metric Consistency: Implement standardized metric definitions within the Power BI semantic layer as defined by senior team members and stakeholders; ensure calculations remain consistent across reports and dashboards, and flag discrepancies in metric logic for review.
• Reporting & Documentation: Maintain documentation of data models, metric definitions, and dashboard usage guides for end-users.

• Semantic & Data Modeling: Build and maintain reporting-ready data models (Star/Snowflake schemas) within existing Medallion framework architecture (Bronze, Silver, Gold layers) across Snowflake and Microsoft Fabric (OneLake).
• Data Integration & Validation: Write SQL queries to validate data integrity, trace data lineage, and troubleshoot datasets across Snowflake and Microsoft Fabric.
• Pipeline Collaboration: Collaborate with data engineering teams on the integration of new data streams into the reporting layer, validating data quality and structure on the BI side.

• Semantic Layer Support: Maintain and extend existing Power BI semantic layers under senior guidance to support emerging use cases, including AI text-to-SQL tools.
• Conversational Data Exploration (Exposure): Gain hands-on exposure to Snowflake Intelligence and Cortex AI tools as the organization rolls out enterprise data agents and NLP-based self-service exploration.

• Data Governance: Ensure reports and semantic layers adhere to corporate role-based access controls (RBAC), row-level security (RLS), and data masking policies.
• Operational Support: Provide occasional after-hours support during major deployments or period-end reporting cycles, with advance notice provided where possible.

CORE COMPETENCIES

• 2 to 4 years of experience in information technologies, with at least 2 years focused specifically on BI development, dashboard creation, and data analysis.
• Prior experience within the Retail or Restaurant industries (Casual Dining or Quick Service environments preferred) is a plus.

• Bachelor's degree preferred, ideally in Information Systems, Computer Science, Data Analytics, or a related field.

• Solid working knowledge of Power BI (DAX, Power Query) and hands-on familiarity with Microsoft Fabric fundamentals (OneLake, Lakehouses, Direct Lake connectivity).
• Strong SQL skills, with the ability to write queries to validate data integrity and troubleshoot reporting datasets.
• Working knowledge of dimensional modeling

• Restaurant Support Center that operates in a fast-paced setting with a high volume of activity and a deadline-driven environment. The role follows a hybrid work model, requiring on-site presence in the office every Tuesday, Wednesday, and Thursday.