Data Analyst

Please see Special Instructions for more details.

Be a part of the Red Hawk family and apply today! Benefits start on first day of hire! Extensive paid time off (including Spring Break), College fully pays the in-network health insurance deductible, minimum of 10% employer retirement contribution per payroll, and much more!.

https:// .

Thrive in Southwest Michigan Official transcripts required upon hire.

Monday through Thursday summer work hours apply to this position.

Information on our standard hiring process:
Lake Michigan College will accept applications on this position for at least 14 days. Applications will be screened for minimum qualifications as received. Once the search committee has determined which applicants they would like to interview, those applicants will be contacted. If you have questions, please contact Human Resources at (Use the "Apply for this Job" box below). .

Position Information (Default Section)

Posting Number

Posting Number 0001063

Position Title:

Position Title:

Data Analyst

Reports to:

Chief Information Officer

Department:

Department:
Institutional Research

Classification:

Classification:
Exempt

If Classifed, Facilities, or On-call, hours per week:

Full or Part-time:

Full or Part-time:
Full Time

Job Summary:

This position contributes to data collection and analysis; the production of reports, dashboards, visualizations, and publications; and the management and fulfillment of data requests via the ticketing system. The role requires strong SQL skills for writing complex queries, optimizing performance, and interpreting data models across enterprise databases, including proficiency with Oracle database concepts and schema design. Power BI and SQL Server Reporting Services ( SSRS ) are required for building and delivering enterprise reports and dashboards.

The position supports institutional and enrollment management goals by implementing, automating, and maintaining reporting systems and data pipelines, improving processes, and delivering accurate, timely insights to stakeholders.

College Intro:

Lake Michigan College, located in Benton Harbor, Michigan, is a vibrant community college committed to providing high-quality education and fostering a supportive learning environment. The college offers a diverse range of programs and degrees, including associate degrees, certificates, and transfer programs designed to help students achieve their academic and career goals. With modern facilities, experienced faculty, and a strong focus on student success, Lake Michigan College prepares students for a variety of careers and further education opportunities.

Whether you’re looking to start your college journey, enhance your skills, or explore new career paths, Lake Michigan College provides the resources and support needed to succeed.

Essential Functions:

1. Manage data collection, analysis, and report development including development of datasets, dashboards, and publications using Power BI/ SSRS .

2. Manage customer requests for information, triage and fulfill via the IR service portal; document requirements, sources, and definitions.

3. Responsible for enterprise reporting development using Power BI and SSRS ; designs, develops, and maintains datasets, paginated reports, dashboards, and data models aligned to institutional standards.

4. Work with institutional stakeholders to gather, understand, and define business requirements.

5. Apply appropriate statistical techniques; ensure reproducibility of methods. to provide reports to, and answer questions from stakeholders.

6. Identifies and resolves production and/or applications development problems related to reporting data flows, queries, and scheduled report delivery.

7. Uses data and system analysis to identify opportunities to improve and automate business processes and collaborate with internal stakeholders in developing recommendations on these process improvements.

8. Writes, optimizes, and maintains complex SQL queries and stored procedures across Oracle and SQL Server; implements and monitors reporting data pipelines; creates validation checks and audit trails.

9. Maintains current and accurate knowledge of data storage and management best practices.

10. Designs and maintains reporting semantic layers/data models that meet requirements efficiently and reliably.

11. Track project performance, specifically to analyze successful completion of short and long-term goals.

12. Updates and maintains the institutional reporting calendar; sequences and tracks cross-department deliverables; ensures on-time publication and compliance submissions

13. Coordinates access provisioning for reporting content and data sources in collaboration with IT/IR; manages security roles for reports and data models consistent with FERPA and institutional policy.

14. Develops and enforces reporting style guides and visualization standards; reviews and validates enterprise reports prior to release for accuracy, accessibility, and consistency.

15. Ability to…