Senior BI Architect

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

*** MUST BE ABLE TO WORK IN THE US WITHOUT SPONSORSHIP. THIS POSITION IS NOT OPEN TO C2C CANDIDATES AT THIS TIME ***

Senior BI Architect

Location: Cincinnati, OH Area (on-site)

Employment Type: Full-Time

Position Overview

Zer04 Consulting is seeking an Senior BI Architect with Power BI and Fabric experience for an established organization in the Cincinnati area.

This opportunity is ideal for a hands‑on Business Intelligence professional who has experience designing, building, and delivering enterprise analytics solutions. Our client needs someone who can take ownership of complex BI initiatives, make sound technical decisions, and translate business requirements into scalable, reliable solutions. This person will own the buildout of the entire corporate BI environment.

The successful candidate will bring a combination of advanced Power BI development expertise, modern data engineering capabilities, and demonstrated experience delivering end‑to‑end BI solutions.

Key Responsibilities

• Design, develop, and maintain scalable Business Intelligence solutions using Microsoft Power BI and Fabric.
• Take technical ownership of BI initiatives, from solution design and architecture through development, deployment, and optimization.
• Build and maintain data integration processes, pipelines, and transformation workflows across multiple enterprise data sources.
• Develop robust semantic models, dimensional data structures, and reusable business logic to support consistent reporting.
• Create interactive dashboards, executive reports, KPIs, and self‑service analytics solutions.
• Establish and maintain best practices for data quality, security, governance, and reporting performance.
• Collaborate directly with business stakeholders to gather requirements and deliver solutions that support operational and strategic decision‑making.
• Independently troubleshoot complex technical challenges and identify opportunities to improve the organization's analytics capabilities.

Required Qualifications

• Strong professional experience developing enterprise reporting and analytics solutions using Microsoft Power BI.
• Advanced proficiency with DAX, SQL, Power Query, and dimensional data modeling.
• Hands‑on experience with Microsoft Fabric or comparable Azure‑based data technologies.
• Experience designing and implementing ETL/ELT processes and integrating data from multiple systems.
• Demonstrated experience taking ownership of BI solution architecture and hands‑on implementation, rather than exclusively developing within established environments.
• Ability to independently design, build, deploy, and maintain production‑ready analytics solutions.
• Strong analytical, problem‑solving, and communication skills.
• Ability to translate business needs into practical, scalable technical solutions.

Preferred Qualifications

• Experience building enterprise BI capabilities from the ground up or leading significant modernization efforts.
• Familiarity with Fabric Lakehouses, Warehouses, data pipelines, and related data engineering capabilities.
• Experience implementing data security, governance, and performance optimization practices.
• Exposure to Azure data services, version control, and modern development and deployment practices.
• Relevant Microsoft certifications.

The Opportunity

This position offers the opportunity to make a meaningful impact on an organization's Business Intelligence capabilities.

Our client is looking for a self‑directed professional who combines architectural thinking with strong hands‑on development skills. The ideal candidate is comfortable taking responsibility for technical decisions, developing solutions independently, and delivering measurable business value.

If you have a track record of designing and building BI solutions, rather than simply maintaining or enhancing existing reports, we'd like to hear from you.

Work eligibility

Candidates must be authorized to work in the United States without requiring employer sponsorship.