What are the responsibilities and job description for the Database Analyst I-IV (DOE) position at State of Alaska?

Salary : $2,392.94 - $3,245.27 Biweekly

Location : Anchorage, AK

Job Type : Full Time

Remote Employment : Flexible / Hybrid

Job Number : Job#23-8166

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 #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

N / a

Salary : $62,217

Apply for this job

Receive alerts for other Database Analyst I-IV (DOE) job openings

Database Analyst I-IV (DOE)

What are the responsibilities and job description for the Database Analyst I-IV (DOE) position at State of Alaska?

What is the career path for a Database Analyst I-IV (DOE)?

Job openings at State of Alaska

Not the job you're looking for? Here are some other Database Analyst I-IV (DOE) jobs in the Juneau, AK area that may be a better fit.

We don't have any other Database Analyst I-IV (DOE) jobs in the Juneau, AK area right now.

AI Assistant is available now!