Enterprise BI Platform Architect

Benefits: * Fuel Your Growth with Love's - company funded tuition assistance
* Paid Time Off
* 401(k) – 100% Match up to 5%
* Medical/Dental/Vision Insurance after 30 days
* Competitive Pay
* Career Development *

Welcome to Love's: As the Analytics Platform Architect, you will define and evolve the organization's enterprise BI architecture, governance, and delivery standards across Microsoft Fabric and Power BI. Reporting to the Sr. Manager of Business Intelligence, you will own the end-to-end technical strategy for semantic modeling, data visualization at scale, performance and capacity management, Dev Ops/CI-CD, and secure data access.

Job Functions:

• Architect the enterprise BI platform (Fabric + Power BI) including standards for data ingestion, warehousing/lakehouse, semantic models, and report delivery; ensure designs follow star-schema principles and scale for enterprise workloads
• Establish and lead a Power BI/Fabric Center of Excellence (CoE): define roles, processes, and guardrails for content lifecycle, endorsement/certification, workspace strategy, and community enablement
• Own governance & security patterns: RLS/OLS design guidance, sensitivity labeling, tenant/workspace policies, and change management; balance autonomy with controls to scale safely
• Capacity & performance management: plan and optimize Fabric capacities, Direct Lake adoption, and One Lake usage; implement monitoring and cost/chargeback insights via Capacity Metrics and admin telemetry
• Dev Ops for BI: implement Git-based workflows with Power BI Projects (.pbip) and TMDL, automated quality checks (Tabular Editor Best Practice Analyzer), and CI builds/deployment pipelines (e.g., Azure Dev Ops)
• Enterprise semantic modeling: champion reusable, certified “golden” datasets; enforce DAX and modeling conventions; drive performance tuning (Verti Paq, cardinality reduction, calculation patterns)
• Introduce and govern use of AI-assisted development tools such as Copilot for Power BI, automated DAX generation, and intelligent model documentation
• Observability & telemetry: implement service-level monitoring, usage analytics, and audit automation using Admin APIs/Power Shell; publish adoption and SLA dashboards for leaders
• Data agent & AI-readiness: prepare semantic models for Copilot and Fabric data agent (Prep for AI schemas, metadata, synonyms) to improve natural-language querying and agentic analytics
• Cross-platform connectivity: oversee connectivity patterns (e.g., SAP HANA, Snowflake, SQL), gateway configuration, and hybrid modes (Direct Lake/Direct Query/Composite) with documented trade-offs
• Mentorship & standards: coach BI Developers I–III on modeling, DAX, performance, and SDLC; conduct peer reviews, publish playbooks, and facilitate internal training

Experience and Qualifications:

• HS Diploma or equivalent required;
  Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field preferred
• Certifications preferred:
  Microsoft Certified:
  Fabric Analytics Engineer Associate (DP-600)
• Demonstrated adoption of Fabric Direct Lake for large-scale analytics with performance/cost trade-off guidance; capacity throttling & load strategies
• Experience formalizing a Power BI CoEwith training,community of practice, and governance automation
• Familiarity with Best Practice Analyzer rule customization

Skills and Physical Demands:

• Hard
  
  Skills:
  • Strategic thinker able to translate business outcomes into architecture and platform roadmaps; exceptional stakeholder communication
  • Hands-on depth with Power BI Desktop/Service, semantic modeling, DAX, Power Query, and performance diagnostics;proficiency with Tabular Editor
  • Strong grasp of governance andCoEoperations, workspace design, endorsement workflows, and adoption enablement
  • Data Ops/Dev Ops: branching, code review, CI validation, automated deployments with .pbip/TMDL; comfortable with Azure Dev Ops
  • Security by design: RLS/OLS, sensitivity labels, and tenant policies integrated into modeling and release processes
  • Stay current with emerging AI capabilities in Fabric/Power BI; make models AI-ready (Prep for AI) and guide responsible use with Copilot/data agents
• Soft Skills:
  • Strategic thinking
  • Ability…