Looking for a Programmer Analyst - Glendale, CA

ESSENTIAL DUTIES AND RESPONSIBILITIES:

The following duties and responsibilities are typical of those performed in this classification.

• Performs technical information systems analytical and programming duties; including analysis, development, coding, testing, and documentation of computer applications
• Researches and evaluates current business functions with new and existing information systems, including ERP systems.

• Develops design specifications for data structures, queries, reports, workflows, interfaces, and processes. 

• Designs and builds database structures, including tables and relationships between fields based on design specifications to ensure data integrity; develops and programs data-sharing interfaces between applications to maintain data integrity across systems; creates, maintains, and schedules processes, procedures, and triggers to update and manipulate data. 

• Tests systems, upgrades, and patches and creates test data; works with end-users to develop and implement test plans and scripts; reviews the results and makes appropriate revisions to eliminate errors and/or enhance system performance.

• Analyzes and troubleshoots information system and application problems; may recommend and assist in the implementation of user solutions for software applications. 

• Writes and maintains technical documentation detailing system workflows, data structures, interfaces, processes, procedures, forms, and reports; designs and builds forms, reports, views, and graphical user interfaces (GUIs) based on business needs and reporting requirements. 

• Maintains programs by reviewing audit logs, confirming regularly scheduled operations, and troubleshooting and correcting code as necessary.  

• Provides technical support and training to information technology support staff and end-users, resolving problems and advising on system and application operations and functionality.

• Compiles, creates, prepares, and submits periodic reports for users and management; extracts data from ERPs and other applications. 

• Participates in developing and implementing user software related to ERP systems and third-party applications. 

• Assists in ensuring data security.

• May provide work direction to lower-level employees, temporary employees, and/or student workers.  

• Performs other related duties as assigned.