Applications Technician - Crystal Lake, United States - McHenry County College

Description

• Develop, maintain, and schedule SQLbased reports from the College's ERP system and reporting tools. Provide report creation, assistance, support, and training on the reporting solution. Ensure scheduled reports run timely
• Process and track requests for security access and roles within Colleague. Create position security classes and add/modify/remove security access per user requests or job changes. Complete annual audit of individual access
• Process and track requests for security access and groups within the College's reporting tool. Complete annual audit of individual access
• Manage security roles and end user access within SoftDocs
• Manage security roles and end user access within SharePoint
• Identify information security risks, compliance and institutional needs and design information security frameworks to ensure only appropriate security access is granted
• Manage and update databases using ERP tools, such as Data Orchestrator
• Coordinate and facilitate with data stakeholders across the College to analyze, develop, resolve, capture and document issues related to data access and ongoing data hygiene for information stored in the College's information systems
• Coordinate security efforts with enduser departments and IT staff throughout the system development life cycle on assigned projects
• Resolve issues related to production ERP and peripheral systems
• Review and analyze requests for enhancements to software systems and processes to determine the impact on existing operations and support
• Develop and support data interfaces between internal and external systems
• Work collaboratively with others (e.g. colleagues, stakeholders, vendors) to accomplish functions and responsibilitiesAssume additional duties as assigned by immediate supervisor

• Associate's degree from a regionally accredited institution in Computer Science, Business Administration, Management or related discipline

• Two years' experience with Microsoft or other SQL query languages in a database development environment
• Experience moving to cloud based/SaaS environments
• Exposure to working with AI solutions
• Experience in higher education systems development
• Experience with the Ellucian Colleague technology stack
• Knowledge of hierarchical and relational database processing concepts

• Ability to make decisions that govern the access and system privileges of staff members
• Working knowledge of information security design and best practice standards
• Proficient in Microsoft Office Suite
• Responsible, curious, selfdirected, service and detailoriented
• Ability to work with minimum supervision and direction
• Ability to communicate effectively with all members of the MCC community
• Ability to operate a keyboard, perform repetitive motions and sit for prolonged periods of time
• Ability to work in a dynamic environment that requires being sensitive to change and responsive to changing goals, needs, and priorities
• Ability to use critical thinking skills related to problem solving
• Ability to make decisions that impact how the department provides services and support to customers
• Commitment and respect for diversity, equity, inclusiveness and the MCC Behaviors of Excellence
• Commitment to the College mission, vision, values, and goals
• Ability to perform all of the essential functions, skills, and specifications of the position