Data Engineer (Fabric)

Vaco; Cincinnati (OH); On-site; USD 90,000 - 130,000; Full time

Job summary

Vaco in Cincinnati is seeking an experienced BI professional to design, develop, and maintain end-to-end data and reporting solutions using Power BI and Microsoft Fabric. You will collaborate with stakeholders to translate requirements into analytics, build scalable semantic models, and ensure data governance and security across enterprise reports.

Responsibilities include creating KPI definitions, complex DAX measures, and reusable data models, while optimizing performance and enabling

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

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 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.
• 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.
• 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.

Job description

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.