Utility Data Analyst & Insights Engineer

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

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

401(k) plan

Remote work options

Job summary

Celerity Consulting Group, LLC, based in Walnut Creek, CA, seeks a Utility Data Programmer Analyst to support data-intensive electric, gas, and water utility projects. The role focuses on asset-data validation, data integration, and analytics to deliver reliable, actionable information.

You will work with PMs, GIS and data teams to transform complex utility data, build dashboards in Power BI, and develop Palantir Foundry workflows, while ensuring data quality and governance across platforms.

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.
• Translate business, operational, engineering, and regulatory requirements into data specifications and analytical procedures.
• Automate recurring data-processing, quality-control, and reporting activities where practical.
• Document data sources, business rules, assumptions, calculations, validation procedures, and analytical findings.
• Produce clear summaries of data issues, root causes, trends, risks, and recommended corrective actions.
• Collaborate with utility personnel and project teams to resolve data questions and improve the completeness and reliability of asset information.
• Support project tracking, quality assurance, client reporting, and preparation of deliverables.
• Handle utility and client information in accordance with confidentiality, cybersecurity, and data-governance requirements.

Skills

SQL

Data analysis

Data visualization

Data integration

Relational databases

Power BI

Python

R

Education

Bachelor’s degree in data analytics, computer science, information systems, engineering, geography, mathematics, statistics, or a related discipline

Tools

Palantir Foundry

Esri ArcGIS

SAP

Tableau

Power BI

Job description

Celerity Consulting Group, LLC, based in Walnut Creek, CA, seeks a Utility Data Programmer Analyst to support data-intensive electric, gas, and water utility projects. The role focuses on asset-data validation, data integration, and analytics to deliver reliable, actionable information.

You will work with PMs, GIS and data teams to transform complex utility data, build dashboards in Power BI, and develop Palantir Foundry workflows, while ensuring data quality and governance across platforms.