Utility Data Programmer Analyst

Accountabilities: Analyze large and complex datasets originating 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 across multiple sources.

Identify and investigate data-quality issues, including missing records, duplicate assets, inconsistent attributes, invalid relationships, and discrepancies between systems.

Support the validation and reconciliation of asset records across platforms such as GIS, SAP, inspection systems, and document repositories.

Create dashboards, reports, performance metrics, and other analytical products using Power BI or comparable business intelligence tools.

Build and maintain analytical workflows within Palantir Foundry or similar cloud-based data integration and analytics platforms.

Translate operational, engineering, business, and regulatory requirements into structured data specifications and analytical procedures.

Automate recurring data-processing, quality-control, and reporting activities where appropriate to improve efficiency and consistency.

Document data sources, business rules, assumptions, calculations, validation procedures, and analytical findings to ensure traceability.

Produce clear summaries of data issues, root causes, trends, risks, and recommended corrective actions for both technical and nontechnical audiences.

Collaborate with utility stakeholders and project teams to resolve data questions and improve the completeness, accuracy, and reliability of asset information.

Support project tracking, quality assurance, client reporting, and preparation of project deliverables.

Handle sensitive utility and client information in accordance with confidentiality, cybersecurity, and data-governance requirements.

Requirements:

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

Demonstrated 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 dashboards, reports, or analytical products with Microsoft Power BI, Tableau, or a comparable platform.

Strong Microsoft Excel skills, including advanced formulas, pivot tables, data validation, and analysis of large datasets.

Ability to translate business and operational requirements into structured analytical methods and repeatable processes.

Strong analytical and problem-solving abilities, with exceptional attention to data accuracy, completeness, consistency, and traceability.

Ability to communicate technical findings clearly and effectively to both technical and nontechnical stakeholders.

Experience creating process documentation, data dictionaries, validation rules, technical work instructions, or similar materials.

Ability to manage multiple assignments, prioritize effectively, and deliver high-quality work in a deadline-driven consulting environment.

Preferred experience working with electric, gas, or water utility data and infrastructure.

Familiarity with utility assets such as poles, transformers, conductors, underground structures, streetlights, switches, protective devices, pipelines, meters, or related infrastructure.

Experience reconciling information across GIS, SAP, enterprise asset management, inspection, maintenance, or work management systems is advantageous.

Experience with Palantir Foundry, including datasets, pipelines, transformations, ontology objects, dashboards, or analytical applications, is preferred.

Familiarity with Esri ArcGIS, spatial data, geodatabases, or GIS-based asset analysis is a plus.

Experience with Python, R, Power Query, DAX, or other data-processing and automation technologies is desirable.

Knowledge of data governance, metadata management, data lineage, master data management, or utility asset registries is beneficial.

Experience supporting regulatory, compliance, audit, asset-validation, infrastructure-modernization, or similar initiatives is preferred.

Familiarity with electric utility distribution or transmission operations and/or consulting experience with utility stakeholders is advantageous.

Must be currently authorized to work full-time in the United States; employment visa sponsorship is not available for this position.

Benefits:

Annual salary range of $90,000–$125,000 , with final compensation based on geographic location, experience, qualifications, and market conditions.

Fully remote work environment.

Flexible work schedules for eligible positions.

Medical, dental, and vision insurance.

Short-term and long-term disability insurance.

Flexible Spending Account (FSA).

Health Savings Account (HSA).

Basic life and AD&D insurance.

401(k) plan.

Paid time off and company holidays.

Leave of absence programs.

Employee referral program.

Professional development, formal training, and certification opportunities.

Charitable contribution matching.

Team-building and employee engagement activities.

Opportunity to work on multidisciplinary projects involving utility infrastructure, data, analytics, GIS, and operational improvement.

How Jobgether works: We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team. We appreciate your interest and wish you the best!  Why Apply Through Jobgether? 

Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time.

#LI-CL1