Utility Data Programmer Analyst

🕒 August 20

🏄 California – Remote

🏄 California – Remote

💵 $90k - $125k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

🖥 Software Engineer

👻 Ghost score 0%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Celerity Consulting Group

WebsiteLinkedInAll Job Openings

51 - 200 employees

⚖️ Legal

📦 Logistics

⚡ Energy

Legal • Logistics • Energy

Celerity Consulting Group is a consulting firm specializing in empowering public utility organizations by converting complex data into clear, actionable intelligence. They aim to mitigate risk, optimize assets, and maximize project results in the energy sector. The company offers strategic consulting, project management, and expert data analysis services, focusing on electric and gas utility consulting, utility vegetation management, and litigation support. Celerity's extensive expertise helps clients prepare for, prevent, and protect against incidents, ensuring safety and performance. Their unique approach involves refining and converting raw data into valuable insights to support utility operations and engineering challenges.

📋 Description

• 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

• 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

• 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