Job description

Job Description Corporate Values: Integrity, Respectful, Leadership, Sustainable Alaska Housing Finance Corporation DATABASE ANALYST I-IV (DOE) ANCHORAGE/Job #23-8166 PCN 199 To apply for this job and all jobs, please go to AHFC website linked below. https://www.ahfc.us/about-us/jobs/all-job-seekers Position 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 https://www.ahfc.us/about-us/jobs/all-job-seekers PLEASE 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

Requirements