Job description

Position Overview: Amplytics 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.) • 3+ 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 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 $90,000 to $130,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

Requirements