Programmer Analyst - Information and Technology Services
ESSENTIAL JOB DUTIES:
1. Meets with users to determine functional requirements and provides computer software assessments based on existing and planned system configurations. Works with users to ensure satisfaction with applications.
2. Based on functional specifications, designs, develops, tests, and supports user applications and programs and may present output. This may involve using a variety of basic interfaces and programming languages, such as MS Office (including Access, VISIO, MS Project), SQL DDL, SQL DML, SQL DCL, SQL Server, Oracle, PL/SQL, T-SQL, TOAD, SSMS, Visual Basic, HTML, Java-based applications, Paradox, etc. Creates, modifies, and maintains databases, forms, reports, queries, and tables, SAS Language, SAS Stat, as well as a variety of data encryption software.
3. Participates in preparation of both technical and end-user documentation. Prepares detailed specifications from which programs will be written and writes the programs.
4. Develops installation and maintenance procedures to ensure system security and data integrity. Maintains operating system baselines and upgrades required to support databases and applications.
5. Works closely with staff in support of reporting needs. Designs and executes customized reports and creates the analysis files required for the analysis. Identifies and creates ad-hoc files that can be merged into a self-service system.
6. Provides training, technical support, and direction to users of critical systems. Performs troubleshooting and problem-solving.
7. Performs system administration for web, database, and server activities. Installs, configures, and maintains hardware and software.
8. Liaises with Information Technology Services (ITS) staff for network, hardware, software, and related issues.
9. Remains current on information technology standards. Keeps abreast of new software, data warehousing, data analysis, and information technology trends. Participates in technology assessment in the selection and recommendation of appropriate software technologies. Provides advice and guidance on products and new ways of applying technology to the work of the organization.
10. Monitors vendor software availability and reports outages and system failures, where applicable.
NONESSENTIAL JOB DUTIES
• Related duties and special projects as assigned.
Minimum Education/Training Requirements: Bachelor's Degree in Computer Science or related field, or equivalent knowledge.
Minimum Experience: Two years of related professional experience.
Physical Capabilities: Ability to work at a computer for extended periods of time.
Required Licenses, Certification or Registration: None.
Supervisory Responsibilities/Controls: Reports to Manager. Sets objectives with supervisor.
Work Environment: Office environment with occasional travel between National Academies' facilities and to off-site locations.
Any qualification to be considered equivalent, in lieu of stated minimum, requires the prior approval of the Office of Human Resources.
The above statements are intended to describe the general nature and level of work performed by employees assigned to this job. They are not intended to be an exhaustive list of all responsibilities, duties and skills required of personnel so classified. Some functions in this description may be specific to a particular unit of the National Academies and not applicable to other units.