Utility Data Programmer Analyst

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Utility Data Programmer Analyst based in the United States. This fully remote role supports data-intensive projects across electric, gas, and water utilities, with an initial focus on large-scale asset-data validation. You will transform complex information from GIS, asset management, inspection, maintenance, and operational systems into reliable, actionable insights. The position combines SQL development, data quality analysis, business intelligence, data integration, and utility-domain knowledge. You will work alongside project managers, engineers, GIS specialists, utility subject matter experts, and data analysts in a multidisciplinary consulting environment. Your work will directly support asset accuracy, regulatory initiatives, operational analytics, and process improvement for utility clients. The role offers opportunities to automate recurring workflows, build analytical solutions, and improve the reliability and traceability of critical infrastructure data. It is well suited to a technically strong analyst who enjoys solving complex data problems and communicating findings to diverse stakeholders. 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 communi