Remote Utility Data Analyst & Programmer

Celerity; Walnut Creek (CA); On-site; USD 90,000 - 125,000; Full time

Benefits offered by this job

Employee Referral Program

Professional Development

Charitable Contribution Match

Job summary

Based in Walnut Creek, CA with offices nationwide, Celerity energy engineers perform a critical, leadership role as strategic liaisons between data, assets and the teams that make projects happen in the field.

Celerity seeks a Utility Data Programmer Analyst to support data-intensive electric, gas, and water utility projects, including asset-data validation, data quality, and analytics across GIS and ERP systems. The role emphasizes data-driven insights and regulatory compliance.

Qualifications

• Bachelor’s degree in data analytics, computer science, information systems, engineering, geography, mathematics, statistics, or a related discipline.
• Experience analyzing complex datasets using SQL and relational database concepts.
• Working knowledge of data structures, joins, keys, relationships, normalization, and data-quality controls.
• Experience developing reports, dashboards, or analytical products using Microsoft Power BI, Tableau, or a comparable platform.
• Ability to interpret business requirements and convert them into structured analytical methods.

Responsibilities

• Analyze large datasets from utility systems such as GIS, enterprise asset management, work management, inspection, maintenance, and operational databases.
• Develop SQL queries, scripts, and repeatable workflows to extract, join, transform, validate, and reconcile data from multiple sources.
• Identify data quality issues, including missing records, duplicate assets, inconsistent attributes, invalid relationships, and discrepancies between systems.
• Support the validation and reconciliation of utility asset records across platforms such as GIS, SAP, inspection systems, and document repositories.
• Develop dashboards, reports, and performance metrics using Microsoft Power BI or similar business intelligence tools.
• Build and maintain analytical workflows within Palantir Foundry or comparable cloud-based data integration and analytics platforms.

Skills

SQL & relational DB analysis

Data quality & reconciliation

BI & visualization

Stakeholder communication

Analytical problem solving

Process documentation

Confidential data handling

Education

Bachelor’s degree in data analytics / CS / IS / engineering

Tools

Palantir Foundry

Power BI

Tableau

Esri ArcGIS

Python

R

Power Query / DAX

Job description

Based in Walnut Creek, CA with offices nationwide, Celerity energy engineers perform a critical, leadership role as strategic liaisons between data, assets and the teams that make projects happen in the field.

Celerity seeks a Utility Data Programmer Analyst to support data-intensive electric, gas, and water utility projects, including asset-data validation, data quality, and analytics across GIS and ERP systems. The role emphasizes data-driven insights and regulatory compliance.