Hybrid Senior BI Front End Architect

at Johnson Brothers

• Job title: Senior BI Front End Architect
• Job type: Full Time
• Experience level: Senior
• Salary: $77,316 - $130,000 per year
• Degree requirement: Bachelor's Degree
• Tech skills: ERP
• Location requirements: Hybrid, St Paul, United States

About the role

• Senior BI Front End Architect designing and implementing Power BI and Microsoft Fabric platform. Join Johnson Brothers to elevate UX/UI and optimize performance across all devices.

Responsibilities

• designs and implements our enterprise Power BI and Microsoft Fabric platform
• consolidate multiple reporting environments into a single governed ecosystem
• elevate UX/UI through standardized design
• optimize performance across all devices
• apply deep data acquisition knowledge to ensure semantic models accurately reflect business data from source systems
• actively coaches BI developers to uplift team capabilities
• Establish front‑end governance: workspace taxonomy, naming standards, deployment pipelines, and versioning
• Define and enforce the thin report over certified semantic models pattern
• Act as the primary liaison between the BI team and Data Engineering, providing requirements for data models and pipelines based on business reporting needs
• Partner with business stakeholders and analytics teams to identify, prototype, and integrate AI/ML insights into reporting solutions
• Create and maintain a design system for Power BI (themes, layout patterns, typography, color, accessibility)
• Standardize navigation (app structure, report landing pages, bookmarks) and mobile‑first layouts
• Own report performance: DAX optimization, model sizing, aggregation/Hybrid tables, Incremental Refresh , and Visual/Query reduction
• Monitor and tune Fabric/Power BI capacity using Capacity Metrics; set SLIs/SLOs for open time and interaction latency
• Establish performance test gates in CI/CD (Performance Analyzer baselines, dataset refresh thresholds)
• Document standards, anti‑patterns, and 'cookbook' guidance for repeatable delivery
• Partner with data engineering to align security (RLS/OLS), lineage, and metadata
• Implement BI deployment processes including ALM Toolkit, Git, and change management.

Requirements

• 8+ years in BI/analytics with 4+ years leading Power BI front‑end architecture at enterprise scale
• Proven ability to collaborate with data engineering teams and a strong understanding of end-to-end data acquisition flows from source systems (e.g., ERP, CRM)
• Demonstrated success consolidating disparate BI estates into a unified Fabric/Power BI platform
• Deep expertise in DAX performance tuning, model design, UX patterns, and capacity optimization
• Hands‑on CI/CD for BI (Git, Deployment Pipelines, ALM Toolkit) and production operations (refresh SLAs, incident handling)
• Translate executive and functional requirements into task‑focused, decision‑ready reporting
• Collaborate with data engineering, security, and governance to align modeling, lineage, and access.
• Conduct design reviews, office hours, and enablement sessions; serve as a trusted advisor to business leaders.

Benefits

• comprehensive health benefits and programs, which include medical, dental, vision, life insurance
• health savings and flexible spending accounts
• 401(k) with an employer match
• short term disability coverage
• company-paid long term disability insurance
• generous paid time off (PTO) plans
• paid parental leave