SQL & Power BI Developer for Utility Analytics

Allied Resources Technical Consultants; Oak Brook (IL); On-site; USD 90,000 - 120,000; Full time

Job summary

Allied Resources Technical Consultants in Oak Brook, IL seeks a SQL Developer/Power BI Developer to support critical initiatives within electric utility operations. The role partners with New Business and Distribution Operations to analyze data and drive insights for customer charging, meter installs, and Streetlight reporting.

You will bridge business and tech teams by documenting requirements, developing data models, and creating dashboards.

Qualifications

• Bachelor’s degree in a related technical field and strong analytical mindset.
• Experience gathering and documenting business and system requirements.
• Ability to work with stakeholders across multiple business functions.
• Experience supporting operational or utility-focused business processes.

Responsibilities

• Gather, analyze, and document business requirements for system enhancements and new initiatives.
• Partner with business stakeholders to understand operational challenges and identify solutions.
• Support New Business and Distribution Operations teams by analyzing data, workflows, and system processes.
• Assist with Streetlight reporting, service requests, meter installation projects, and customer charging initiatives.
• Analyze existing business processes and recommend improvements to increase efficiency and effectiveness.
• Develop functional specifications, process flows, data models, and system documentation.
• Facilitate meetings and workshops with stakeholders to gather requirements and communicate project updates.
• Coordinate testing activities, including test planning, execution, and defect resolution.
• Troubleshoot system issues and provide production support as needed.
• Create user documentation and assist with training efforts.
• Collaborate with technical teams during solution design, development, and implementation.
• Lead small to medium-sized projects or workstreams while managing deliverables and timelines.

Skills

Business Analysis

Analytical Skills

Communication

Requirements Gathering

Education

Bachelor's degree in Computer Science, Information Systems, Business or related field

Tools

Databricks

Microsoft Fabric

Oracle databases

SQL

Data analysis tools

Job description

Allied Resources Technical Consultants in Oak Brook, IL seeks a SQL Developer/Power BI Developer to support critical initiatives within electric utility operations. The role partners with New Business and Distribution Operations to analyze data and drive insights for customer charging, meter installs, and Streetlight reporting.

You will bridge business and tech teams by documenting requirements, developing data models, and creating dashboards.