About UES
Utility Energy Services (UES) provides energy efficiency program implementation services to utilities across the U.S. We support the design, execution, and optimization of utility energy efficiency programs by leveraging data-driven insights and industry best practices.
Position Overview
UES is seeking a Business Intelligence Engineer to join our growing Technology Solutions team. This is a hybrid role that combines data engineering, business intelligence, and solution architecture. We’re looking for someone who enjoys building technical systems and translating business needs into scalable, impactful data tools.
As a key member of our team, you will design, build, and maintain cloud-based infrastructure using Microsoft Azure, support automation through Power Platform tools, and contribute to end-to-end data solution development. The ideal candidate has strong skills in SQL and Python, understands database engineering, and thrives on turning complex problems into well-structured solutions that support business performance and insight.
This role is both technical and strategic. You’ll write code, manage and optimize databases, and also collaborate with stakeholders to shape solution design, improve workflows, and enhance how data is used across the organization.
Key Responsibilities
•Design, build, and manage scalable Azure SQL Databases, Azure Data Lake Storage, and related cloud-based data infrastructure
•Implement secure data access protocols and cloud storage best practices
•Develop and maintain ETL/ELT pipelines using Azure Data Factory, Python, and SQL for both batch and real-time ingestion
•Monitor pipeline performance and implement error handling, alerting, and logging mechanisms
•Design and maintain data integration workflows with third-party APIs and internal platforms to enable seamless data exchange
•Create and maintain automation tools and scripts using Python, Power Automate, or similar technologies to streamline data operations
•Configure scheduled jobs, triggers, and task dependencies to ensure operational reliability
•Collaborate with business users, analysts, and developers to gather requirements and design effective technical solutions
•Validate data accuracy, document pipeline architecture, and contribute to long-term platform scalability
Qualifications & Experience
•Bachelor’s degree in Computer Science, Information Systems, Engineering, Data Analytics, or a related field
•3+ years of experience in a technical data role such as BI Engineer, Data Engineer, or Data Systems Analyst
•Strong proficiency in SQL for querying, data modeling, and database management
•roficiency in Python (or similar scripting language) for automation, data transformation, and workflow management
•Hands-on experience with Azure cloud services such as Azure SQL, Data Factory, Data Lake, or Synapse Analytics
•Familiarity with ETL/ELT pipelines, API integrations, and real-time or batch data ingestion
•Strong analytical and problem-solving skills, with the ability to translate business needs into scalable data solutions
•Excellent communication and collaboration skills, including the ability to work cross-functionally and explain technical concepts to non-technical audiences
•A growth mindset with a passion for clean, maintainable systems and continuous improvement
Job Type: Full-time
Pay: $70,000.00 - $80,000.00 per year
Benefits:
Compensation Package:
Schedule:
Application Question(s):
•Will you now or in the future require visa sponsorship for employment in the United States?
Ability to Commute:
•Chicago, IL 60607 (Required)
Ability to Relocate:
•Chicago, IL 60607: Relocate before starting work (Required)
Work Location: Hybrid remote in Chicago, IL 60607