Utility Data Programmer Analyst

Celerity Consulting Group

Utility data analyst validating electric, gas, and water infrastructure records for Celerity. Building SQL workflows, dashboards, and data-quality solutions for utility clients.

Posted 8/20/2026full-timeRemote • California • 🇺🇸 United StatesMid-LevelSenior💰 $90,000 - $125,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Proficient in analyzing complex datasets and developing SQL queries, scripts, and workflows for data extraction and transformation. Skilled in creating reports and dashboards using Microsoft Power BI and familiar with utility data management and governance.

Highest-signal resume keywords

SQL Query DevelopmentMicrosoft Power BIData Quality ControlPalantir FoundryUtility Data Analysis

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalysisSQLData StructuresData ValidationReport DevelopmentDashboard CreationPythonRMicrosoft ExcelDAX

Soft Skills

Problem-SolvingAttention to DetailCommunication SkillsCollaborationTime Management

Tools & Technologies

Microsoft Power BIPalantir FoundryEsri ArcGISTableauPower Query

Industry Keywords

Utility DataGISSAPData GovernanceAsset ManagementComplianceInfrastructure ModernizationElectric UtilityGas UtilityWater Utility

Tech Stack

Tools & technologies

CloudCyber SecurityPythonSQLTableau

About the role

Key responsibilities & impact

Analyze large datasets from utility 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
Identify data quality issues such as missing records, duplicate assets, inconsistent attributes, invalid relationships, and cross-system discrepancies
Validate and reconcile utility asset records across 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
Document data sources, business rules, assumptions, calculations, validation procedures, and analytical findings
Produce 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 asset-information reliability
Support project tracking, quality assurance, client reporting, and preparation of deliverables
Handle utility and client information according to confidentiality, cybersecurity, and data-governance requirements
Work within multidisciplinary project teams supporting utility clients
Participate in remote collaboration, client meetings, structured data reviews, and occasional travel depending on project requirements
Investigate discrepancies in incomplete or inconsistent source data and develop defensible conclusions

Requirements

What you’ll need

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
Strong problem-solving skills and attention to data accuracy, completeness, and traceability
Ability to communicate technical findings clearly to both technical and nontechnical stakeholders
Experience preparing process documentation, data dictionaries, validation rules, or technical work instructions
Proficiency with Microsoft Excel, including advanced formulas, pivot tables, data validation, and large-dataset analysis
Ability to manage multiple assignments and work effectively in a deadline-driven consulting environment
Experience working with electric, gas, or water utility data preferred
Familiarity with utility assets and infrastructure preferred
Experience reconciling information between GIS, SAP, enterprise asset management, inspection, maintenance, or work management systems preferred
Experience using Palantir Foundry preferred
Familiarity with Esri ArcGIS, spatial data, geodatabases, or GIS-based asset analysis preferred
Experience with Python, R, Power Query, DAX, or other data-processing and automation tools preferred
Knowledge of data governance, metadata management, data lineage, master data management, or utility asset registries preferred
Experience supporting regulatory, compliance, audit, asset-validation, or infrastructure-modernization initiatives preferred
Familiarity with electric utility distribution or transmission operations preferred
Consulting experience or experience working directly with utility stakeholders preferred
Must be currently authorized to work in the United States on a full-time basis
Celerity is unable to sponsor or assume sponsorship of employment visas

Benefits

Comp & perks

Medical Insurance
Dental Insurance
Vision Insurance
Disability Insurance (STD/LTD)
Flexible Spending Account
Health Savings Account
Basic Life/AD&D
401(k) plan
Paid Time Off
Company Holidays
Leave of Absence
Remote work and Flexible Work Schedules (for qualified positions)
Employee Referral Program
Professional Development
Charitable Contribution Match
Formal training and certification
Team-building activities