BI Developer

Position Summary

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.

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.

• 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 (One Lake).
• 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.

• 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 (One Lake, Lake houses, 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.