Data Analyst: Enterprise Reporting & Dashboards

Lake Michigan College; Benton Harbor (MI); On-site; USD 65,000 - 90,000; Full time

Job summary

Lake Michigan College is seeking a Data Analyst to support data collection, analysis, and reporting across institutional datasets. The role emphasizes building dashboards with Power BI and reports with SSRS, plus strong SQL across Oracle and SQL Server to deliver timely insights to stakeholders.

Responsibilities include managing data requests, ensuring data quality, and developing scalable data pipelines while collaborating with IT and Institutional Research.

Qualifications

• Bachelor's degree required; preferred fields include data analytics, statistics, information systems, computer science or related.
• Two or more years of experience in data analysis and institutional reporting required.
• Advanced SQL for complex queries, data modeling across Oracle and SQL Server/T-SQL.
• Proficiency with Power BI and SQL Server Reporting Services (SSRS) for dashboards and paginated reports.
• Strong understanding of relational databases, data models, and data quality checks.

Responsibilities

• Manage data collection, analysis, and report development including datasets, dashboards, and publications using Power BI/SSRS.
• Triage and fulfill data requests via IR service portal; document sources and definitions.
• Develop enterprise reporting using Power BI/SSRS; design and maintain datasets, dashboards, and data models.
• Collaborate with stakeholders to gather business requirements.
• Apply statistical techniques and ensure reproducibility of methods for stakeholder reports.
• Identify and resolve data reporting issues across Oracle and SQL Server.
• Design and maintain reporting data pipelines and validation checks.
• Maintain knowledge of data storage and management best practices.
• Create and maintain reporting semantic layers and data models efficiently.
• Ensure on-time publication and compliance in reporting calendars.
• Coordination of access provisioning for reports and data sources with IT/IR.
• Develop standards and documentation for reporting and training.
• Cross-training on Power BI, SSRS, and SQL fundamentals.
• Other duties as assigned.

Skills

SQL

Power BI

SSRS

Python

Oracle

SQL Server

Education

Bachelor's degree in data analytics/statistics/information systems/computer science

Tools

Oracle

SQL Server

SSRS

Power BI

Job description

Lake Michigan College is seeking a Data Analyst to support data collection, analysis, and reporting across institutional datasets. The role emphasizes building dashboards with Power BI and reports with SSRS, plus strong SQL across Oracle and SQL Server to deliver timely insights to stakeholders.

Responsibilities include managing data requests, ensuring data quality, and developing scalable data pipelines while collaborating with IT and Institutional Research.