JOB TITLE Software Systems Analyst

Location Primarily Bangor, MI with ability to work some days in Kalamazoo, MI.

DEPARTMENT Information Technology

STATUS Full time

BENEFITS First day benefits (PTO, Medical, Dental, Vision)

JOB SUMMARY

The Computer System Analyst’s primary focus will be on the ERP system and database analysis, administration in Microsoft SQL Server and Business Intelligence analytics. This role will also provide technical analysis, design, installation, maintenance, customization, and modification of broad/complex computer systems.

RESPONSIBILITIES

• Maintain and modify complex systems and/or design and develop integrations.
• Assist users in formulating system requirements; analyze resulting user proposals and conduct feasibility studies.
• Recommend best approach, advise on alternatives and implications of new or altered business processes within the ERP system and other systems.
• Perform problem analysis to resolve system or application issues.
• Provide staff and users with assistance, including training, to solve computer related problems, such as malfunctions and program problems.
• Create new and maintain ERP customizations.
• Create/modify SQL queries for ad hoc data requests.
• Use object-oriented programming languages to develop/customize client and server applications, processes, and Internet technology.
• Develop scalable and maintainable Business Intelligence applications to meet business objectives.
• Provides backup for other IT staff as required.
• Perform all other duties as 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, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education and/or Experience

• Bachelor degree from an accredited technical school with emphasis on software design, or equivalent experience. Applicable degrees would be in the following curriculums: Software Engineering, Computer Engineering, Information Systems or Information Technology.
• 1 year related work experience.
• 1 year experience with Microsoft SQL Server Database and SQL querying language.

Skills, Talents and/or Characteristics

• Critical thinking
• Communication
• Knowledge of object-oriented programming language(s) (C#, C++, or JAVA)
• Knowledge of ERP systems a plus (preferably Epicor)
• Knowledge or experience writing reports in SSRS a plus
• Knowledge or experience creating BI visualizations a plus (preferably Power BI)

Conditions/Special Requirements

Work is performed in an office environment, regular exposure to electrical, mechanical, and electronic equipment. Requires the need to be continually aware of changing events, situations, and technologies and to upgrade skills accordingly. Interruptions and distractions, plus the need to shift attention occur on a regular basis. Learned physical skill is required for keyboarding and use of peripheral equipment. Will perform some work outside of normal working hours.

Physical Demands
The physical demands described here are representative of those that must be met by and employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to talk or hear. The employee is frequently required to stand; walk; use hands to finger, handle or feel; and reach with hands and arms. The employee is occasionally required to sit; climb or balance; and stoop, kneel, crouch or crawl. The employee must frequently lift and move up to 25 pounds and occasionally lift and move up to 50 pounds.