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

ak14QlJHVVJTcEVwaWFxT1A2UGRraTZOUUE9PQ==
  • Amplytics
  • Sunnyvale, 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

Boon

Client Onboarding Specialist Job at Boon

 ...The Boon Group has an exciting career opportunity for a Client Onboarding Specialist. The Client Onboarding Specialist works closely with clients, brokers, external vendors, and most departments at Boon and is responsible for managing project timeline, gaining granular... 

Tenth Revolution Group

Entry Level Recruitment Consultant Job at Tenth Revolution Group

 ...Entry Level 360 Recruitment Consultant - Tenth Revolution Group Location: Onsite in Scottsdale, AZ Are you a competitive individual who is looking for a role where you can directly impact your earnings and quickly progress your career? If you are, recruitment could... 

Professional Alternatives

Medical Device Quality Control Inspector Job at Professional Alternatives

 ...manufacturing efforts including final inspection, test of components and assemblies, and disposition of discrepant materials Qualifications:...  ...~2+ years of experience in Quality Control within the medical device industry ~ Solid Microsoft Office Suite ~ Experience in... 

Ultimate Staffing

Remote Medical Assistant/Patient Coordinator Job at Ultimate Staffing

 ...Healthcare services company seeks a work from home Medical Assistant/Patient Coordinator to correspond with patients and physicians in a fast-paced call center environment. This growing organization offers competitive benefits, clear promotional path and great company... 

DB Schenker

AOG Logistics Coordinator Job at DB Schenker

 ...Responsibilities - THIS IS A MUST HAVE WORKED FOR A A FREIGHT FORWARDER (AIR EXPORT)...  ...Very Familiar on booking freight (booking online, phone, emails..) with International Airlines...  ...local branch or RLF department. * Daily data entry into AOG Desk log and record filing for...