Job Description: Campus Title: Senior Systems Analyst State Job Title: Staff Associate Department: Information and Instructional Technology Job Code: H5300 FLSA Status: Exempt Funding: 7115-0100 Bargaining Unit: APA Job Type: Full-Time, Permanent Timeframe: 52 Weeks Shift: Monday-Friday, 8:00 am - 4:30 pm Regular Days Off: Saturday and Sunday Supervision Received: The Senior Systems Analyst reports to the Associate Director of Enterprise Systems. Supervision Exercised: None Salary: \$70,000 to \$80,000 Annually General Statement of Duties: The Senior Systems Analyst is a key resource on the Enterprise Systems team, responsible for accurate data analysis and custom programming in support of the Westfield State University strategic goals and mission. Responsibilities include analysis, design, development, testing, implementation, and administration of enterprise applications. The Senior Systems Analyst can multi-task, prioritize, and manage their time effectively, working independently or at times as a member of a project team. Duties and Responsibilities: Duties include but not limited to: Essential: Possesses a thorough understanding of the PL/SQL language to define, query and manipulate data within an Oracle database. Develops and maintain SQL scripts to import, export, and/or repair data within the Ellucian Banner student information system. Coordinates to identify, define, develop, test, and maintain Oracle database scripts, views, triggers, functions, and packages to meet evolving business needs of the University. Analyze high-level technical issues presented by end-users and develop solutions to resolve them. Submits support cases with software vendors, and coordinates with University staff for case troubleshooting to resolution. Provides technical support for University supported reporting tools, including but not limited to, development of reports, dashboards, and datablocks in support of the needs of University departments. Assists end users with reporting processes. Maintains and develops scheduled processes in automation software platforms. Provides support and guidance as needed to OIT staff engaged in similar functions. Provides technical support to assist in ongoing efforts related to data governance. Works with IT staff to assist with management of virtual Linux servers. Actively responds when assigned cases from the OIT support desk online ticket system. Maintains clear, concise, and descriptive documentation on solutions offered and applications developed or modified. Supports all ongoing efforts to reinforce data security and integrity. Performs other duties as assigned. Requirements: Required Qualifications: Bachelor\'s Degree or relevant professional certification with 5 years of experience 5 years of experience in PL/SQL application programming Experience with data collection, analysis, and reporting Possess the ability to communicate effectively with the user community Strong analytical skills Preferred Qualifications: 3 years progressive experience with Ellucian Banner ERP or similar student information system 1-year of Higher Education experience Experience with report writing tools One or more years of experience with Linux including shell scripting