> Markdown version of [/jobs/ext/4177431-enterprise-applications-data-automation-analyst](https://www.wearedevelopers.com/jobs/ext/4177431-enterprise-applications-data-automation-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Enterprise Applications Data & Automation Analyst - **Company:** Macomb Community College - **Location:** Warren, MI, United States (Remote available) - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Data Analysis, Databases, System Configuration, Data Validation, Data Dictionary, Data Mapping, Data Structures, Relational Databases, Issue Tracking Systems, PostgreSQL, Microsoft Software, Power BI, SAP Business Suiteing, Student Information Systems, Software Engineering, SQL Databases, Systems Integration, Enterprise Software Applications, Microsoft Power Automate, Microsoft Copilot Studio, Information Technology, Data Analytics, Low-code, Data Management, Tools for Reporting - **Published:** October 29, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=f6f65522ca7f5ea5 ## About the Role Bachelor's degree in information technology, computer science, data analytics, business or management information systems, or related fields. An equivalent combination of relevant education, training, certifications, and progressively responsible work experience may be considered in place of the degree requirements., Experience supporting enterprise information systems and databases, including data analysis for reporting, integrations, interfaces, and extracts. Experience with reporting, dashboards, workflow automation, low-code tools, and SQL/PostgreSQL preferred. Higher education, Ellucian, and Microsoft technology experience preferred. Knowledge, Skills and Abilities Demonstrated knowledge of enterprise application data structures, relational databases, data mapping, reporting, analytics, and data validation. Ability to understand complex Colleague data relationships and translate functional requirements into accurate technical specifications. Ability and willingness to learn and support SAP Business Intelligence, Colleague Reporting and Operational Analytics, Ellucian Insights, Microsoft Power Automate, Power BI, Microsoft Copilot Studio, artificial intelligence tools, and similar technologies. Demonstrated analytical, troubleshooting, documentation, organizational, and project coordination skills. Ability to communicate technical information clearly to both technical and nontechnical audiences, manage multiple priorities, work independently and collaboratively, and provide responsive customer service. Must be willing to learn and support new software and technology environments as the College's computing environment changes. ## Description Designs, develops, maintains, and troubleshoots reporting, analytics, dashboard, and automation solutions supporting the College's enterprise information systems and data platforms, including Ellucian Colleague (Unidata database) and Ellucian Student (PostgreSQL database). Supports and develops reporting and analytics capabilities utilizing Ellucian Insights Reporting, Analytics, and Dashboards and other business intelligence technologies. Supports and develops automation solutions using Microsoft Power BI, Power Automate, Copilot Studio, and similar technologies., COLLEAGUE DATA ANALYSIS AND REPORTING * Analyzes the Ellucian Colleague data structure and locates the appropriate data elements, files, fields, relationships, calculated fields, and selection criteria needed for interfaces, reports, dashboards, data extracts, and business processes. * Works with functional offices, application developers, report developers, vendors, and institutional staff to translate business questions and requirements into accurate Colleague data definitions and technical specifications. * Validates data definitions and results to ensure that reports, interfaces, extracts, and dashboards are accurate, complete, secure, and consistent with institutional standards. * Designs, develops, tests, documents, and troubleshoots operational reports and analytics for the student information system. * Supports SAP Business Intelligence and Colleague Reporting and Operational Analytics while assisting the College transition to Ellucian Insights Dashboards and Reporting. * Develops and maintains Ellucian Insights dashboards, reports, datasets, filters, calculations, and related reporting content. * Facilitates data extractions and interface data mapping, verifies the appropriateness and correctness of results, and assists with resolving data discrepancies. * Maintains data dictionaries, report specifications, field mappings, technical documentation, and reusable data definitions for enterprise applications. * Provides technical and problem-solving assistance and training to analysts, programmers, report developers, and end users in the use and interpretation of Colleague data and reporting tools. Uses artificial intelligence (AI) and automation technologies to analyze data, streamline business processes, improve operational efficiency, and support the development of secure, effective enterprise solutions. Uses 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 which has responsibilities that include system configuration, monitoring, disaster/recovery, troubleshooting, upgrades and ongoing maintenance of enterprise applications. Performs system administration duties such as system configuration, monitoring, disaster/recovery, troubleshooting, upgrades and ongoing maintenance of enterprise applications. AUTOMATION TOOLS AND ENTERPRISE APPLICATION SUPPORT * Learns, evaluates, implements, supports, and troubleshoots automation tools used to improve College business processes and enterprise application services. * Creates and supports solutions using Microsoft Power Automate, Power BI, Microsoft Copilot Studio Agents, Ellucian Insights Dashboards and Reporting, and similar approved products. * Works with functional departments and Application Development staff to identify appropriate automation opportunities, define requirements, test solutions, and implement sustainable business processes. * Troubleshoots automation flows, dashboards, agents, connectors, data refreshes, permissions, and integrations; coordinates resolution with internal technical staff and vendors when needed. * Applies College governance, security, data, documentation, testing, change-control, and support standards to automation solutions and enterprise reporting products. * Creates technical playbooks, process documentation, user instructions, test plans, and support materials for reporting, security, and automation solutions. * Maintains current knowledge of Ellucian, Microsoft, artificial intelligence, reporting, automation, and enterprise application technologies and recommends practical ways for the College to use them. * Performs related duties as assigned., Job responsibilities may require work to be performed at all office/classroom sites, necessitating inter-building/campus travel. May be required to work on days and at times outside the normal schedule. The position is on site in Clinton Twp. MI 3 days a week, with remote working 2 days a week. Supervision SUPERVISION (received): Reports to IT Deliver Lead. SUPERVISION (given): May supervise full- and part-time employees as assigned.