Jobs
>
Anchorage

    Database Analyst I-IV - Anchorage, United States - Alaska Housing Finance Corporation

    Alaska Housing Finance Corporation
    Alaska Housing Finance Corporation Anchorage, United States

    1 day ago

    Default job background
    Description


    Corporate Values: Integrity, Respectful, Leadership, Sustainable

    Position Summary: Under supervision and direction of the Infrastructure & Development Officer, the Database Analyst I-IV designs, develops, troubleshoots & supports DMBS activities across a variety of AHFC applications.

    Reports to: Infrastructure & Development Officer

    OVERVIEW

    This is a non-exempt, technical position with no supervisory or management responsibilities. This position has telework options.

    SUPERVISION RECEIVED AND EXERCISED: Exempt, non-supervisory position.

    Examples of Duties

    1. Support, optimize, secure & analyze problems with DBMS schema that may be part of a vendor supplied or in-house application stack.
    2. Develop methods for secure data exchange between different DBMS that may be part of a vendor supplied or in-house application stack.
    3. Develop DBMS schema that follow modern design principles & are implemented using secure, flexible & scalable methodologies.
    4. Develop new DBMS schema to replace legacy as needed.
    5. Develop & maintain DBMS physical structure and functional capabilities, database security, data back-up, and recovery specifications.
    6. Develop & maintain a consistent, high quality, customer focused approach when interacting with AHFC's business partners, clients & customers; other AHFC departments.
    7. Develop working knowledge of AHFC business practices & processes as well as understanding its goals as a corporation.
    8. Performs workflow analysis, process mapping, documentation, and workflow implementation.
    9. Other duties as required.
    Knowledge, Skills and Abilities (KSAs)

    Knowledge:
    1. Modern DBMS integration patterns that allow disparate applications (vendor supplied & in-house) to exchange data in a secure & efficient manner.
    2. Modern DBMS design patterns that focus on rapid development, but still ensure separation between application & database context, in relation to data access.
    3. Modern DMBS design patterns that facilitate high availability.
    4. Modern DBMS design patterns that facilitate "Continuous Delivery" development pipelines.
    5. Understanding of modern trends in technology such as virtualization of servers, networking and storage.
    6. Understanding of modern software development process lifecycles, such as AGILE, as well as using UML to describe overall design of a system or process.
    7. Analysis using unit & regression methods.
    8. ITIL & ITSM principles and best practices.
    Skills:
    1. Understand & use T-SQL, XML, OLEDB, and ODBC.
    2. Understand & use Microsoft SQL Server Management Studio & Microsoft Visual Studio.
    3. Understand & use business intelligence components and reporting platforms such as Microsoft SSRS, Power BI and Tableau Server/Desktop.
    4. Basic systems administration capabilities on modern operating systems.
    5. Storage and versioning of DBMS schema via Git.
    6. Microsoft Office suite applications including Word, Excel, Access, Outlook and Visio.
    Abilities:
    1. 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.
    2. Thrive in an environment where peer review is used to determine viability of a solution or process.
    3. Perform algorithm analysis against a business process or auditing requirement in search of rational efficiencies.
    4. Maintain documentation for a solution or process that is in sync with the needs of management, team members & end users.
    5. Effectively & consistently use an issue tracking system while organizing and prioritizing a constantly changing workload. Must be able to work with minimal supervision and scope(s) that are sometimes fluid. Must be able to function with a high degree of independence within levels of delegated authority.
    6. Use independent judgment in the research and recommendation of application design decisions before making appropriate recommendations to management, team members and end users.
    7. 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.
    8. Read & understand written material, interpret & apply rules. Must be able to write clearly and prepare documents as required by management, team members & end users.
    9. Continually learn, adapt, and apply new technology skills to stay current with emerging or existing IT archetypes.
    10. Work as needed. Long hours and/or weekend work may be required as necessary to support department goals and objectives. Must be able to travel as needed.
    Minimum Requirements

    Minimum Qualifications:

    Minimum Educational Qualifications and Previous Employment Experience

    1. High school diploma required.

    2. Degree requirements:

    Database Analyst I / II:

    Associate's degree in Computer Science, Information Technology or closely related field.

    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:

    a. Qualifying work experience may be substituted for required educational requirements on a year for year basis at the discretion of the hiring authority.

    b. International degrees can be evaluated at the discretion of the hiring authority.

    3. Experience:

    a. The 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.

    b. The 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.

    c. The 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.

    d. The 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.

    4. Completion of formal continuing education and or professional technical certifications relevant to the KSAs for this job description within the last four (4) years.

    5. Provide valid Alaska driver's license and show proof of driving record in good standing from DMV when requested.

    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, DOE) (26 pay periods). Excellent benefits package.

    APPLICATION MUST BE ACCEPTED UNTIL POSITION IS FILLED

    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
  • NES Fircroft

    Data Analyst IV

    2 weeks ago

    NES Fircroft Anchorage, Alaska, United States Freelance

    · • Develop, test, and manage data pipelines · • Collect, explore, validate, and condition data · • Collaborate with business subject matter experts and data scientists to create data sets and engineer features for analytical models · • Productionize and operationalize analytica ...

  • Alaska Housing Finance Corporation

    IT Operations Analyst I

    6 days ago

    Alaska Housing Finance Corporation Anchorage, United States

    · Corporate Values: Integrity, Respectful, Leadership, Sustainable · Position Summary: This position is responsible for monitoring and maintaining a variety of IT systems within multiple data centers. · Reports to: IT Operations Officer · OVERVIEW · Work directly with users, ...

  • SCF

    Compliance Analyst I, II

    6 days ago

    SCF Anchorage, United States

    The Southcentral Foundation (SCF) Compliance Analyst is responsible for supporting the Compliance department by assisting the Senior Compliance Analysts and Senior Compliance Managers in the ongoing implementation, maintenance, and advancement of the organization's corporate comp ...

  • Southcentral Foundation

    Compliance Analyst I, II

    6 days ago

    Southcentral Foundation Anchorage, United States

    The Southcentral Foundation (SCF) Compliance Analyst is responsible for supporting the Compliance department by assisting the Senior Compliance Analysts and Senior Compliance Managers in the ongoing implementation, maintenance, and advancement of the organization's corporate comp ...

  • Cook Inlet Tribal Council Inc

    Eligibility Technician

    3 days ago

    Cook Inlet Tribal Council Inc Anchorage, United States

    Job Description · Job DescriptionCOOK INLET TRIBAL COUNCIL, INC. · JOB DESCRIPTION · Job Title: Eligibility Technician I, II, III, IV · Department: Employment and Training Services Department (ETSD) · Reports To: Eligibility Supervisor/Eligibility Manager · Supervises: None · FLS ...

  • Saxon Ai

    SAP Cutover Lead

    1 week ago

    Saxon Ai Anchorage, United States

    SAP Cutover Lead - ERP Functional Analyst IV · Location: Anchorage, AK (Local Only) · Duration: 12 months · Overview: · The cutover lead is responsible for planning, coordinating, and executing the cutover activities for the ECC to S4/HANA SAP software upgrade project. The c ...

  • Southcentral Foundation

    Health Information Specialist I, II

    1 week ago

    Southcentral Foundation Anchorage, United States

    The Southcentral Foundation (SCF) Health Information Specialist position is responsible for a variety of tasks in health information management such as processing electronic and paper health information for the release of information; data analysis to ensure completeness of recor ...

  • State of Alaska

    Infrastructure Administrator I

    4 days ago

    State of Alaska Anchorage, United States

    Salary: · $66,640.02 Annually · Location : · Anchorage, AK · Job Type: · Full Time · Job Number: · Job # · Department: · Alaska Housing Finance Corporation · Opening Date: · 03/08/2024 · Position Open To: · All Applicants · Bargaining Unit: · Excluded · Range: · ...

  • Alaska Housing Finance Corporation

    Infrastructure Administrator I

    6 days ago

    Alaska Housing Finance Corporation Anchorage, United States

    · Corporate Values: Integrity, Respectful, Leadership, Sustainable · Alaska Housing Finance Corporation · IS INFRASTRUCTURE ADMINISTRATOR I-IV (DOE) · ANCHORAGE/JOB # PCN 077 · Position Summary: Designs, develops, troubleshoots & deploys the corporation's enterprise computing i ...

  • Municipality of Anchorage

    MANAGER OF ENGINEERING

    1 week ago

    Municipality of Anchorage Anchorage, United States

    MANAGER OF ENGINEERING & PLANNING (Civil Engineer IV) - Range 18 / NON · Print ) · Apply · MANAGER OF ENGINEERING & PLANNING (Civil Engineer IV) - Range 18 / NON · Salary · $94, $120,952.00 Annually · Location · Anchorage, AK · Job Type · Regular · Job Number · Department · Solid ...

  • Municipality of Anchorage (AK)

    EXECUTIVE ADMINISTRATIVE ASSISTANT

    4 days ago

    Municipality of Anchorage (AK) Anchorage, United States

    Open to the general public and any current Municipal employee. · This is an Executive position and the incumbent serves at the pleasure of the Municipal Clerk. · DEPARTMENT: Municipal Clerks Office/Assembly · HOURS OF WORK: Monday through Friday; 8:00 a.m. to 5:00 p.m. (periodica ...

  • Generis Tek Inc

    AK - CT Tech - Klawock

    6 days ago

    Generis Tek Inc Anchorage, United States

    Please Contact: To discuss this amazing opportunity, reach out to our Talent Acquisition Specialist Taher Bhiwandiwalaat email address can be reached on # · We have Permanent role for CT Technologist for our client at Klawokc AK. Please let me know if you or any of your friend ...

  • Coats

    Field Service Technician

    21 hours ago

    Coats Anchorage, United States

    Job Description · Job DescriptionINTRODUCTION and WHAT YOU WILL DO (Job Responsibilities) · I. Purpose of Position · As a Field Service Technician, you will specialize in the installation, training, and basic repair of Coats, BaseLineTM and Ammco aftermarket tire and wheel servic ...

  • Municipality of Anchorage

    MANAGER OF ENGINEERING

    6 days ago

    Municipality of Anchorage Anchorage, United States

    Open to the general public and any current Municipal employee. · This is a non-represented position (no union affiliation) and is subject to the provisions of the Personnel Rules of the Municipality of Anchorage. · DEPARTMENT: · Solid Waste Services · HOURS OF WORK: · Hours V ...

  • Municipality of Anchorage

    SYSTEMS TECHNICAL ARCHITECT

    2 days ago

    Municipality of Anchorage Anchorage, United States

    SYSTEMS TECHNICAL ARCHITECT (Sr. Systems Analyst) - Range 17 / NON · Print ) · Apply · SYSTEMS TECHNICAL ARCHITECT (Sr. Systems Analyst) - Range 17 / NON · Salary · $86, $109,699.20 Annually · Location · Anchorage, AK · Job Type · Regular · Job Number · Department · Information T ...

  • Municipality of Anchorage

    web system analyst

    6 days ago

    Municipality of Anchorage Anchorage, United States

    Open to the general public and any current Municipal employee. · This is a non-represented position (no union affiliation) and is subject to the current provisions of the Personnel Rules of the Municipality of Anchorage. · DEPARTMENT · : · Information Technology · HOURS OF W ...

  • Internal Revenue Service

    Management and Program Analyst

    1 day ago

    Internal Revenue Service Anchorage, United States

    Summary · Eligibilities being considered and other IMPORTANT information. · WHERE CAN I FIND OUT MORE ABOUT OTHER IRS CAREERS? Visit us on the web at Duties · WHAT IS THE INFORMATION TECHNOLOGY (IT) DIVISION? · A description of the business units can be found at: · Vacanci ...

  • City of Valdez, AK

    Summer Fun Camp Director

    1 week ago

    City of Valdez, AK Anchorage, United States

    Salary: $ $25.08 Hourly · Location : 414 W. Hanagita, AK · Job Type: Temporary · Job Number: T24.07 · Department: Parks & Recreation · Opening Date: 03/19/2024 · The City of Valdez Parks and Recreation is gearing up for SUMMER · We are hiring a Day Camp Director to help co ...

  • Internal Revenue Service

    Tax Analyst

    2 days ago

    Internal Revenue Service Anchorage, United States

    Summary · Eligibilities being considered and other IMPORTANT information. · WHERE CAN I FIND OUT MORE ABOUT OTHER IRS CAREERS? Visit us on the web at Duties · WHAT IS THE CHIEF FINANCIAL OFFICER (CFO) DIVISION? · A description of the business units can be found at: · Vacan ...

  • Municipality of Anchorage

    CAPITAL PROGRAM MANAGER

    1 week ago

    Municipality of Anchorage Anchorage, United States

    CAPITAL PROGRAM MANAGER (Civil Engineer IV) - Range 18 / NON · Print ) · Apply · CAPITAL PROGRAM MANAGER (Civil Engineer IV) - Range 18 / NON · Salary · $94, $120,952.00 Annually · Location · 3000 Arctic Blvd., AK · Job Type · Regular / Full Time · Job Number · Department · Ancho ...