Utility Data Programmer Analyst

1. About Our Client:
The organization provides consulting services focused on utility data management and analysis. It supports electric, gas, and water utilities by addressing challenges in asset-data validation, data quality, geographic information systems, regulatory compliance, operational analytics, and process improvement.
2. About the Opportunity:
The Utility Data Programmer Analyst role is responsible for transforming complex utility data into reliable and actionable information. This position supports large-scale utility asset-data validation programs and contributes to projects involving asset management and data integration. The role is critical for enhancing data accuracy and supporting decision-making within utility operations.
3. Responsibilities:
Analyze large datasets from utility systems including GIS, asset management, and operational databases.
Develop SQL queries and workflows to extract, transform, validate, and reconcile data.
Identify and resolve data quality issues such as missing records and inconsistencies.
Support validation and reconciliation of utility asset records across multiple platforms.
Create dashboards, reports, and performance metrics using business intelligence tools.
Build and maintain analytical workflows on cloud-based data platforms.
Translate business and regulatory requirements into data specifications and analyses.
Automate data-processing and reporting activities where possible.
Document data sources, business rules, validation procedures, and findings.
Summarize data issues, root causes, trends, risks, and recommend corrective actions.
Collaborate with utility personnel and project teams to improve data completeness and reliability.
Support project tracking, quality assurance, client reporting, and deliverable preparation.
Handle information in compliance with confidentiality and data governance standards.
4. Requirements:
Bachelor’s degree in data analytics, computer science, engineering, or related fields.
Experience with SQL and relational database concepts.
Knowledge of data structures, joins, keys, normalization, and data-quality controls.
Experience with business intelligence tools such as Microsoft Power BI or Tableau.
Ability to interpret business requirements into analytical methods.
Strong problem-solving skills and attention to data accuracy.
Effective communication of technical findings to diverse stakeholders.
Experience preparing documentation such as data dictionaries and validation rules.
Proficiency with Microsoft Excel including advanced features.
Ability to manage multiple assignments and work in deadline-driven environments.
5. Pay Range and Compensation Package:
Pay range: $90,000 - $125,000 annually
Equal Opportunity Statement: Our client is an equal opportunity employer. They celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, or national origin.
Note:
RemoteHunter is a recruitment partner of this role. Please note that all employment decisions, including candidate assessment, interviews, hiring, compensation, and employment terms, are made exclusively by the hiring employer.

Work arrangement
Yes