Application Systems Analyst

1. Design, implement, and analyze reports to determine the overall trends of the organization.
2. Develop and provide training, demonstrations, and regular communication to end-users.
3. Troubleshoot application, system, and data issues; diagnose root causes; implement corrective solutions; escalate complex issues.
4. Research emerging technologies, tools, and industry best practices to improve capabilities and development processes.
5. Collect, analyze, and synthesize data from multiple sources to support reporting, decision-making, and system performance evaluation.
6. Define, create, and build data warehouse architecture and data systems to optimize data access, consistency, accuracy, and capabilities.
7. Develop, test, analyze, and implement extract, transform, and load (ETL) processes in order to accurately and efficiently pull and organize data into a warehouse; define and document data integration strategies.
8. Test and verify the structure, accuracy, and quality of warehouse data.
9. Use third-party applications to append and manage data, ensuring the data warehouse remains accurate and up to date.
10. Discuss data projects with end users; assess and verify requirements and business needs to determine the appropriate specifications and the necessary systems needed to accomplish goals.
11. Resolve end-user data and report issues; troubleshoot data warehouse daily load jobs; verify results and communicate resolution/findings.
12. Develop data warehouse process models; create data dictionaries to provide thorough and clear definitions of data; map data to illustrate the flow between systems.

Other duties:

1. Develop end user training schedule and execute it, support learning systems group in designing. Create technical support documentation and keep it updated.
2. Follow guides and documentation to implement new software, update existing software, and to perform upgrades.
3. Serve as a responsible and professional staff member by participating in I.T. staff meetings and other functions (training of student workers, processing of timesheets, institutional activities, etc.); ensuring documentation, policies, and procedures are created and followed in-line with current standards and are properly maintained according to established procedures and forms.
4. Assist with ensuring the Confidentiality, Integrity, and Availability of ?personal information? by protecting against any potential threats or hazards to the security or integrity of such information including unauthorized access to, or use of, such information in a manner that creates a substantial security risk of misuse, theft, or fraud.

Key Competencies

• User support and stakeholder engagement
• Process and project management
• Report development and data analysis
• Data integrity, data modeling, and database management
• Information governance and quality assurance
• Troubleshooting and problem resolution
• Requirements gathering and business analysis
• Stakeholder communication and collaboration, This description is not intended to be all-inclusive. It is provided as a general statement of the nature and duties of the position. The incumbent may be asked to perform other assignments of a similar nature, or related to the effective operation of the department, or as a developmental experience, as assigned from time to time by the supervisor.

Education & Experience: Bachelor’s degree in Computer Science, Information Technology, Management Information Science, or a related area of study, or equivalent experience preferred. Minimum five years of experience (including academic coursework) in programming and analysis in Enterprise systems and databases along with web and mobile application development. Proficiency and good knowledge of wide range of software programs including Microsoft Office (Outlook, PowerPoint, Excel and Word), OneDrive, Windows Server, and SharePoint. Experience with administering, maintaining and querying server platforms of MS SQL. Experience and knowledge of various programming languages and technologies such as ASP.NET, C#, CSS, HTML, JavaScript, and PowerShell. Experience or knowledge with data integration using APIs, custom programs, scripting, SSMS, and 3rd party tools. Experience with Colleague ERP, Entrinsik Informer, and Slate a plus., * Strong customer service orientation and strong organizational and technical skills.

• Ability to interpret and evaluate client information needs.
• Ability to learn and assimilate new programming languages and databases.
• Access to a personal computer with Internet connectivity during off-hours.
• Highly self-motivated, self-directed, and keen attention to detail.
• Ability to deal with sensitive information with confidentiality and tact.
• Demonstrate professional and ethical conduct.
• Access to transportation and able to work outside of regular working hours as needed.
• Occasional lifting and transporting of equipment/paper products, bending, stooping, crawling, and reaching.