Data Analytics Consultant

Amplytico; San Francisco (CA); Hybrid; USD 90,000 - 135,000; Full time

Job summary

Amplytico, a San Francisco–based energy analytics consultancy, seeks a Power BI Developer to design end-to-end BI solutions and translate business needs into technical specifications. You will build data models with DAX, optimize reports, and guide governance for enterprise Power BI environments.

The role requires 4+ years in Power BI development, strong DAX and data modeling, SQL proficiency, and proven implementations.

Qualifications

• Bachelor's degree in a related field (CS, IS, etc.).
• 4+ years of experience with Microsoft Power BI development.
• Advanced knowledge of DAX and data modeling.
• Proven track record of successful implementations.

Responsibilities

• Design and implement end-to-end Power BI solutions tailored to specific business requirements.
• Develop complex data models using DAX to solve sophisticated business problems.
• Create intuitive, interactive dashboards that effectively communicate key business insights.
• Implement efficient ETL processes using Power Query for data preparation and transformation.
• Optimize performance of Power BI reports and data models for enterprise-scale solutions.
• Consult with stakeholders to gather requirements and translate business needs into technical specifications.
• Provide technical guidance and troubleshooting for existing Power BI implementations.
• Train client teams on Power BI and DAX fundamentals to ensure knowledge transfer.
• Implement data governance and security protocols within Power BI environments.
• Establish reporting frameworks and best practices for sustainable analytics.
• Document technical specifications and create user guides for implemented solutions.
• Stay current with Power BI updates and incorporate new features into client solutions.

Skills

Power BI

DAX

Data modeling

SQL

Education

Bachelor's degree in related field (Computer Science, Information Systems, etc.)

Tools

SQL

SSAS

DirectQuery

Composite models

Power BI REST API

Job description

Key Responsibilities:

• Design and implement end-to-end Power BI solutions tailored to specific business requirements
• Develop complex data models using DAX to solve sophisticated business problems
• Create intuitive, interactive dashboards that effectively communicate key business insights
• Implement efficient ETL processes using Power Query for data preparation and transformation
• Optimize performance of Power BI reports and data models for enterprise-scale solutions
• Consult with stakeholders to gather requirements and translate business needs into technical specifications
• Provide technical guidance and troubleshooting for existing Power BI implementations
• Train client teams on Power BI and DAX fundamentals to ensure knowledge transfer
• Implement data governance and security protocols within Power BI environments
• Establish reporting frameworks and best practices for sustainable analytics
• Document technical specifications and create user guides for implemented solutions
• Stay current with Power BI updates and incorporate new features into client solutions

Technical Skills

Power BI & DAX Expertise

• Advanced knowledge of Power BI Desktop, Service, and Mobile applications
• DAX formula mastery for complex calculations and time intelligence functions
• Star schema and dimensional modeling for optimized data structures
• Power Query (M language) for advanced data transformations
• Implementation of row-level security and proper governance protocols

Additional Technical Skills

• SQL for data extraction and manipulation
• Tabular modeling in Analysis Services (SSAS)
• Experience with DirectQuery and Composite models
• Knowledge of Power BI REST API for automation

Qualifications

• Bachelor's degree in related field (Computer Science, Information Systems, etc.)
• 4+ years of experience with Microsoft Power BI development
• Advanced knowledge of DAX and data modeling
• Proven track record of successful implementations

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

Amplytico 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 amplytico.com

Compensation

As required by California law, the base salary range for this position in San Francisco is $90,000 to $135,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.

Amplytico 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]