Programmer Analyst

Summary:
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.

Essential Duties and 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.

Education:

• Bachelor or associate degree in the field of computer science, information technology, or software engineering, plus two years relevant work experience.

Personal Attributes:

• 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

Knowledge and 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.

Supervisory Responsibilities:

• None.

Physical Requirements:

• Able 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 Environment:

• The 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.