Data Analyst

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

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.

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.

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

Amplytico participates in the E-Verify program

Interested in the role?

Amplytico values diverse experiences and the drive to learn over a perfect skill match. If you're a quick learner passionate about making an impact, we encourage you to apply.

Amplytico participates in the E-Verify program
Certified Small Business (SB/MB)
Certified Great Place to Work
582 Market St, Ste 1601, San Francisco, CA 94104
[e-mail]