Data Analyst

Quanta Services; Sandy Springs (GA); On-site; USD 70,000 - 80,000; Full time

Job summary

Ampacity, part of the Quanta Services family, seeks a Data Analyst to deliver trusted reporting and analytics for multiple business functions. You will translate business needs into data requirements and deliver dashboards, automated reporting, and data assets in cloud environments.

You’ll work with stakeholders to ensure data accuracy, scalability, and timely delivery, enabling faster, better decisions across departments and driving analytics maturity over time.

Qualifications

• Translate business needs into well-defined data requirements.
• Deliver high-quality dashboards and automated reporting.
• Work with cloud data tools and integrations.
• Ensure data is accurate, scalable, timely, and easy for teams to use in decision-making.
• Improve how the organization measures performance and expand analytics capabilities.

Responsibilities

• Serve as a technology-forward analytics partner, turning questions into scalable data solutions.
• Build and maintain Power BI dashboards and automated reporting.
• Use SQL to query, validate, and reconcile data from multiple sources.
• Support data pipelines and integrations across cloud data platforms and ERP data.
• Standardize KPI definitions and reporting methodology to create a reliable single source of truth.
• Develop and maintain Power BI reports (executive scorecards, dashboards, self-service views).
• Write and optimize SQL queries for analysis and reporting datasets.
• Collaborate with stakeholders to gather requirements and priorities.
• Work with cloud data services to support ingestion, transformation, and refresh cadence.
• Assist with data integration validation using an iPaaS platform.
• Perform ad-hoc analysis and translate findings into clear insights.
• Create and maintain documentation for metrics, data sources, and dashboard usage.
• Evolve role as business needs change.

Skills

Stakeholder collaboration

Data visualization

Data modeling

Problem solving

Tools

Power BI

SQL

iPaaS

Job description

About Us

A proud member of the Quanta Services family of companies, Ampacity, LLC (Ampacity) delivers a forward-thinking approach to structural and electrical solutions for clean energy transition projects. From design, kitting, and installation to comprehensive electrical procurement, Ampacity specializes in expert-engineered, field-ready solutions that accelerate project timelines and maximize impact. Made up of more than 350 passionate professionals committed to simplifying complexity across the energy value chain, Ampacity empowers customers to build smarter, faster, and more efficiently—with the most reliable technology in the industry. Headquartered in California, Ampacity maintains facilities in Mississippi, Kentucky, and Iowa, with offices in Florida, Georgia, and Vermont. Since 2014, Ampacity has delivered nearly eight gigawatts of fully engineered clean energy systems across North America.

About this Role

The Data Analyst at Ampacity is a technology-focused role responsible for building trusted reporting, analytics, and data assets that support multiple business functions. This position partners with stakeholders to translate business needs into well-defined data requirements, then delivers high-quality dashboards, automated reporting, and actionable analysis. The Data Analyst will work heavily within modern cloud and integration environments, ensuring data is accurate, scalable, timely, and easy for teams to use in decision-making.

If you enjoy blending data, technology, and business impact, this role is a great fit. As a Data Analyst, you’ll help teams across various departments make faster, better decisions by building reliable reporting and insights. You’ll work with cloud data tools and integrations, connect data across business systems and APIs, and create dashboards that leaders trust. You’ll have the chance to improve how the organization measures performance, reduce manual reporting effort, and expand analytics capabilities over time.

Pay Range: $70,000 - $80,000

What You\'ll Do

• 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 thruth"
• 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.