Data Analytics Consultant Job at Amplytico, Santa Rosa, CA

OVNQTFY0ZHJiY3k5OFJrL1hGMlJFd3VTU1E9PQ==
  • Amplytico
  • Santa Rosa, CA

Job Description

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
  • Microsoft Power BI certifications preferred
  • 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.

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@amplytico.com

Job Tags

Work at office, 2 days per week

Similar Jobs

Oklahoma Goodwill

Store Associates (15th & Midwest Blvd) Job at Oklahoma Goodwill

Goodwill Central Oklahoma is seeking individuals to help grow our mission- We help people overcome challenges to employment. Working at Goodwill is more than a job. Joining our team is a chance to do good for yourself and the community. With our communitys donations and... 

Primary Residential Mortgage

Mortgage Regional VP / Player-Coach Job at Primary Residential Mortgage

 ...Regional Vice President / Player-Coach Were looking for a high-performing Loan Officer who is ready to step into leadershipwithout...  ...staying focused on what they do best: originating and driving business. What This Role Offers The ability to build and lead a... 

Elios Talent

Director Emergency Room Job at Elios Talent

 ...Director of Emergency Services Hospital Leadership Opportunity Permanent Position We are seeking an experienced and dynamic leader...  ..., nurses, and hospital leadership to drive performance, manage resources, and foster a culture of safety, teamwork, and accountability... 

ROE Visual

Warehouse Associate Job at ROE Visual

 ...The Warehouse Associate will be based out of our Chatsworth, CA location. This is a entry-level position at a globally leading LED display...  ...Warehouse Associate receives shipments and restocks orders, ships orders to customers, and maintains the cleanliness and organization... 

Midland-Marvel Recruiters, LLC

Maintenance Team Lead-Plastic Injection Molding Job at Midland-Marvel Recruiters, LLC

 ...Growing company in Vermont that has been in business for over 50 years has a terrific opportunity available for a Lead Plastic Injection Molding Maintenance Technician. This is a day shift position. 8 hour shifts. The Lead Mold Maintenance Technician is responsible for...