SQL Developer/Power BI Developer

Allied Resources Technical Consultants; Chicago (IL); Hybrid; USD 77,000 - 129,000; Full time

Job summary

Allied Resources Technical Consultants is seeking an experienced SQL Developer / BI Developer to support New Business and Distribution Operations. The role focuses on SQL development, data extraction, reporting, and BI using Power BI, Oracle, Azure, Databricks, and Microsoft Fabric.

The ideal candidate will have 5–10 years of hands-on SQL development experience, strong data modeling skills, and the ability to translate business requirements into reliable data solutions.

Qualifications

• 5–10 years hands-on SQL development experience.
• Experience with relational databases and data extraction.
• Experience with Power BI dashboard and report development.
• Bachelor's degree in CS or IS or related field.

Responsibilities

• Develop, optimize, and maintain complex SQL queries and data extracts.
• Query enterprise databases to support reporting.
• Develop and maintain Power BI dashboards and reports.
• Validate data and troubleshoot reporting issues.
• Analyze database structures for reporting needs.
• Translate requirements into SQL solutions and reporting specs.
• Identify data quality issues and resolve discrepancies.
• Support data integration across Oracle, Azure, Databricks, Fabric.
• Create data models and datasets for BI and operations.
• Document queries, sources, and reporting logic.
• Collaborate with analysts, developers, and ops teams.

Skills

SQL development

Relational databases

Power BI dashboard

Data modeling

Data extraction

Troubleshooting

Education

Bachelor's degree in Computer Science or Information Systems

Tools

Power BI

Oracle

Azure

Databricks

Microsoft Fabric

Job description

Location: Oak Brook Terrace, IL - Hybrid

Contract: 12 months

Schedule: 40 hours/week

Pay: $50-$62/hr + 1.5x OT

Experience: 5-10 years

Education: Bachelor’s degree in Computer Science, Information Systems, or related field

Start: ASAP

Position Overview

ARTC is seeking an experienced SQL Developer / BI Developer to support its New Business and Distribution Operations teams. This role will focus primarily on SQL development, database querying, data extraction, reporting, and business intelligence.

The ideal candidate will have strong hands-on SQL development experience and the ability to work with large datasets, develop complex queries, support reporting requirements, and translate business needs into reliable data solutions. Experience with Power BI, Oracle, Azure, Databricks, and Microsoft Fabric is highly valued.

Key Responsibilities

• Develop, optimize, and maintain complex SQL queries, scripts, stored procedures, and data extracts.
• Query and analyze data from enterprise databases to support business and operational reporting.
• Develop and maintain Power BI dashboards and reports using data extracted from various sources.
• Perform data validation, reconciliation, and troubleshooting to ensure reporting accuracy.
• Analyze existing database structures and determine the appropriate data sources for reporting requirements.
• Work with business users to understand data and reporting requirements.
• Translate business requirements into SQL queries, data solutions, and reporting specifications.
• Identify data quality issues and troubleshoot discrepancies across systems.
• Support data integration and reporting initiatives involving Oracle, Azure, Databricks, and Microsoft Fabric.
• Develop data models and datasets used for operational reporting and business intelligence.
• Document queries, data sources, reporting logic, and technical solutions.
• Collaborate with business analysts, developers, and operational teams to deliver data-driven solutions.

Required Skills

• 5-10 years of hands-on SQL development experience
• Experience working with relational databases
• Strong database querying and data extraction skills
• Experience with Power BI and dashboard/report development
• Ability to troubleshoot data and reporting issues
• Strong understanding of database structures, tables, relationships, and data models
• Strong analytical and problem-solving skills
• Bachelor's degree in Computer Science, Information Systems, or related field