Senior BI Architect

*** 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

Zer
04 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.

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

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

• Experience building enterprise BI capabilities from the ground up or leading significant modernization efforts.
• Familiarity with Fabric Lake houses, 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.

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.

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