Data Analyst

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

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