Power BI & Power Apps Analytics Consultant

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

Benefits offered by this job

Hybrid work model

Job summary

Amplytico is seeking an experienced Data Analyst with strong Microsoft Power BI expertise to help clients transform their data into actionable insights through dashboards, reporting, and analytics solutions.

This position requires onsite presence at client locations and/or our San Francisco office up to 2 days per week. The role is hybrid (partial remote/partial onsite) and not eligible for full remote work.

Qualifications

• 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 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 for presenting findings to technical and non-technical stakeholders.

Responsibilities

• Consult with clients to understand business requirements and data needs.
• Design, develop, and maintain Power BI dashboards and reports surfacing KPIs.
• Build and customize Power Apps to automate workflows and improve data collection.
• Connect to and model data from diverse sources including data warehouses, SQL databases, SharePoint, and OT systems.
• Write DAX measures and Power Query transformations to support advanced analytics.
• Collaborate with client stakeholders to gather requirements and translate business needs into specifications.
• 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, QA, 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 development

SQL

Azure

Dataverse

Communication skills

Education

Bachelor’s degree in Data Analytics, Computer Science, Information Systems, Business, Engineering, or a related field

Tools

Power Automate

SharePoint

Dataverse

Job description

Amplytico is seeking an experienced Data Analyst with strong Microsoft Power BI expertise to help clients transform their data into actionable insights through dashboards, reporting, and analytics solutions.

This position requires onsite presence at client locations and/or our San Francisco office up to 2 days per week. The role is hybrid (partial remote/partial onsite) and not eligible for full remote work.