Logo
Amplytico

Data Analytics Consultant

Amplytico, San Francisco, California, United States, 94199

Save Job

Base pay range $90,000.00/yr - $135,000.00/yr

Position Overview Amplytico is seeking a Data Analytics Consultant to drive complex data analysis projects for our clients. In this role, you will manage complex data analysis projects using Microsoft Power BI. This role requires both technical excellence and strong business acumen to deliver impactful insights that drive client success.

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.

Equal Opportunity Employer 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 operations@theamplytics.com

Seniority level Mid‑Senior level

Employment type Full‑time

Job function Research, Analyst, and Information Technology

Industries Business Consulting and Services

#J-18808-Ljbffr