What are the responsibilities and job description for the Application Systems Analyst position at Saint Vincent College?
Position Title: Application Systems Analyst
Reports to: Director of Enterprise Application Services
Supervises: N/A
Primary function: Provide functional analysis and software/web application support to all users with priority focus on the college?s two main enterprise systems; Technolutions Slate (student recruitment CRM) and Ellucian Colleague (Student Information System). Duties include programming, database management, data integrity analysis, systems analysis, business analysis, and report creation and modifications. Administer the technical aspects of Slate while serving as a technical liaison between Admissions and other internal/external constituents. Finally, develop, test, troubleshoot, and maintain custom, third-party, web, and mobile applications.
Required Qualifications:
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.
Essential Duties:
- Design, implement, and analyze reports to determine the overall trends of the organization.
- Develop and provide training, demonstrations, and regular communication to end-users.
- Troubleshoot application, system, and data issues; diagnose root causes; implement corrective solutions; escalate complex issues.
- Research emerging technologies, tools, and industry best practices to improve capabilities and development processes.
- Collect, analyze, and synthesize data from multiple sources to support reporting, decision-making, and system performance evaluation.
- Define, create, and build data warehouse architecture and data systems to optimize data access, consistency, accuracy, and capabilities.
- 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.
- Test and verify the structure, accuracy, and quality of warehouse data.
- Use third-party applications to append and manage data, ensuring the data warehouse remains accurate and up to date.
- 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.
- Resolve end-user data and report issues; troubleshoot data warehouse daily load jobs; verify results and communicate resolution/findings.
- 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:
- Develop end user training schedule and execute it, support learning systems group in designing. Create technical support documentation and keep it updated.
- Follow guides and documentation to implement new software, update existing software, and to perform upgrades.
- 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.
- 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
Special challenges and environment:
- 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.
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.
All positions require the incumbent to be able to fully embrace the unique mission and identity of the College as a Catholic, Benedictine liberal arts and sciences institution. Saint Vincent College is committed to diversity and encourages applicants from all qualified candidates. Saint Vincent College is committed to building a diversified and competent population of faculty and staff, andencourages applications from women and minorities. Saint Vincent is an equal opportunity employer.
PLEASE NOTE: Background checks will be performed on all new hires. Employment is conditional upon satisfactory background checks and clearances.