Position Summary:
The Programmer Analyst is responsible for LCC application development, administering and configuring LCC Information Systems (ERP, CRM), and database management. This position works closely with Computer System administrators, LCC IT Helpdesk to provide user support and new feature development.

Duties and Responsibilities:

APPLICATION DEVELOPMENT
1. Business objectives
a. New applications developed with objective to increase organizational effectiveness, reduce labor time or increase data accuracy
b. Interoperability among LCC internal systems is maintained to minimize system downtime

2. Programming
Satisfactory performance is achieved when:
a. Programming code is effective and scalable
b. Programming code is well documented
c. Where applicable ORM model is applied
d. User manual is up-to-date and is easily understandable for users

3. Testing & updates
Satisfactory performance is achieved when:
a. Code is written based on development and testing standards
b. Application deployment process is in place
c. Relevant stakeholders are informed and trained

ADMINISTRATION OF INFORMATION MANAGEMENT SYSTEMS (TECHNICAL SIDE)
1. ERP system administration and security
Satisfactory performance is achieved when:
a. Security for user access is maintained
b. Known system or individual app security patches installed

2. Develop, maintain and document system integration processes
Satisfactory performance is achieved when:
a. Integration processes are represented in UML flow diagrams
b. Synchronization logging process is in place

3. Technical support and development of WEB applications including LCC website and Portal
a. Security for user access is maintained
b. Technical solutions provided to the business needs and users trained how to use

DATABASE MANAGEMENT
1. Maintain current knowledge of database design industry standards and promote database uniformity across all LCC Information Management System databases
a. Database structures are engineered to minimize data redundancy
b. Demonstrates working knowledge of database architecture

2. Identifying, designing and revising data warehousing environment
a. Demonstrates technical expertise on data storage structures, data mining, and data cleansing
b. Primary and secondary data is organized in a format to be readable for LCC decision makers

QUALIFICATIONS:
Education: BSc in Computer Science, Engineering
Experience: Four years of programming experience

Skills:
i. Python programming language (at least of four years of hands on experience)
ii. Windows Power Shell and Linux Shell programming
iii. PostgreSQL, MS SQL and MySQL database management
iv. Knowledge of data gathering, cleaning and transforming techniques
v. Hands on knowledge of Cloud architectures (database and app development)
vi. Understanding of data warehousing and ETL techniques
vii. Familiarity with WEB front-end technologies (like JavaScript, CSS, HTML5)

Nice to have:
viii. Familiarity with .NET programming languages