This role will be responsible for developing end-to-end data solutions, including data ingestion, transformation, modeling, semantic layer design, and interactive reporting. While knowledge of data engineering is important, the primary focus of this position is delivering trusted, high-quality semantic models, KPIs, dashboards, and self-service analytics that empower business users.
DUTIES & RESPONSIBILITIES:
Business Intelligence & Reporting
· Design, develop, and maintain enterprise Power BI reports, dashboards, and scorecards.
· Partner with business stakeholders to gather requirements and translate them into reporting solutions.
· Create intuitive, visually compelling dashboards that drive decision making.
· Develop and maintain KPI definitions, calculations, and business metrics.
· Optimize report performance, usability, and adoption.
· Implement row-level security (RLS), object-level security (OLS), and data governance standards.
· Support self-service analytics initiatives through certified datasets and reusable semantic models.
· Conduct report testing, validation, and user acceptance activities.
Semantic Modeling & Analytics
· Design and maintain scalable Power BI semantic models using dimensional modeling best practices.
· Develop star schemas, fact tables, dimensions, hierarchies, measures, and calculation groups.
· Create complex DAX measures and reusable business logic.
· Standardize and govern enterprise metrics to ensure consistency across reports.
· Promote dataset reuse and reduce duplication of business logic across reporting assets.
· Support deployment pipelines and lifecycle management of analytics solutions.
Microsoft Fabric Data Engineering
· Build and maintain Fabric Dataflows Gen2, Data Pipelines, Lakehouses, and Warehouses.
· Develop ELT/ETL processes to ingest data from ERP, POS, operational systems, APIs, and cloud sources.
· Implement medallion architecture principles, including Bronze, Silver, and Gold data layers.
· Optimize data refresh, transformation, and storage performance.
· Support data quality, lineage, metadata, and governance initiatives.
· Collaborate with platform administration and infrastructure teams on Fabric best practices.
KNOWLEDGE, SKILLS AND ABILITIES REQUIRED:
Education and Experience:
· Bachelor’s degree in Computer Science, Information Systems, Analytics, Data Science, or related field, or equivalent work experience.
· 4+ years of Power BI development experience.
· Microsoft Fabric experience or equivalent Azure Data Platform experience.
· Prior experience with multi-location retail, convenience stores, quick service restaurants including familiarity with point-of-sale (POS), sales, inventory, pricing, promotions, loyalty, and store operations data. preferred
By submitting to this position, you are agreeing to be included in our talent pool for future hiring for similarly qualified positions.
