Data Analyst

Amplytico; San Francisco (CA); Hybrid; USD 90,000 - 135,000; Full time

Job summary

A data analytics company is seeking an experienced Data Analyst to transform client data into actionable insights via Power BI dashboards and analytics solutions. The role requires collaboration with clients for understanding business needs, with a background including 3+ years in Power BI, 2+ years in Power Apps, and a Bachelor's degree in a related field. This hybrid position requires onsite presence at client locations and the San Francisco office up to 2 days a week.

Qualifications

• 3+ years of experience building Power BI dashboards.
• 2+ years of experience developing Power Apps.
• Proficiency in SQL for data extraction and transformation.

Responsibilities

• Design and maintain Power BI dashboards for key performance indicators.
• Build and customize Power Apps to automate workflows.
• Collaborate with clients to gather requirements and define KPIs.

Skills

Power BI dashboards

Power Apps

SQL skills

Data validation

Communication skills

Education

Bachelor's degree in Data Analytics or related field

Tools

Power Automate

Dataverse

SQL databases

Azure

Job description

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.

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.

Equal Opportunity

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 [e-mail].