Data Analyst

Ampacity Monterey, CA $75,000 - $85,000
Full Time Entry Level 2+ years

Posted 3 weeks ago

Interested in this position?

Upload your resume and we'll match you with this and other relevant opportunities.

Upload Your Resume

About This Role

This Data Analyst role focuses on building reliable reporting, analytics, and data assets to support various business functions for a clean energy company. The position involves translating business needs into data requirements, delivering dashboards, automated reporting, and actionable analysis. This role will work with cloud and integration environments to ensure data accuracy, scalability, and accessibility for decision-making.

Responsibilities

  • Serve as a technology-forward analytics partner, turning questions and pain points into scalable data solutions
  • Build and maintain Power BI dashboards, semantic models, and automated reporting that drive operational and financial visibility
  • Use SQL to query, validate, and reconcile data from multiple sources, ensuring consistency and accuracy across reporting outputs
  • Support and validate data pipelines and integrations across cloud data platforms, ERP data, and third-party systems connected via APIs
  • Standardize and document KPI definitions, dataset logic, and reporting methodology to create a reliable “single source of truth”
  • Develop, enhance, and maintain Power BI reports (executive scorecards, operational dashboards, drill-through analysis, and self-service reporting views)
  • Write and optimize SQL queries for analysis, reporting datasets, and data validation/reconciliation
  • Partner with key departmental stakeholders to gather requirements, clarify definitions, and prioritize reporting
  • Work with cloud data services (e.g., storage, orchestration, and analytics tooling) to support data ingestion, transformation, and refresh cadence
  • Assist with data integration validation using an integration platform (iPaaS), including testing and troubleshooting data issues end-to-end
  • Perform ad-hoc analysis and investigation work (variance explanations, trend drivers, exception reporting) and translate findings into clear insights
  • Create and maintain documentation for metrics, data sources, refresh logic, and dashboard usage

Requirements

  • Proficiency in SQL
  • Proficiency in Python (or R)
  • Advanced Excel skills
  • 2+ years building Power BI dashboards and automated reports using DAX, Power Query, and SQL
  • Experience building ETL/ELT pipelines and integrating data via APIs and cross-system connections
  • Strong analytical skills: forecasting, trend analysis, data mining, and anomaly detection
  • Excellent communication skills—translating business needs into technical solutions and presenting insights to non-technical stakeholders

Qualifications

  • 2+ years building Power BI dashboards and automated reports using DAX, Power Query, and SQL

Nice to Have

  • Familiarity with Azure data services such as Azure Blob Storage and Azure Data Factory (or similar cloud ETL/storage tools)

Skills

Excel * Power BI * Python * SQL * APIs * R * ETL/ELT * DAX * Azure Data Factory * Power Query * Azure Blob Storage *

* Required skills

Benefits

Dental Insurance
Parental Leave
Bereavement leave
Health resources and wellness support
Vision Insurance
Medical Insurance
Internal promotion priority
401(k)
Paid Holidays
Paid vacation
Sick Days
Training and skills development programs

About Ampacity

Ampacity, LLC (Ampacity) delivers a forward-thinking approach to structural and electrical solutions for clean energy transition projects, specializing in expert-engineered, field-ready solutions.

Energy & Utilities
View all jobs at Ampacity →