Onsite Data Analyst — Power BI, SQL & MES Dashboards

Sterling Engineering; Waukegan (IL); On-site; USD 120,000 - 150,000; Full time

Job summary

Sterling Engineering is seeking a hands-on Data Analyst to develop dashboards, analyze operational data, and provide actionable insights to business and operations leadership.

The role emphasizes Power BI, SQL, and MES, with responsibilities including data cleansing, KPI reporting, and presenting findings to drive operational improvements. This is a 36-month contract requiring onsite work in Waukegan, IL.

Qualifications

• SQL – ability to write queries and analyze data.
• Experience with MES (Manufacturing Execution System).
• Advanced Microsoft Excel.
• Data cleansing, transformation, validation, and analysis.
• KPI/dashboard development and reporting.
• Experience combining data from multiple systems/sources.
• Strong analytical and root-cause problem-solving skills.
• Experience gathering requirements directly from business stakeholders.

Responsibilities

• Build and maintain Power BI dashboards and KPI reporting
• Write SQL queries to extract and analyze data
• Clean, transform, validate, and reconcile large datasets
• Identify trends, performance gaps, and root causes
• Automate recurring reporting and improve existing dashboards
• Translate business needs into reporting and analytics solutions
• Present findings to business and operations leadership
• Support operational performance and continuous improvement initiatives

Skills

SQL

Power BI

Excel

Data cleansing

KPI dashboards

Data analysis

Stakeholder management

MES experience

Tools

MES

Tableau

Qlik Sense

Power Apps

SAP

Job description

Sterling Engineering is seeking a hands-on Data Analyst to develop dashboards, analyze operational data, and provide actionable insights to business and operations leadership.

The role emphasizes Power BI, SQL, and MES, with responsibilities including data cleansing, KPI reporting, and presenting findings to drive operational improvements. This is a 36-month contract requiring onsite work in Waukegan, IL.