Application Support Analyst

Nodak Insurance Company; Fargo (ND); On-site; USD 55,000 - 85,000; Full time

Job summary

Nodak Insurance Company seeks an Application Support Analyst to be the frontline contact for IT Applications, diagnosing issues, supporting end users, and handling data requests. You will triage problems, review logs, and coordinate fixes with senior developers.

You will work with RPG/CL/PHP/HTML code, SQL databases (DB2/MS SQL/MySQL), and Tableau data imports while maintaining SOX compliance and documenting resolutions for our knowledge base.

Qualifications

• Bachelor's or associate degree in computer science, information technology, or software engineering must be completed.
• Minimum two years of relevant work experience in application support or IT.
• Strong programming knowledge in ILE RPG, RPG/Free, CL, PHP, and HTML.
• Experience with relational databases (DB2, MS SQL, MySQL) and writing complex queries.

Responsibilities

• Serve as the first point of contact for internal users reporting issues and triage accordingly.
• Diagnose and resolve program errors by reviewing logs and reproducing issues.
• Troubleshoot and apply fixes to RPG/CL/PHP/SQL code and coordinate with developers.
• Provide timely status updates and clear communications to users and partners.
• Handle data requests including ad hoc extracts, reports, and data quality investigations.
• Query and validate data in DB2/MS SQL/MySQL, and perform Tableau data imports monthly.
• Document issues, resolutions, and recurring problems to build a knowledge base.
• Collaborate with application development team to escalate complex issues and improve programs.
• Assist with SOX compliance listings, code samples, and audit support as needed.

Skills

ILE RPG

RPG/Free

CL

PHP

HTML

SQL

Communication skills

Education

Bachelor's or Associate degree in Computer Science / IT / Software Engineering

Tools

DB2

MS SQL

MySQL

Tableau

IBM application development software

ETL concepts

Job description

Summary: We are seeking a highly skilled Application Support Analyst to serve as an application support point of contact for programming and application support within our IT Applications team. This role will diagnose and resolve reported program issues, provide technical assistance to end users and IT staff, and handle data-related requests from business partners, including ad hoc data extracts, reporting needs, and data quality investigations.Essential Duties and Responsibilities include the following. Other duties may be assigned.Serve as the first point of contact (Application support) for internal users reporting programming, application, or system issues, triaging problems and escalating to senior staff as needed.Diagnose reported program errors by reviewing job logs, tracing program logic, and reproducing issues to identify root cause.Troubleshoot and debug existing RPG/RPGLE, CL, PHP, and SQL programs, applying fixes or coordinating corrections with senior developers.Provide technical assistance and clear, timely communication to end users and business partners regarding the status and resolution of reported issues.Maintain and support existing applications, including monitoring scheduled jobs and interfaces, and applying minor code changes to resolve production issues.Handle data-related requests from business partners, including ad-hoc data extracts, reporting needs, and data quality investigations.Work with DB2, MS SQL, and other relational databases to query, maintain, and validate data used to fulfill support tickets and data requests.Maintain and perform Tableau data imports on a monthly basis.Document reported issues, resolutions, and recurring problems to build a knowledge base and improve future troubleshooting efficiency.Write and maintain documentation to describe program development, logic, coding, testing, changes, and corrections.Collaborate with the application development team to escalate complex issues and to conceptualize and enhance existing programs and applications.Ensure compliance with internal standards and external regulations (e.g., SOX), including providing SOX compliance listings, code listings, and samples as requested for audit purposes.Essential Competencies and SkillsAble to communicate effectively with non-technical staff and with members of interdisciplinary teams.Able to work both independently and in a team-oriented, collaborative environment.Highly self-motivated and directed.Strong understanding of coding methods and best practices.Flexible and adaptable in regard to learning and understanding new technologies.Education, Work Experience, and CertificationsBachelor's or associate degree in the field of computer science, information technology, or software engineering, plus two years of relevant work experience.Proficient in a variety of programming languages, including ILE RPG, RPG/Free, CL, PHP, and HTML.Strong relational database experience with MS SQL, DB2, and MySQL, including writing complex queries, stored procedures, and performance tuning. Experience with data warehousing concepts, ETL processes, and data modeling is strongly preferred.Knowledge of various IBM application development software.Preferred knowledge in the insurance industry is preferred.Physical RequirementsAble to work in a typical office setting where the employee may occasionally lift and/or move up to 10 pounds.The noise level in the work environment is usually moderate.Occasional travel required (< 10%).Work EnvironmentThe work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.Nodak Insurance Company complies fully with all federal, state, and local employment laws and shall provide equal employment and advancement opportunities for all persons regardless of race, color, creed, religion, national origin, sex, sexual orientation, age, the presence of any mental or physical disability, status with regard to public assistance or marriage, or any other category protected by local, state or federal law.