<p>Job Description:</p> <p>Campus Title: Senior Systems Analyst</p> <p>State Job Title: Staff Associate</p> <p>Department: Information and Instructional Technology</p> <p>Job Code: H5300</p> <p>FLSA Status: Exempt</p> <p>Funding: 7115-0100</p> <p>Bargaining Unit: APA</p> <p>Job Type: Full-Time, Permanent</p> <p>Timeframe: 52 Weeks</p> <p>Shift: Monday-Friday, 8:00 am - 4:30 pm</p> <p>Regular Days Off: Saturday and Sunday</p> <p>Supervision Received: The Senior Systems Analyst reports to the Associate Director of Enterprise Systems.</p> <p>Supervision Exercised: None</p> <p>Salary: $70,000 to $80,000 Annually</p> <p>General Statement of Duties:</p> <p>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.</p> <p>Duties and Responsibilities:</p> <p>Duties include but not limited to:</p> <p>Essential:</p> <ul> <li>Possesses a thorough understanding of the PL/SQL language to define, query and manipulate data within an Oracle database. </li><li>Develops and maintain SQL scripts to import, export, and/or repair data within the Ellucian Banner student information system. </li><li>Coordinates to identify, define, develop, test, and maintain Oracle database scripts, views, triggers, functions, and packages to meet evolving business needs of the University. </li><li>Analyze high-level technical issues presented by end-users and develop solutions to resolve them. </li><li>Submits support cases with software vendors, and coordinates with University staff for case troubleshooting to resolution. </li><li>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. </li><li>Assists end users with reporting processes. </li><li>Maintains and develops scheduled processes in automation software platforms. </li><li>Provides support and guidance as needed to OIT staff engaged in similar functions. </li><li>Provides technical support to assist in ongoing efforts related to data governance. </li><li>Works with IT staff to assist with management of virtual Linux servers. </li><li>Actively responds when assigned cases from the OIT support desk online ticket system. </li><li>Maintains clear, concise, and descriptive documentation on solutions offered and applications developed or modified. </li><li>Supports all ongoing efforts to reinforce data security and integrity. </li><li>Performs other duties as assigned. </li></ul> <p>Requirements:</p> <p>Required Qualifications:</p> <ul> <li>Bachelor's Degree or relevant professional certification with 5 years of experience </li><li>5 years of experience in PL/SQL application programming </li><li>Experience with data collection, analysis, and reporting </li><li>Possess the ability to communicate effectively with the user community </li><li>Strong analytical skills </li></ul> <p>Preferred Qualifications:</p> <ul> <li>3 years progressive experience with Ellucian Banner ERP or similar student information system </li><li>1-year of Higher Education experience </li><li>Experience with report writing tools </li><li>One or more years of experience with Linux including shell scripting </li></ul> <p>Additional Information:</p> <p>Salary:</p> <p>Salaries for current Westfield State University employees and individuals currently working for the state of Massachusetts must be calculated individually in accordance with collective bargaining agreements as well as state policies. State job specifications may be found on the Department of Higher Education's webpage.</p> <p>Employee Benefits:</p> <p>Benefits are an important component of an employee's total compensation package.</p> <ul> <li>Health Insurance: Westfield State offers a variety of HMO, POS, and PPO-type health insurance plans for eligible employees. Coverage is effective on the 1st of the month following the date of hire. Exceptions to employees hired on the 1st of the month, coverage is effective immediately. </li><li>Retirement: the MA State Employee Retirement System provides eligible employees with a retirement pension following a 10-year vesting period. In lieu of the retirement pension, eligible employees may select the Optional Retirement Plan with a maximum 5% employer matching contribution. </li><li>Tuition Waivers & Discounts: eligible employees, including spouses and dependent children, receive reduced tuition at MA state colleges, community colleges, and universities. </li><li>Paid Time Off: employees receive 12 paid holidays and generous vacation, personal, and sick leave benefits. </li><li>Additional information regarding employee benefits is available on the University's Benefits & Wellness webpage. </li></ul> <p>Disability Accommodations</p> <p>Westfield State University is committed to the full inclusion of individuals with disabilities and will ensure the availability of reasonable accommodations. If a reasonable accommodation is needed to participate in the job application or interview process, please contact Human Resources at (413) 572-8809 or visit us in the Horace Mann Building, 1st floor.</p> <p>Background Check</p> <p>Employment is contingent upon the successful completion and review of a background check. A criminal record will not automatically disqualify an applicant from consideration.</p> <p>Application Instructions:</p> <p>An on-line application is required. The successful candidate must submit an official transcript at the time of hire. Interested candidates should electronically attach the following documents:</p> <ul> <li>Resume </li><li>Cover Letter </li><li>Contact information for three references * </li><li>Copy of unofficial transcript of highest degree </li><li>Provide the contact information for reference providers in the reference section of the online application. </li></ul> <p>Deadline: The job posting will be open a minimum of ten days and, if needed, will remain open until finalists have been selected.</p> <p>NOTE: If you need assistance completing your application please contact our online Help Desk. The link to the help desk can be found at the top of the page via Contact Us.</p>