Database Analyst I-IV (DOE)

Salary: $2,392.94 - $3,245.27 Biweekly
Location : Anchorage, AK
Job Type: Full Time
Remote Employment: Flexible/Hybrid
Job Number: Job#
Department: Alaska Housing Finance Corporation
Opening Date: 07/28/2023
Position Open To: All Applicants
Bargaining Unit: Excluded
Range: 18-21
Job Description
Corporate Values : Integrity, Respectful, Leadership, Sustainable
Alaska Housing Finance Corporation
DATABASE ANALYST I-IV (DOE)
ANCHORAGE/Job #PCN 199
To apply for this job and all jobs, please go to AHFC website linked below.
Summary:
Under supervision and direction of the Infrastructure & Development Officer, the Programmer & Database Analyst I-IV designs, develops, troubleshoots & supports activities across the entire Systems Development Life Cycle (SDLC) for a variety of AHFC applications.
This is a non-exempt, technical position with no supervisory or management responsibilities.
Telework options are available for this position.
Reports to: IS INFRASTRUCTURE & DEVELOPMENT OFFICER
Examples of Duties

• Develop applications that follow modern design principles and are implemented using secure, flexible & scalable methodologies, promote a streamlined, collaborative environment & use efficient work flows while keeping focus on a positive user experience.
• Develop databases that follow modern design principles & are implemented using secure, flexible & scalable methodologies. Support, optimize, secure & analyze problems with databases that may be part of a vendor supplied or in-house application stack.
• Develop secure & scalable applications to replace legacy applications as needed.
• Develop secure data exchange interfaces between applications inside & outside the AHFC environment using modern application design principles.
• Develop & maintain a consistent, high quality, customer focused approach when interacting with AHFC's business partners, clients, customers and other AHFC departments.
• Develop working knowledge of AHFC business practices & processes as well as understanding its goals as a corporation.
• Performs workflow analysis, process mapping, documentation, and workflow implementation.
• Other duties as required.

Knowledge, Skills and Abilities (KSAs)
Knowledge:

• Modern application design technologies & trends, with focus on secure application development & efficient code re-use.
• Modern design patterns that focus on rapid development, but still ensure separation between application & database context, in relation to data access.
• Modern database integration patterns that allow disparate applications (vendor supplied & in-house) to exchange data in a secure & efficient manner.
• Modern design patterns that facilitate version control, "Continuous Delivery" development pipelines and high availability;
• Different SDLC's, such as AGILE, as well as using UML to describe overall design of a system or process.
• N-tier designs using object oriented models.
• Analysis using unit, regression & fuzzing methods.
• Mainstream trends in technology such as virtualization of servers, networking and storage.
• ITIL & ITSM principles and best practices.

Skills:

• Understand and use object oriented software design with primary focus on web applications using Visual Studio and Visual Studio Code tooling.
• Design application solutions using .Net, C#, Angular, TypeScript, JavaScript, AJAX, SOAP, JSON, etc.
• Understand & use Microsoft SSMS, SSRS, SSIS as well as Tableau Server and Desktop.
• Design database solutions using T-SQL, ODBC, etc.

Abilities:

• Understand, identify, and plan for the business process impact of planned or existing system changes while ensuring that new technical requirements are properly integrated with business processes.
• Thrive in an environment where peer review is used to determine viability of a solution or process.
• Perform algorithm analysis against a business process or auditing requirement in search of rational efficiencies.
• Maintain documentation for a solution or process that is in sync with the needs of management, team members & end users.
• Effectively and consistently use an issue tracking system while organizing and prioritizing a constantly changing workload. Must be able to work with minimal supervision and continual interruption. Must be able to function with a high degree of independence within levels of delegated authority.
• Use independent judgment in the research and recommendation of application design decisions before making appropriate recommendations to management, team members and end users.
• Establish and maintain a good working relationship with AHFC personnel, contractors, customers, consultants, suppliers and vendors. Interpersonal skills will be utilized on a daily basis through interaction with a diverse cross-section of people and organizations.
• Read & understand written material, interpret & apply rules. Must be able to write clearly and prepare documents as required by management, team members & end users.
• Continually learn, adapt, and apply new technology skills to stay current with emerging or existing IT archetypes.
• Work as needed.

Maintains the integrity, availability, security, and efficiency of databases. Resolves complex and often conflicting agency requirements.
Minimum Qualifications
Minimum Qualifications:

• High school diploma required.
  
• Degree requirements:

Programmer & Database Analyst I / II:
Associate's degree in Computer Science, Information Technology or closely related field.
Programmer & Database Analyst III / IV:
Bachelor's degree in Computer Science, Information Technology or closely related field.
Degree must be from an institution accredited by one of the six regional accreditation boards and or the AACSB:
MSA - Middle States Association
NASC - Northwest Association of Schools & Colleges
NCA - North Central Association of Colleges & Schools
NEASC - New England Association of Schools & Colleges
SACS - Southern Association of Colleges & Schools
WASC - Western Association of Schools & Colleges
AACSB- Association to Advance Collegiate Schools of Business
Substitutions:

• Qualifying work experience may be substituted for required educational requirements on a year for year basis at the discretion of the hiring authority.
  
• International degrees can be evaluated at the discretion of the hiring authority.
  Experience:
  • The Programmer & Database Analyst I position requires at least one (1) year full-time (35+ hr/week) work experience consistent with the KSAs of this job description within the last two (2) years. Recent college graduates with a degree in Computer Science, Information Technology or closely related field will be considered on a case-by-case basis.
    
  • The Programmer & Database Analyst II position requires at least two (2) years full-time (35+ hr/week) work experience consistent with the KSAs of this job description within the last four (4) years.
    
  • The Programmer & Database Analyst III position requires at least four (4) years full-time (35+ hr/week) work experience consistent with the KSAs of this job description within the last six (6) years.
    
  • The Programmer & Database Analyst IV position requires at least six (6) years full-time (35+ hr/week) work experience consistent with the KSAs of this job description within the last eight (8) years.

Insurance Benefits

• Health Plan - Medical, Vision, Prescription, and Dental
• Employee Assistance Program/Wellness
• Life Insurance - Basic Life and AD&D

Optional Insurance Benefits

• Group-based insurance premiums - Optional life, Long-term, and short-term disability
• Voluntary Accident, Hospital, and Critical Illness
• Flexible spending accounts for tax savings on eligible health care of dependent care expenses

Retirement Benefits

• Membership in the Public Employees Retirement System (PERS), Employee and Employer contribution
• Option to enroll in AHFC Deferred Compensation Program

Paid Leave & Other Benefits

• Personal Leave with an accrual rate increase based on time served
• Twelve paid holidays a year
• Health Club reimbursement Plan
• Education Reimbursement

This is a level 18/19/20/21 (DOE) position with an annual salary starting at $ 62,216.53 (DOE) (26 pay periods). Excellent benefits package.
APPLICATION MUST BE ACCEPTED UNTIL POSITION IS FILLED
DO NOT APPLY AT WORKPLACE ALASKA
AHFC provides employment opportunities to low and very-low income persons, in compliance with Section 3 of the HUD Act of 1968. Public Housing Residents are encouraged to apply.
EQUAL OPPORTUNITY EMPLOYER
N/a