Ampacity · 5 hours ago
Data Analyst
Monterey, CA
Full-time
Hybrid
Entry, Mid Level
$75K/yr - $85K/yr
2+ years expAmpacity is a member of the Quanta Services family, specializing in clean energy transition projects. The Data Analyst role focuses on building reporting, analytics, and data assets to support business functions, partnering with stakeholders to create dashboards and automate reporting for decision-making.
Clean EnergyConstructionSolar
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
Create and maintain documentation for metrics, data sources, refresh logic, and dashboard usage
This role will evolve over time as business needs change
Qualification
Required
Proficiency in SQL and Python (or R); advanced Excel skills required
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
Preferred
Familiarity with Azure data services such as Azure Blob Storage and Azure Data Factory (or similar cloud ETL/storage tools)
Benefits
401k for eligible employees
Paid vacation, sick days, holidays, parental leave, and bereavement leave
Health resources and wellness support to help you thrive inside and outside of work
Medical, dental, and vision insurance plus additional health assistance
Internal promotion priority with training and skills development programs
Diverse, inclusive environment where you're valued as a whole person
Company
Ampacity
Ampacity (formerly RP Construction Services) delivers a forward-thinking approach to structural and electrical solutions for clean energy transition projects.
201-500 employees
Funding
Current Stage
Growth StageTotal Funding
unknown2023-04-13Acquired
Leadership Team
Eben Russell
Chief Executive Officer
Recent News
Morningstar, Inc.
2024-12-04
Solar Power World
2024-02-18
Company data provided by crunchbase