Associate Consultant - Data and Analytics Job at Amplytics, Fremont, CA

ejZuMVljZ0V6Q2VzZWJ6MEhzdW1xZGg3VWc9PQ==
  • Amplytics
  • Fremont, CA

Job Description

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

  • Power BI (essential): Dashboard creation, report design, DAX formulas, data modeling
  • 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 operations@theamplytics.com

Job Tags

2 days per week,

Similar Jobs

The Kable Group

Welder Job at The Kable Group

 ...Role Description This is a full-time, on-site role for a Welder located in Cincinnati, OH. The Welder will be responsible for performing...  ...welding techniques, including arc welding, TIG welding, and MIG welding. Day-to-day tasks involve interpreting blueprints, preparing... 

RCM Technologies, Inc.

Process Safety Engineer Job at RCM Technologies, Inc.

 ...Permanent Placement / Direct Placement Title: Process Safety Engineer Compensation: $125K to $155K, commensurate with experience. Plus Benefits & Bonus. Location: Beaumont, TX Company Description: Our client's specialty synthetic wax segment produces... 

MONTICELLOAM, LLC

Analytics Engineer Job at MONTICELLOAM, LLC

 ...a strong work ethic. We are seeking a talented Analytics Engineer to join our dynamic team, focusing on optimizing our asset management...  ..., and investment opportunity screening Build and optimize Snowflake databases and queries to support real-time business... 

U.S. Army

Human Resources Job at U.S. Army

 ...skills, college credit, and home-town stability. This is an entry-level position with no experience Position requirements: (Responsibilities...  ...advanced training (Paid) Complete (ASVAB) Assist on all human resource support matters Oversight of all strength management and... 

Kelly

Clinical Research Associate Job at Kelly

 ...Join a dynamic team committed to optimizing patient enrollment in clinical trials. - Work in a supportive environment that prioritizes...  ...'s degree in a relevant field and have experience in clinical research or regulatory affairs, with a strong understanding of GCP and regulatory...