Data Analyst

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

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://www.lakemichigancollege.edu/about .

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 [e-mail] .

Position Information

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 manage and manipulate data with accuracy and precision.

16. Ensures reporting and analytics projects are completed on time and within estimated effort.

17. Assist with ad hoc data collection, data analysis, and report development.

18. Develops and maintains documentation and standards.

19. Maintain internal data project manuals.

20. Develop and maintain technical documentation for internal use and end-user documentation for training purposes

21. WCAG aligned report and dashboard design; color-blind-safe palate; alt-text and narrative summaries

22. Maintain collaborative partnership with stakeholders to gather requirements for projects and openly communicate progress

23. Collaborate with internal IT, ERP , and IR team to share best practices and user knowledge to allow redundancy for troubleshooting and other technical needs

24. Cross-training on Power BI, SSRS , and SQL fundamentals for data consumers.

25. Other duties as assigned.

Other Duties:

Job Specifications:

· 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 query writing, optimization, and data modeling across Oracle and SQL Server/T- SQL

· Proficiency with PowerBI and SQL Servier Reporting Services ( SRSS ) for building enterprise dashboards and paginated reports

· Strong understanding of relational database concepts and reporting data models

· Ability to design and maintain reporting datasets, implement data quality checks, and document lineage definitions

· FERPA compliant handling of confidential data; role-based access and report/data-level security practices

· Python for data wrangling /automation is preferred

· SQL Server Integration Services ( SSIS ) or other ETL tools are preferred

· Experience with accreditation/compliance reporting (E.g., IPEDS , Perkins, HLC ) and campus survey analytics is preferred

· Strong critical thinking and analytical problem-solving skills

· Excellent written and verbal communication; ability to translate technical findings for non-technical audiences

· Strong organization and time management; ability to manage multiple deadlines for stakeholders

· High attention to detail and data accuracy; commitment to documentation standards

· Collaborative, customer-service orientation ability to work independently and in teams

To provide best service to our external and internal customers, all positions at Lake Michigan College require regular and predicable on-site attendance as an essential job functions. Under certain circumstances, College may consider alternative work arrangements and will do so in compliance with and according to parameters outlined in College’s Flexible Scheduling and Remote Work Options policy.

Hiring Range:

Hiring Range: $63,190 - $75,892

Suppressed Instructions to Applicants:

Open Date:

Open Date: 08/18/2026

Closing Date:

Closing Date: 09/18/2026

Supplemental Questions

Required fields are indicated with an asterisk (*).

• * Do you have a Bachelor's degree or higher?
  • No Response
  • Yes
  • No
• * Do you have two or more years of experience in data analysis and institutional reporting?
  • Yes
  • No