Senior BI Architect: Power BI & Fabric

Zer04 Consulting LLC; Cincinnati (OH); On-site; USD 130,000 - 190,000; Full time

Job summary

Zer04 Consulting LLC in Cincinnati, OH is seeking a Senior BI Architect to design, build, and own end-to-end BI solutions using Power BI and Fabric. The role emphasizes hands-on development, data engineering, and architecture leadership to deliver scalable analytics capabilities.

You will collaborate with business stakeholders, own the BI environment, and ensure data quality, governance, and performance across the enterprise. On-site Cincinnati location with full-time employment.

Qualifications

• Experience designing enterprise BI solutions using Microsoft Power BI.
• Advanced proficiency with DAX, SQL, Power Query, and dimensional modeling.
• Hands-on with Microsoft Fabric or comparable Azure-based data technologies.

Responsibilities

• Design, develop, and maintain scalable BI solutions using Power BI and Fabric.
• Take ownership of BI initiatives from design through deployment and optimization.
• Build and maintain data integration pipelines across enterprise sources.
• Develop semantic models, dimensional structures, and reusable business logic to support reporting.
• Create interactive dashboards, executive reports, KPIs, and self-service analytics.
• Enforce data quality, security, governance, and performance best practices.
• Collaborate with stakeholders to gather requirements and deliver solutions.
• Troubleshoot complex challenges and improve analytics capabilities.

Skills

Power BI

DAX

SQL

Power Query

Dimensional Modeling

Fabric / Azure data

ETL/ELT

BI Architecture

Production-ready Analytics

Analytical Skills

Communication

Tools

Microsoft Fabric

Azure Data Services

Job description

Zer04 Consulting LLC in Cincinnati, OH is seeking a Senior BI Architect to design, build, and own end-to-end BI solutions using Power BI and Fabric. The role emphasizes hands-on development, data engineering, and architecture leadership to deliver scalable analytics capabilities.

You will collaborate with business stakeholders, own the BI environment, and ensure data quality, governance, and performance across the enterprise. On-site Cincinnati location with full-time employment.