Power BI Lead / Architect

Amplytics; San Francisco (CA); Hybrid; USD 115,000 - 175,000; Full time

Job summary

Join a forward-thinking consulting firm as a Power BI Lead/Architect, where you will design and implement advanced Power BI solutions for the energy sector. This role offers the opportunity to lead projects, mentor junior team members, and collaborate with clients to transform complex data into actionable insights. With a focus on innovative data visualization and governance, you'll play a key role in empowering organizations to harness the power of their data. If you're passionate about business intelligence and eager to make a significant impact, this position is perfect for you.

Benefits

Medical Insurance

Vision Insurance

401(k)

Disability Insurance

Qualifications

• 7+ years of experience with Power BI, architecture, and implementation.
• Strong understanding of data modeling concepts and best practices.

Responsibilities

• Lead the architecture and implementation of Power BI solutions for clients.
• Develop dashboards and reports with interactive visualizations.

Skills

Power BI

DAX

Data Modeling

Data Governance

Power Query

Communication Skills

Problem-Solving

Education

Bachelor's Degree

Relevant Certifications

Tools

Azure SQL

Azure Synapse

Azure Data Factory

Job description

This range is provided by Amplytics. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$115,000.00/yr - $175,000.00/yr

Position Overview:

We are seeking an experienced Power BI Lead/Architect to join our growing team. In this role, you will design, develop, and implement sophisticated Power BI solutions for our energy sector clients. You will serve as the technical authority on Power BI projects, providing guidance to team members and translating complex business requirements into actionable data visualizations and insights.

Key Responsibilities:

• Lead the architecture, design, and implementation of enterprise-scale Power BI solutions for energy sector clients, including data warehouse integration and multi-source data connections
• Architect complex data models using star and snowflake schemas, implementing proper relationship cardinality, and optimizing for performance and usability
• Create and maintain sophisticated data models, relationships, measures, and calculated columns using advanced DAX functions and Power Query transformations
• Develop row-level security models and implement proper data governance controls to ensure compliance with client data security requirements
• Design and implement incremental refresh policies and composite models to optimize performance for large datasets
• Develop compelling dashboards and reports with interactive visualizations, drill-through capabilities, and actionable insights tailored to different user personas
• Implement Power BI deployment pipelines across development, test, and production environments with proper version control integration
• Configure and manage Power BI gateways for secure on-premises data access and scheduled refresh
• Establish best practices, governance frameworks, standards, and documentation for Power BI implementation across the organization
• Create reusable components, custom visuals, and templates to accelerate development and ensure consistency
• Mentor junior team members on Power BI development techniques, advanced DAX concepts, and optimal data modeling methodologies
• Lead client workshops to gather requirements and provide technical demonstrations of Power BI capabilities
• Collaborate with client stakeholders to understand complex business requirements and translate them into scalable technical solutions with appropriate KPIs
• Ensure data quality, security, and performance optimization in all Power BI deliverables through rigorous testing and validation
• Troubleshoot and resolve complex performance issues through query optimization, data model refinement, and DAX improvements
• Stay current with Power BI platform updates, industry trends, and Microsoft's Power Platform roadmap
• Contribute to internal knowledge sharing and thought leadership in business intelligence and data visualization

Qualifications:

Required

• 7+ years of experience with Power BI, including architecture, development, and implementation
• Strong understanding of data modeling concepts and best practices
• Advanced proficiency in DAX, M, and Power Query
• Experience with the Power Platform ecosystem (Power Apps, Power Automate)
• Familiarity with Azure data services (Azure SQL, Azure Synapse, Azure Data Factory)
• Experience in the energy sector strongly preferred
• Excellent communication skills with the ability to explain complex technical concepts to diverse audiences
• Strong problem-solving abilities and attention to detail
• Legal authorization to work in the United States

Work Location

This position requires onsite presence at client locations and/or our San Francisco office up to 2 days per week. Candidates must reside within a commutable distance of the San Francisco Bay Area. This position is hybrid (partial remote/partial onsite) and is not eligible for full remote work.

About Us

Amplytics is a specialized consulting firm helping energy companies transform data into business value. We combine advanced analytics with deep energy sector knowledge to uncover insights that empower organizations to pioneer the future of energy services. Learn more at theamplytics.com

Compensation

As required by California law, the base salary range for this position in San Francisco is $115,000 to $175,000. The actual salary paid to an individual will be based on multiple factors, including, but not limited to, specific skills, education, licenses or certifications, experience, market value, geographic location, and internal equity. Although we estimate the successful candidate hired into this role will be placed between the entry point and the middle of the range, the decision will be made on a case-by-case basis related to these factors.

Amplytics is an Equal Opportunity Employer. We do not discriminate based upon race, religion, color, national origin, sex, sexual orientation, gender identity, age, status as a protected veteran, status as an individual with a disability, or any other applicable legally protected characteristics. We are committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or an accommodation due to a disability, please contact us at [e-mail]

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Business Development and Sales

• Industries

  Business Consulting and Services

Referrals increase your chances of interviewing at Amplytics by 2x

Inferred from the description for this job

Medical insurance

Vision insurance

401(k)

Disability insurance

Get notified when a new job is posted.

Sign in to set job alerts for “Business Intelligence Architect” roles.

Senior Architect - Data Engineering and Analytics

San Rafael, CA $160,000.00-$190,000.00 1 week ago

San Francisco, CA $154,400.00-$250,700.00 4 months ago

Sr. Business Intelligence Analyst - Finance

Principal Data Architect, Big Data Platform

San Jose, CA $181,000.00-$354,200.00 2 weeks ago

Power BI Lead/Architect with User Experience Design Expertise

Sr. Specialist Solutions Architect - Data Engineering & Spark

Redwood City, CA $182,000.00-$223,000.00 1 week ago

San Mateo, CA $100,000.00-$125,000.00 2 months ago

Lead Solutions Architect- Data Solutions and Products

Client Implementations Data Solutions Architect

Business Intelligence Analyst, Trust & Safety - USDS

Mountain View, CA $106,400.00-$177,777.00 1 day ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.