Programmer Analyst

NODAK INSURANCE COMPANY•Fargo, ND

1d•Onsite

About The Position

We are seeking a highly skilled Programmer Analyst with a strong data background to join our IT Applications team. This role will analyze requirements, design, develop, and test new applications, with a particular focus on handling data-related requests, modifying existing data structures to support new business requirements, and assessing current data workflows to improve time to market. They will also maintain and revise existing applications, and provide technical assistance to users as well as to others in IT. This position will develop applications and data solutions from approved requirements and specifications to drive the success of our business partners.

Requirements

Bachelor or associate degree in the field of computer science, information technology, or software engineering, plus two years relevant work experience.
Able 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 regards to learning and understanding new technologies
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.

Nice To Haves

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.

Responsibilities

Write and maintain documentation to describe program development, logic, coding, testing, changes, and corrections.
Provide programming support for various internal/external interfaces including SFTPs and APIs.
Effectively test developed programs for accuracy.
Troubleshoot and debug existing code and revise programs.
Work with DB2, MS SQL, and other relational databases to query, maintain, and optimize data structures, including support for data warehousing environments.
Provide technical assistance by responding to inquiries from others regarding errors, problems or questions about programs.
Handle data-related requests from business partners, including ad-hoc data extracts, reporting needs, and data quality investigations.
Modify current data structures, schemas, and warehouse models to accommodate new business requirements while maintaining data integrity and performance.
Assess current data workflows and processes to identify opportunities for automation, optimization, and improved time to market for data-driven initiatives.
Collaborate with product development and application team in conceptualizing and development of new software programs and applications and enhancing existing programs and applications.
Consistently write, translate, and develop new/existing applications according to specifications and SDLC methodologies.
Ensure compliance with internal standards and external regulations (e.g. SOX).
Provide support to less experienced programmers.