Enterprise BI Engineer: Fabric & Power BI Analytics

Socket.dev; Norwood (OH); On-site; USD 110,000 - 150,000; Full time

Job summary

Socket.dev is seeking a skilled BI Engineer to design, build, and maintain scalable analytics using Power BI and Microsoft Fabric. You will develop semantic models, KPI definitions, and dashboards that empower business users with trusted insights across retail-like data domains.

The role emphasizes end-to-end data solutions, including data ingestion, transformation, modeling, semantic layers, and interactive reporting, while ensuring governance and security standards are met.

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.
• 3+ years of 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.

Skills

Power BI

DAX

Power Query

Data modeling

SQL

Business intelligence

Communication

Analytical thinking

Project management

Education

Bachelor’s degree or equivalent

Tools

Fabric Dataflows Gen2

Fabric Lakehouse

Azure Data Factory

Azure SQL

Databricks

Git

Azure DevOps

Power BI Service

Job description

Socket.dev is seeking a skilled BI Engineer to design, build, and maintain scalable analytics using Power BI and Microsoft Fabric. You will develop semantic models, KPI definitions, and dashboards that empower business users with trusted insights across retail-like data domains.

The role emphasizes end-to-end data solutions, including data ingestion, transformation, modeling, semantic layers, and interactive reporting, while ensuring governance and security standards are met.