Enterprise Applications Data & Automation Analyst

Macomb Community College•MCC - Center Campus, MI

About The Position

Provides enterprise application data analysis, reporting, and automation support for the Ellucian Colleague Student Information System and related College systems. Identifies, validates, and documents Colleague data elements used for reporting, interfaces, integrations, and institutional business processes. Designs, develops, maintains, and troubleshoots reporting, analytics, dashboard, and automation solutions supporting enterprise information systems and data platforms, including Ellucian Colleague (Unidata database) and Ellucian Student (PostgreSQL database). Supports and develops reporting and analytics capabilities using Ellucian Insights Reporting, Analytics, and Dashboards and other business intelligence technologies, as well as automation solutions using Microsoft Power BI, Power Automate, Copilot Studio, and similar technologies. The role works with functional offices, application developers, report developers, vendors, and institutional staff to translate business questions into accurate data definitions and technical specifications. It validates reporting results, supports enterprise application operations, documents and trains users, and applies College standards for security, governance, testing, change control, and ongoing support. The analyst also acts as a backup to the system administrator and performs enterprise application system administration duties.

Requirements

Bachelor's degree in information technology, computer science, data analytics, business or management information systems, or a related field; an equivalent combination of relevant education, training, certifications, and progressively responsible work experience may be considered instead.
Experience supporting enterprise information systems and databases, including data analysis for reporting, integrations, interfaces, and extracts.

Nice To Haves

Experience with reporting, dashboards, workflow automation, low-code tools, and SQL/PostgreSQL.
Higher education experience.
Ellucian experience.
Microsoft technology experience.

Responsibilities

Analyze Ellucian Colleague data structures and identify data elements, files, fields, relationships, calculated fields, and selection criteria needed for interfaces, reports, dashboards, extracts, and business processes.
Work with functional offices, application developers, report developers, vendors, and institutional staff to translate business questions and requirements into Colleague data definitions and technical specifications.
Validate data definitions and results to ensure reports, interfaces, extracts, and dashboards are accurate, complete, secure, and consistent with institutional standards.
Design, develop, test, document, and troubleshoot operational reports and analytics for the student information system.
Support SAP Business Intelligence and Colleague Reporting and Operational Analytics while assisting the College's transition to Ellucian Insights Dashboards and Reporting.
Develop and maintain Ellucian Insights dashboards, reports, datasets, filters, calculations, and related reporting content.
Facilitate data extractions and interface data mapping, verify results, and assist with resolving data discrepancies.
Maintain data dictionaries, report specifications, field mappings, technical documentation, and reusable data definitions for enterprise applications.
Provide technical and problem-solving assistance and training to analysts, programmers, report developers, and end users on Colleague data and reporting tools.
Use artificial intelligence and automation technologies to analyze data, streamline business processes, improve operational efficiency, and support secure enterprise solutions.
Use the College's IT service management and ticketing system to document, prioritize, track, communicate, and resolve service requests, security access requests, incidents, and application support issues.
Act as a backup to the system administrator and perform system administration duties, including system configuration, monitoring, disaster recovery, troubleshooting, upgrades, and ongoing enterprise application maintenance.
Learn, evaluate, implement, support, and troubleshoot automation tools that improve College business processes and enterprise application services.
Create and support solutions using Microsoft Power Automate, Power BI, Microsoft Copilot Studio Agents, Ellucian Insights Dashboards and Reporting, and similar approved products.
Collaborate with functional departments and Application Development staff to identify automation opportunities, define requirements, test solutions, and implement sustainable business processes.
Troubleshoot automation flows, dashboards, agents, connectors, data refreshes, permissions, and integrations, coordinating resolution with internal technical staff and vendors as needed.
Apply College governance, security, data, documentation, testing, change-control, and support standards to automation solutions and enterprise reporting products.
Create technical playbooks, process documentation, user instructions, test plans, and support materials for reporting, security, and automation solutions.
Maintain current knowledge of Ellucian, Microsoft, artificial intelligence, reporting, automation, and enterprise application technologies, and recommend practical uses for the College.
Perform related duties as assigned.