Data Engineer (Fabric)

Vaco LLC is seeking a Data Engineer to help build trusted analytics using Microsoft Fabric. This onsite role in Cincinnati, OH focuses on designing end-to-end data solutions that support semantic models, KPI definitions, dashboards, and self-service reporting for business users.

You will work across the Fabric data engineering stack while partnering with stakeholders to translate reporting needs into scalable Power BI solutions. The work includes establishing governance and security standards, improving report and data performance, and maintaining deployment and lifecycle management for analytics assets.

Key Responsibilities

• 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 dashboards that are intuitive, visually compelling, and designed to improve 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 through certified datasets and reusable semantic models.
• Conduct report testing, validation, and user acceptance activities.
• Design and maintain scalable Power BI semantic models using dimensional modeling best practices.
• Build star schemas including fact tables, dimensions, hierarchies, measures, and calculation groups.
• Create complex DAX measures and reusable business logic.
• Standardize and govern enterprise metrics to keep definitions consistent across reporting assets.
• Promote dataset reuse and reduce duplication of business logic across reports and dashboards.
• Support deployment pipelines and lifecycle management for analytics solutions.
• 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 using 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.

Required Qualifications

• 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, and quick service restaurants, including familiarity with POS, sales, inventory, pricing, promotions, loyalty, and store operations data (preferred).

Technologies

• Power BI
• DAX
• Microsoft Fabric
• Azure Data Platform
• Fabric Dataflows Gen2
• Fabric Data Pipelines
• Lakehouses
• Warehouses
• ELT/ETL
• ERP
• POS
• APIs

Location: Cincinnati, OH (onsite)

Compensation: USD 95,000 - 125,000 per year