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

Stefanini North America and APAC

Healthcare Content Writer Job at Stefanini North America and APAC

 ...Role Description: We are seeking an experienced health journalist who can authoritative health content in an understandable and engaging voice. The Senior Writer will craft the following content types from proprietary webinar transcripts: feature articles, expert Q&As... 

Law Offices of E.F. Robinson

Experienced Family Law Trial Associate Attorney Job at Law Offices of E.F. Robinson

Empower Families. Transform Lives. Turn the Page. At the Law Offices of E.F. Robinson, we dont just handle caseswe help clients turn the page to a new chapter in their Book of Life. We are seeking an experienced Family Law Trial Attorney who is confident in the ...

Ernest

General Manager Job at Ernest

For over 78 years, Ernest has been committed to the success of our extended family, our customers, our employees, and the packaging industry itself. When you work with Ernest, youll enjoy the advantages of learning proven methods of success, a proactive approach, and...

DeWinter Group

Technical Writer Job at DeWinter Group

THIS IS FULLY REMOTE6+ Months W2 Contract Only Update existing documentation to reflect new features, enhancements, and changes to the platform. Collaborate with cross functional teams, including Engineering and Product Management, to ensure accuracy and completeness...

Nohr LLC - Rapid Castings Manufacturer

3D Sand Printing Technician Job at Nohr LLC - Rapid Castings Manufacturer

 ...This position is full-time, M-F, 6:30am - 3:00pm, 40 hours per week with overtime potential! We are looking for a competent Sand Printing Technician to work in a team environment to meet the fast-paced production requirements and quality objectives of the company. 3...