Power BI Data Analyst — Hybrid in SF with KPI Dashboards

Amplytics Inc.; San Francisco, Northern (CA, KY); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

We participate in E-Verify

Certified Small Business (SB/MB)

Certified Great Place to Work

Job summary

Amplytico seeks an experienced Data Analyst to transform client data into actionable insights through dashboards and analytics. You will design Power BI dashboards, build Power Apps, and model data across sources, enabling KPI-driven decisions.

The role is hybrid, requiring onsite presence at client locations or our San Francisco office up to 2 days per week. Strong communication with stakeholders is essential.

Qualifications

• 3+ years of hands-on experience building Power BI dashboards with 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 with relational databases, data warehouses, or cloud data platforms (Azure preferred).
• Ability to translate business requirements into well-structured data models and visualizations.
• Excellent communication skills presenting findings to technical and non-technical stakeholders.

Responsibilities

• Consult with clients to understand their business requirements and data needs.
• Design, develop, and maintain Power BI dashboards and reports surface KPIs for operations, asset management, and financial planning.
• Build and customize Power Apps to automate workflows and improve data collection across client organizations.
• Connect to and model data from sources including data warehouses, SQL databases, SharePoint, and OT systems.
• Write DAX measures and Power Query transformations to support analytics and reporting.
• Collaborate with stakeholders to gather requirements, define KPIs, and translate needs into technical specs.
• Create and maintain data models with relationships, hierarchies, and row-level security.
• Integrate Power Automate flows with Power Apps and Power BI for end-to-end processes.
• Perform data validation, quality assurance, and troubleshooting to ensure accuracy.
• Document architectures, data dictionaries, and user guides for handover.

Skills

Power BI dashboards

Data modeling

DAX

Power Query

Power Apps

Power Automate

SQL

Azure

Data visualization

Education

Bachelor’s degree in a relevant field

Tools

Dataverse

Azure

Job description

Amplytico seeks an experienced Data Analyst to transform client data into actionable insights through dashboards and analytics. You will design Power BI dashboards, build Power Apps, and model data across sources, enabling KPI-driven decisions.

The role is hybrid, requiring onsite presence at client locations or our San Francisco office up to 2 days per week. Strong communication with stakeholders is essential.