Hybrid Data Analyst: Power BI, SQL & AI Insights

Midwest Technical Institute; Chicago (IL); Hybrid; USD 90,000 - 105,000; Full time

Benefits offered by this job

Health Insurance

Dental

Vision

Retirement Plans

Paid Time Off

Job summary

Midwest Technical Institute (MTI), Delta Technical College (DTC), and MTI Online are seeking an experienced Data Analyst to join our Information Technology team. This hands-on role turns data into insights, partnering with leaders to drive action through dashboards, KPIs, and scalable analytics.

You’ll build Power BI dashboards, optimize SQL queries, and develop Python-based data automation within a hybrid Illinois-based environment.

Qualifications

• Bachelor's degree or equivalent experience in data analytics or IT.
• 4+ years of experience in Data Analytics, BI, or Reporting Analytics.
• Strong MS SQL Server skills.
• Proficiency with Python for data analysis and automation.
• Hands-on experience developing dashboards and reports in Power BI.
• Experience developing ETL/data pipelines.
• Experience with MongoDB, Microsoft Fabric, or other modern data platforms.
• Ability to work with executive-level stakeholders and translate needs into reporting.

Responsibilities

• Develop and maintain organizational KPIs, business reporting, and executive dashboards.
• Build interactive Power BI dashboards and reporting solutions.
• Write, optimize, and troubleshoot MS SQL Server queries, stored procedures, and views.
• Use Python for data analysis, automation, and pipeline development.
• Design and maintain ETL pipelines to clean, transform, and integrate data.
• Create exception reporting that identifies anomalies and out-of-threshold conditions.
• Work with MongoDB and/or Microsoft Fabric within modern data platform environments.
• Partner directly with executives and business leaders to translate reporting needs into actionable solutions.
• Support emerging AI-driven analytics initiatives.

Skills

Data analysis

Stakeholder communication

Dashboard creation

Problem solving

Education

Bachelor's degree in Data Analytics, CS, IS or related field

Tools

MS SQL Server

Power BI

Python

MongoDB

Microsoft Fabric

ETL pipelines

Job description

Midwest Technical Institute (MTI), Delta Technical College (DTC), and MTI Online are seeking an experienced Data Analyst to join our Information Technology team. This hands-on role turns data into insights, partnering with leaders to drive action through dashboards, KPIs, and scalable analytics.

You’ll build Power BI dashboards, optimize SQL queries, and develop Python-based data automation within a hybrid Illinois-based environment.