Associate Consultant - Data and Analytics

Amplytics; San Francisco (CA); Hybrid; USD 80,000 - 110,000; Full time

Job summary

Join a forward-thinking consulting firm as an Associate Consultant in Data and Analytics, where your analytical skills will transform raw data into actionable insights. This role involves designing interactive dashboards, collaborating with cross-functional teams, and implementing data-driven solutions that enhance decision-making. With a focus on Power BI and data visualization, you will play a crucial part in driving business value for energy companies. If you are detail-oriented and passionate about analytics, this is the opportunity to make a significant impact in a dynamic environment.

Benefits

Medical insurance

Vision insurance

401(k)

Disability insurance

Qualifications

• 1-3 years of experience in data analysis or business intelligence.
• Demonstrated proficiency with Power BI and SQL for data manipulation.
• Ability to present data insights clearly to non-technical stakeholders.

Responsibilities

• Design and maintain interactive Power BI dashboards for business insights.
• Collaborate with stakeholders to translate reporting requirements into visualizations.
• Implement data quality checks and validation procedures for accurate reporting.

Skills

Power BI

SQL

DAX

ETL processes

Excel

Data visualization

Analytical thinking

Problem-solving

Education

Bachelor's degree in Business Analytics

Bachelor's degree in Computer Science

Bachelor's degree in Statistics

Tools

Power BI Desktop

Power BI Service

Git

Job description

Associate Consultant - Data and Analytics

Associate Consultant - Data and Analytics

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

$80,000.00/yr - $110,000.00/yr

Position Overview:

We are seeking a detail-oriented Associate Consultant, Data and Analytics to join our growing analytics team. In this role, you will be instrumental in transforming raw data into actionable business insights through advanced visualization and analytical techniques. You will work closely with cross-functional teams to understand their data needs, develop intuitive dashboards, and implement data-driven solutions that drive decision-making. The ideal candidate has strong technical skills in Power BI and other analytics tools, combined with the ability to communicate complex data concepts to non-technical stakeholders.

Key Responsibilities:

• Design, develop, and maintain interactive Power BI dashboards and reports that deliver key business insights
• Collaborate with business stakeholders to understand reporting requirements and translate them into effective data visualizations
• Extract, transform, and load (ETL) data from various sources including databases, APIs, and flat files
• Create and optimize DAX measures and calculated columns to enhance data models
• Implement data quality checks and validation procedures to ensure accuracy of reporting
• Participate in data governance initiatives and documentation of data sources
• Research and implement best practices for data visualization and dashboard design
• Support ad-hoc analysis requests and special projects as needed
• Collaborate with data engineers to improve data pipelines and architecture
• Stay current on Power BI features and functionality through continuous learning

Qualifications:

Required

• Bachelor's degree in Business Analytics, Computer Science, Statistics, or related field
• 1-3 years of experience in data analysis, business intelligence, or related role
• Demonstrated proficiency with Power BI Desktop and Power BI Service
• Experience with data modeling, DAX, and Power Query (M language)
• Strong SQL skills for data extraction and manipulation
• Ability to translate business requirements into technical specifications
• Excellent attention to detail and commitment to data accuracy
• Strong analytical thinking and problem-solving skills
• Effective communication skills with the ability to present data insights clearly
• Experience working in collaborative, cross-functional teams

Technical Skills

• SQL (intermediate to advanced)
• Excel (advanced): Pivot tables, VLOOKUP, data analysis
• Knowledge of ETL processes and tools
• Experience with version control systems (e.g., Git) a plus
• Understanding of data governance principles

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 $80,000 to $110,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

  Entry level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Research, Analyst, and Information Technology

• 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 “Analytics Consultant” roles.

Data Analyst Lead - Customer Experience Advanced Analytics

San Francisco, CA $190,000.00-$230,000.00 2 months ago

Analytics Manager, Business Intelligence and Reporting

Sunnyvale, CA $91,000.00-$169,000.00 1 week ago

Communications Research & Analytics Consultant - Relocate to Saudi Arabia, Relocate to Saudi Arabia, Permanent Expat Family Relocation Package

San Francisco, CA $165,000.00-$190,000.00 6 months ago

Manager, Operations Insights & Analytics

TikTok Shop - US Operations- Senior Data Analyst

San Jose, CA $101,080.00-$220,611.00 2 weeks ago

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

Manager, Advanced Analytics- Not Remote (eCommerce/Marketplace)

Sunnyvale, CA $104,000.00-$202,000.00 6 days ago

Business Analyst, Creator Partnerships, YouTube

Senior Business Operations & Intelligence Manager

San Francisco, CA $75,000.00-$105,000.00 4 weeks ago

Data Reporting and Analytics Consultant III - Sales Analytics

Sr Manager, Reporting & Analytics - Location Flexible

San Francisco, CA $75,000.00-$90,000.00 5 months ago

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