Principal I, Power BI Architect

About the role

You’ll build how the organization sees, trusts, and acts on data. As a Principal I, Power BI Architect, you’ll design and scale enterprise-grade Power BI solutions—from semantic models to embedded analytics—so leaders and teams can make faster, smarter decisions. You’ll set architecture and governance standards, drive performance and capacity optimization, and partner closely with data engineering and application teams to deliver reliable, secure, and easy-to-use analytics experiences. This role calls for deep expertise in Power BI architecture, DAX, SQL, and modern cloud data platforms (Azure and Snowflake).

Responsibilities

• Power BI Architecture & Solution Design Lead end-to-end Power BI delivery (semantic models, reports, dashboards) that scales across the enterprise.
• Architect high-performing, reusable data models aligned to business definitions and governed metrics.
• Establish and evolve standards for development, governance, and lifecycle management across the Power BI ecosystem.
• Champion advanced capabilities (calculation groups, field parameters, deployment pipelines, bookmarks) to improve usability and consistency.
• Data Integration & Backend Connectivity Connect Power BI to Snowflake, Azure SQL, and other cloud/on-prem sources with secure, reliable access patterns.
• Use Direct Lake and Delta-based approaches to enable fast, near real-time analytics where appropriate.
• Partner with data engineering to build efficient pipelines, refresh strategies, and dataset development.
• Embedded Analytics & Application Integration Build and support Power BI Embedded experiences that bring analytics directly into web applications.
• Ensure embedding is secure, scalable, and aligned with enterprise architecture and identity patterns.
• Performance Optimization & Advanced Analytics Write, review, and optimize DAX for clarity, correctness, and performance at enterprise scale.
• Develop and maintain Power Query (M) transformations with a focus on maintainability and refresh efficiency.
• Diagnose and tune report performance, query plans, and refresh operations—then share guidance with teams.
• Deployment, Administration & Governance Implement CI/CD using Git, TMDL, Tabular Editor, and automated validation to improve quality and speed.
• Administer tenant/workspace settings, security, and access controls; define guardrails that enable self-service safely.
• Monitor and optimize capacity unit (CU) utilization and operational health across environments.
• Leducation: Bachelor's degree in Computer Science, Information Systems, or related field.

Qualifications

• 7+ years of experience building Power BI and business intelligence solutions.
• 3+ years in an architecture/technical leadership role (Power BI Architect, BI Architect, Analytics Architect, or similar).
• Proven success delivering scalable, high-performance BI solutions in enterprise environments.
• Expert proficiency in Power BI (semantic modeling) and solid, hands-on DAX experience (writing and optimizing measures for enterprise-scale models), plus Power Query (M).
• Strong SQL skills for data analysis, transformation, and fixing issues.
• Hands-on experience integrating Power BI with cloud data platforms such as Snowflake and Azure (e.g., Azure SQL, Data Factory, Synapse or equivalents).
• Solid understanding of governance, security, and administration in the Power BI tenant/workspace model.

Skills and background required to be successful

• Experience with Direct Lake and Delta-based architectures for analytics.
• Experience delivering Power BI Embedded solutions and partnering with application teams on integration patterns.
• Experience implementing CI/CD for semantic models and reports using Git, TMDL, and Tabular Editor (or comparable tooling).
• Understanding of Power BI capacity unit (CU) consumption, monitoring, and optimization.
• Familiarity with Power Apps to extend or operationalize analytics workflows.

Benefits

At Herbalife, we offer a variety of benefits to eligible employees in the U.S. (limited to the 50 States and the District of Columbia), including Group Health Programs, other Voluntary Benefit Programs, and Paid Time Off. Group Health Programs include Medical, Dental, Vision, Health Savings Account (HSA), Flexible Spending Accounts (FSA), Basic Life/AD&D; Short-Term and Long-Term Disability and an Employee Assistance Program (EAP). Other Voluntary Benefit Programs include a 401(k) plan, Wellness Incentive Program, Employee Stock Purchase Plan (ESPP), Supplemental Life/Critical Illness/Hospitalization/Accident Insurance, and Pet Insurance. Paid time off includes Company-observed U.S. Holidays, Floating Holidays, Vacation, Sick Time, a Volunteer Program, Paid Maternity and Paternity Leave, Bereavement Leave, Personal Leave and time off for voting.