Utility Data Programmer Analyst

📋 Description

• Analyze large and complex datasets from utility systems (GIS, asset mgmt, work management
• Develop SQL queries, scripts, and workflows to extract, join, transform, and reconcile data across
• Identify data-quality issues and investigate missing records, duplicates, inconsistencies, and
• Validate and reconcile asset records across GIS, SAP, inspection systems, and document repositories.
• Create dashboards and reports using Power BI or similar BI tools to communicate insights.
• Build and maintain analytical workflows in Palantir Foundry or comparable platforms.

🎯 Requirements

• Bachelor’s degree in data analytics, CS, information systems, eng, geography, math, stats, or
• Experience analyzing complex datasets with SQL and relational databases.
• Working knowledge of data structures, joins, relationships, normalization, and data-quality
• Experience creating dashboards/reports with Power BI, Tableau, or equivalent.
• Strong Excel skills with advanced formulas, pivots, data validation, and large datasets.
• Ability to translate business requirements into structured analytical methods and processes.

🎁 Benefits

• Annual salary range of $90,000–$125,000, final compensation based on location/experience.
• Fully remote work environment.
• Flexible schedules for eligible positions.
• Medical, dental, vision insurance; disability insurance; FSA/HSA options.
• 401(k) with employer matching; paid time off; holidays.
• Employee referrals; professional development opportunities.