SQL Developer / BI Developer

Allied Resources Technical Consultants; Oak Brook (IL); Hybrid; USD 69.000 - 85.000; Vollzeit

Zusammenfassung

Allied Resources Technical Consultants is seeking a Data Analyst / BI Developer on a 12-month contract in Oak Brook Terrace, IL, hybrid work arrangement. The role focuses on SQL development, Power BI dashboard creation, and data reporting to enhance operational efficiency and decision-making.

The ideal candidate has 5–10 years of data analysis and BI experience, strong SQL skills, and familiarity with Databricks, Microsoft Fabric, Oracle, and Azure. Start ASAP; sponsorship is not provided.

Qualifikationen

• Bachelor’s degree in Computer Science, Information Systems, or a related technical field.
• 5–10 years of experience in data analysis, BI development, SQL development, or related roles.
• Strong proficiency in SQL, including complex queries and optimization.
• Hands-on experience building interactive dashboards/reports with Power BI.
• Solid understanding of relational databases, data modeling, and reporting processes.

Aufgaben

• Develop and optimize SQL queries, reports, and Power BI dashboards to support operations and performance tracking.
• Analyze data across distribution operations, streetlight services, meter installations, customer charging, and new business projects.
• Extract, transform, and analyze data from multiple databases to deliver accurate reporting and insights.
• Collaborate with stakeholders to gather requirements, identify reporting needs, and improve processes.

Kenntnisse

SQL development

Power BI

Data analysis

Relational databases

Data modeling

SQL optimization

Ausbildung

Bachelors in CS/IS or related

Tools

Databricks

Microsoft Fabric

Oracle

Azure

Jobbeschreibung

Client: Leading Energy & Utilities Organization

Location: Oak Brook Terrace, IL (Hybrid)

Employment Type: 12-Month Contract

Pay Rate: $50-$62/hour (Overtime at 1.5x)

Start Date: ASAP

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, a leading organization in the Energy & Utilities industry, is seeking an experienced Data Analyst / BI Developer to support its New Business and Distribution Operations teams. This position focuses on SQL development, Power BI dashboard creation, database reporting, and data analysis to improve operational efficiency and business decision-making. The ideal candidate will have strong experience working with relational databases, developing reports and queries, and translating complex business requirements into actionable insights.

Key Highlights

• Develop and optimize SQL queries, reports, and Power BI dashboards to support business operations and performance tracking.
• Analyze data across distribution operations, streetlight services, meter installations, customer charging, and new business projects.
• Extract, transform, and analyze data from multiple databases to deliver accurate reporting and actionable insights.
• Collaborate with business stakeholders to gather requirements, identify reporting needs, and improve existing processes.
• Support data integration, reporting, and analytics initiatives utilizing technologies such as Databricks, Microsoft Fabric, Oracle, and Azure.
• Troubleshoot reporting issues, validate data accuracy, and support enhancements to business intelligence solutions.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related technical field.
• 5-10 years of experience in data analysis, business intelligence development, SQL development, or related roles.
• Strong proficiency in SQL, including developing complex queries, extracting data, and optimizing database reporting.
• Hands-on experience developing interactive dashboards and reports using Microsoft Power BI.
• Solid understanding of relational databases, data modeling, and reporting processes.
• Familiarity with Databricks, Microsoft Fabric, Oracle, and Microsoft Azure.
• Strong analytical, problem-solving, and communication skills with the ability to collaborate across technical and business teams.
• Experience supporting utility operations, distribution systems, or energy industry reporting is a plus.

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.