Data Analyst

About the job

Position Overview:

We are seeking an experienced Data Analyst with strong Microsoft Power BI expertise to join our team. In this role, you will help clients transform their data into actionable insights through effective dashboarding, reporting, and analytics solutions.

Key Responsibilities:

• Consult with clients to understand their business requirements and data needs
• Design, develop, and maintain Power BI dashboards and reports that surface key performance indicators for utility operations, asset management, and financial planning
• Build and customize Power Apps (Canvas and Model-Driven) to automate workflows, streamline field operations, and improve data collection across client organizations
• Connect to and model data from diverse sources including data warehouses, SQL databases, SharePoint, and operational technology (OT) systems
• Write DAX measures and Power Query (M) transformations to support advanced analytics and reporting requirements
• Collaborate with client stakeholders to gather requirements, define KPIs, and translate business needs into technical specifications
• Create and maintain data models with proper relationships, hierarchies, and row-level security configurations
• Integrate Power Automate flows with Power Apps and Power BI to enable end-to-end automated business processes
• Perform data validation, quality assurance, and troubleshooting to ensure accuracy and reliability of analytical outputs
• Document solution architectures, data dictionaries, and user guides for client handover and knowledge transfer

Qualifications:

Required

• 3+ years of hands-on experience building Power BI dashboards, including data modeling, DAX, and Power Query
• 2+ years of experience developing Power Apps (Canvas Apps required; Model-Driven Apps a plus)
• Proficiency with the broader Power Platform ecosystem including Power Automate and Dataverse
• Strong SQL skills for querying, data extraction, and transformation
• Experience working with relational databases, data warehouses, or cloud data platforms (Azure preferred)
• Demonstrated ability to translate business requirements into well-structured data models and visualizations
• Excellent communication skills with the ability to present findings to both technical and non-technical stakeholders
• Bachelor’s degree in Data Analytics, Computer Science, Information Systems, Business, Engineering, or a related field

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