SQL & Power BI Developer

Allied Resources Technical Consultants; Oak Brook (IL); Hybrid; USD 69,000 - 85,000; Full time

Job summary

Allied Resources Technical Consultants seeks an experienced SQL & Power BI Developer for a 12-month contract with a leading Energy & Utilities client in Oak Brook Terrace, IL. The role requires strong SQL development, Power BI dashboard reporting, and database management to support distribution operations and new initiatives.

You will collaborate with stakeholders to gather requirements, optimize queries, and deliver data-driven insights across meter installations and streetlight services in a

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related technical field.
• 5–10 years of experience in Data Analytics, Business Intelligence Development, SQL Development, or a related role.
• Strong proficiency in SQL development, including writing complex queries, extracting data, and optimizing database performance.
• Hands-on experience developing interactive dashboards, reports, and data visualizations using Microsoft Power BI.

Responsibilities

• Develop, maintain, and optimize SQL queries, database reports, and Power BI dashboards to support operational and business reporting needs.
• Analyze data across distribution operations, streetlight services, meter installations, and new business projects.
• Collaborate with business stakeholders to gather reporting requirements, identify data trends, and translate business needs into technical solutions.
• Design and enhance reporting solutions using SQL, Power BI, and enterprise databases.
• Support data integration, reporting automation, and process improvements across business systems.
• Troubleshoot data quality, reporting, and system issues to ensure accurate and reliable information.

Skills

SQL development

Power BI

Data analytics

Education

Bachelor's degree in Computer Science or Information Systems

Tools

Databricks

Microsoft Fabric

Oracle

Microsoft Azure

Job description

Client: Leading Energy & Utilities Organization

Location: Oak Brook Terrace, IL (Hybrid)

Duration: 12-Month Contract

Pay Rate: $50–$62/hr W2

Start Date: ASAP

Work Authorization: Candidates must be authorized to work in the U.S. without the need for employment-based visa sponsorship now or in the future. Sponsorship and future sponsorship are not available for this opportunity, including employment-based visa types H-1B, L-1, O-1, H-1B1, F-1, J-1, OPT, or CPT.

Our client is seeking an experienced SQL & Power BI Developer with strong SQL development, Power BI dashboard reporting, and database management experience to support business operations within the energy and utilities industry. This role focuses on developing data-driven reports, optimizing queries, and delivering actionable insights for distribution operations, new business initiatives, streetlight services, and meter installations. The ideal candidate will have strong technical expertise in SQL, Power BI, and enterprise data platforms, along with the ability to collaborate with business stakeholders to improve reporting capabilities and operational efficiency.

Key Highlights:

• Develop, maintain, and optimize SQL queries, database reports, and Power BI dashboards to support operational and business reporting needs.
• Analyze data across distribution operations, streetlight services, meter installations, and new business projects.
• Collaborate with business stakeholders to gather reporting requirements, identify data trends, and translate business needs into technical solutions.
• Design and enhance reporting solutions using SQL, Power BI, and enterprise databases.
• Support data integration, reporting automation, and process improvements across business systems.
• Troubleshoot data quality, reporting, and system issues to ensure accurate and reliable information.
• Assist with system enhancements, testing, documentation, and implementation of reporting solutions.

Qualifications:

• Bachelor's degree in Computer Science, Information Systems, or a related technical field.
• 5–10 years of experience in Data Analytics, Business Intelligence Development, SQL Development, or a related role.
• Strong proficiency in SQL development, including writing complex queries, extracting data, and optimizing database performance.
• Hands-on experience developing interactive dashboards, reports, and data visualizations using Microsoft Power BI.
• Solid understanding of relational databases, data modeling, and enterprise reporting systems.
• Familiarity with Databricks, Microsoft Fabric, Oracle, and Microsoft Azure.
• Experience gathering business requirements and translating them into reporting and technical specifications.
• Strong analytical, troubleshooting, problem-solving, and communication skills.
• Experience within the energy, utilities, or electric distribution industry is a plus.
• Ability to work collaboratively with technical teams and business stakeholders in a hybrid environment.

EEO Policy:

Allied Resources complies with all Equal Employment Opportunity (EEO) affirmative action laws and regulations. Allied Resources does not discriminate on the basis of age, race, religion, color, sex, national origin, marital status, genetic information, sexual orientation, gender identity and expression, disability, veteran status or other status protected by law.