Systems Analyst

Job Description

Summary:

The IT Systems Analyst ll is responsible for ensuring the reliable operation of the company’s software systems and providing analysis and design expertise. The successful candidate contributes to the success of the company by collaborating with technology and management teams to understand requirements and define standards for how data will be stored, consumed, integrated and managed across the organization. This individual will help design and develop business processes to automate and streamline operations. The role not only supports our existing implementations but also participates in the implementation and planning of new systems and projects.

Responsibilities:

  • Be the key expert in all aspects of the Company’s Sage ERP system and other database software supporting the Company’s operations
  • Develop written user documentation for key Sage system and other software business processes
  • Assist in new Sage implementations including training new users on Sage
  • Partner with Project Manager to coordinate new solution delivery with vendors and internal stakeholders as required
  • Design and administrate database technologies including Microsoft SQL and Access to ensure data integrity, system stability and availability
  • Create standard operating procedures for configuring, securing and monitoring Microsoft SQL Server and Sage environments
  • Work with finance and operational teams to support the analytical, building, testing and deployment tasks of our business intelligence (Microsoft Power BI) environment
  • Ability to create and automate SQL SSRS and Crystal reports delivery to key stakeholders
  • Gather, analyze and document business requirements to support the design and development of technology or process solutions
  • Provide input and guidance on software and solution selection and acquisition
  • Recommend solutions to improve new and existing database systems
  • Install and organize information systems to guarantee availability
  • Access database implementation procedures to ensure they comply with internal and external regulations
  • Design proactive solutions to monitor for data quality issues
  • Identify root cause of data quality issues in applications
  • Monitor database environments for performance bottlenecks
  • Assist with end user support across different systems
  • Other assigned duties assigned

Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.  The requirements listed below are representative of the knowledge, skills, and/or ability required.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

  • Bachelor’s Degree in Computer Science, Information Systems Management or Data Management
    • Experience may be substituted for education
  • 3-5 years’ experience as a system analyst, data engineer and/or dba
  • Sage ERP experience, preferred
  • Strong writing skills with prior experience documenting software and system processes
  • Highly analytical and able to absorb new software skills quickly
  • Experience with and strong understanding of databases such as Microsoft Access and SQL server
  • Strong proficiency in Microsoft Office applications and Power BI
  • Ability to work independently, prioritize and plan effectively
  • Work effectively in a team setting and collaborate/communicate with others

Reference Number: 5414