Enterprise Apps Data & Automation Specialist

Macomb-Community-College; Clinton Charter Township (MI); On-site; USD 70,000 - 100,000; Full time

Job summary

Macomb Community College seeks a skilled data analyst to support enterprise information systems, focusing on Ellucian Colleague and related platforms. You will design, develop, and troubleshoot reports, dashboards, and automation solutions to enhance institutional business processes.

Responsibilities include data element validation, interfaces, and data dictionaries, with emphasis on security and accuracy. Proficiency with Ellucian, Microsoft BI tools, and SQL/PostgreSQL is highly desirable,

Qualifications

• Bachelor’s degree in information technology, computer science, data analytics, business or MIS (or related fields).
• Experience supporting enterprise information systems and databases, including data analysis for reporting, interfaces, and extracts.
• Experience with reporting, dashboards, workflow automation, low-code tools, and SQL/PostgreSQL preferred.

Responsibilities

• Analyzes the Ellucian Colleague data structure and locates data elements for interfaces, reports, dashboards, and business processes.
• Translates business requirements into Colleague data definitions and technical specifications with stakeholders.
• Validates data definitions and results to ensure accuracy and security across reports and dashboards.

Skills

Data analysis

Reporting

Automation

SQL/PostgreSQL

Low-code tools

Power BI

Education

Bachelor’s degree in IT / CS / data analytics / MIS

Tools

Ellucian Colleague

Ellucian Insights

Power Automate

Power BI

Copilot Studio

SQL/PostgreSQL

Job description

Macomb Community College seeks a skilled data analyst to support enterprise information systems, focusing on Ellucian Colleague and related platforms. You will design, develop, and troubleshoot reports, dashboards, and automation solutions to enhance institutional business processes.

Responsibilities include data element validation, interfaces, and data dictionaries, with emphasis on security and accuracy. Proficiency with Ellucian, Microsoft BI tools, and SQL/PostgreSQL is highly desirable,