Data Analytics Specialist — Power BI & SQL Expert

University of California; Benton Harbor (MI); On-site; USD 63,000 - 76,000; Full time

Job summary

Lake Michigan College, located in Benton Harbor, Michigan, is seeking a Data Analyst to contribute to data collection, analysis, and the production of reports and dashboards. The role requires strong SQL skills, Oracle/SQL Server experience, and proficiency in Power BI and SSRS for enterprise reporting.

You will work with Institutional Research to automate data pipelines, improve processes, and deliver timely insights to stakeholders.

Qualifications

• Bachelor’s degree in a data analytics, information systems, CS or related field.
• Two+ years of data analysis and institutional reporting experience.
• Advanced SQL skills for complex queries, data modeling across Oracle and SQL Server.
• Proficiency with Power BI and SSRS for enterprise dashboards and reports.
• Familiarity with FERPA data security and report access controls.
• Python for data wrangling/automation is a plus.

Responsibilities

• Contribute to data collection, analysis, and report development.
• Build dashboards, publications, and data visualizations using Power BI/SSRS.
• Triage and fulfill data requests via IR service portal; document requirements.
• Develop and maintain enterprise reporting datasets and data models.
• Work with stakeholders to gather business requirements and ensure accuracy.

Skills

Advanced SQL

Power BI

SSRS

Python

Data modeling

Relational databases

ETL tools

Education

Bachelor’s degree

Tools

Oracle

SQL Server

SSIS

SRSS

Job description

Lake Michigan College, located in Benton Harbor, Michigan, is seeking a Data Analyst to contribute to data collection, analysis, and the production of reports and dashboards. The role requires strong SQL skills, Oracle/SQL Server experience, and proficiency in Power BI and SSRS for enterprise reporting.

You will work with Institutional Research to automate data pipelines, improve processes, and deliver timely insights to stakeholders.