Senior Program Analyst

Summary

This position is located in the Veterans Benefits Administration (VBA), Office of Performance Analysis and Integrity (PA&I), which is organizationally aligned under the VBA, Chief of Staff. PA&I develops and maintains VBA's Enterprise Data Warehouse, publishes authoritative operating performance reports, adhoc data reports, data mines, and provides statistical evaluations of VBA activities to gain insight into the workload and operations that support VBA missions.

This job is open to

• Career transition (CTAP, ICTAP, RPL)
  
  Federal employees who meet the definition of a "surplus" or "displaced" employee.
• Internal to an agency
  
  Current federal employees of this agency.

Clarification from the agency

This vacancy announcement is open ONLY to current, permanent Veterans Benefits Administration (VBA) employees and current/former VA employees who are CTAP eligible.

Duties

The incumbent will serve as a Senior Program Analyst who reports to the Director or an Assistant Director of PA&I. The primary responsibility is to ensure appropriate, accurate, and efficient acquisition, evaluation, and maintenance of VBA data and the systems that collect them.

Specific duties include:

• Extract Transfer and Load (ETL)Ensures that VBA business line systems and processes can effectively and accurately extract and transfer data from an enterprise scale data warehouse (VBA's Enterprise Data Warehouse).
• Process lmprovement-Performs needs analyses, identifies opportunities for new or improved business process solutions, documents customer requirements for business intelligence tools and recommends solutions to VBA leadership that will lead to improved service to Veterans and their families.
• Assist in planning, coordination, and implementation of data marts and data architecture solutions supporting the Enterprise Data Warehouse Database internal and external partners.
• Architecting data warehousing reporting solutions from conception to delivery consisting of analysis, high level design, data modeling, ETL development, user interface development, integration and implementation using the appropriate tools, identify flaws and weaknesses in the composition and design of the database structures, queries and application code and web-based software.
• Evaluates work products including coding artifacts from EDW support contractors. Evaluates and reports on delivered contractor service work for VBA's Enterprise Data Warehouse and Bl reporting support systems.

Promotion Potential: None

Work Schedule: Full time, Monday through Friday, 8am-4:30pm

Compressed/Flexible: Available

Telework: Available

Virtual: This is not a virtual position

Position Description/PD#: Senior Program AnalystGS-0343-14; 30178-A

Financial Disclosure Report: Not Required

Requirements

Conditions of Employment

• You must be a U.S. Citizen to apply for this job
• Selective Service Registration is required for males born after 12/31/1959
• You may be required to serve a probationary period
• Subject to background/security investigation

Qualifications

To qualify for this position, applicants must meet all requirements by the closing date of this announcement:09/03/2024.

TIME-IN-GRADE REQUIREMENT: Applicants who are current Federal employees and have held a GS grade any time in the past 52 weeks must also meet time-in-grade requirements.

To verify your eligibility, you must submit a copy of your most recent Notification of Personnel Action, Standard Form 50 (SF-50). The grade may have been in any occupation, but must have been held in the Federal service. You must provide a copy of your most recent SF-50 that indicates proof of status, and shows Time in Grade (for example, you were a career or career-conditional employee) and identifies your position title, series, grade, step, salary, tenure, and type of service (Competitive or Excepted). If the most recent SF-50 has an effective date within the past year, it may not clearly demonstrate you possess one-year time-in-grade, as required by the announcement. In this instance, you must also submit your most recent promotion or within-grade increase in addition to your recent SF-50. If you previously held a higher grade, you must also submit any SF-50 showing that grade. DO NOT submit Award SF-50's and/or General Adjustment SF-50's as they cannot be used to prove time-in-grade.

• For a GS-14 position you must have served 52 weeks at the GS-13 level.

MINIMUM QUALIFICATION REQUIREMENT: You may qualify based on your experience described below:

GS-14 Grade Level:

• Specialized Experience: Applicants must have one (1) year of specialized experience equivalent to at least the next lower grade (GS-13) that has equipped them with the particular knowledge, skills, and abilities to successfully perform the duties of the position. Specialized experience as a Senior Extract Transform Load (ETL) Developer involves demonstrating a proficiency using Informatica PowerCenter to develop mappings, Workflow Manger to create tasks and workflows, and Workflow Monitor to monitor the workflows. Examples include, but are not limited to:
  
  
  • Understanding dimensional modeling and star schemas to include, collecting and documenting requirements from business users, designing dimension and fact tables, developing ETL processes, and supporting front end reports.
  • Practical knowledge in Oracle Database and Informatica ETL performance tuning approaches in Data Warehouse Environments.
  • Building BI solutions in OBIEE, PowerBI, C Sharp or Apex.
• Education Substitution: There is no education substitution at this grade level.

Volunteer Experience: Experience refers to paid and unpaid experience, including volunteer work done through National Service programs (e.g., Peace Corps, AmeriCorps) and other organizations (e.g., professional; philanthropic; religions; spiritual; community; student; social). Volunteer work helps build critical competencies, knowledge, and skills and can provide valuable training and experience that translates directly to paid employment. You will receive credit for all qualifying experience, including volunteer experience.

Full vs. Part-Time Employment: Full-time employment is considered to be at least 35 hours per week. Part-time experience will be credited on a pro-rated basis; when including part-time employment in your resume you must specify the average hours worked per week.

Physical Requirements: The work is primarily sedentary, although some slight physical effort may be required.

For more information on these qualification standards, please visit the United States Office of Personnel Management's website at http://://www.opm.gov/policy-data-oversight/classification-qualifications/general-schedule-qualification-standards/.

Education

This job does not have an education qualification requirement.

Additional information

VA supports the use of telework as a way to help attract and retain talented individuals in public service, increase worker productivity, and better prepare the agency to operate during emergencies. This position may be authorized for telework. Telework eligibility will be discussed during the interview process.

The Career Transition Assistance Plan (CTAP) provide eligible displaced VA competitive service employees with selection priority over other candidates for competitive service vacancies. To be qualified you must submit appropriate documentation (a copy of the agency notice, your most recent performance rating, and your most recent SF-50 noting current position, grade level, and duty location) and be found well-qualified (have a final rating of 85 or more) for this vacancy. Information about ICTAP and CTAP eligibility is on OPM's Career Transition Resources website at http://www.opm.gov/policy-data-oversight/workforce-restructuring/employee-guide-to-career-transition/.

Placement Policy: The posting of this announcement does not obligate management to fill a vacancy or vacancies by promotion. The position may be filled by reassignment, change to lower grade, transfer, appointment, or reinstatement.

It is the policy of the VA to not deny employment to those that have faced financial hardships or periods of unemployment.

This job opportunity announcement may be used to fill additional vacancies.

For more information on the "Who may apply" eligibility requirements, please refer to the OHRM Status Candidates and Other Candidate Definitions document.

Under the Fair Chance to Compete Act, the Department of Veterans Affairs prohibits requesting an applicant's criminal history prior to accepting a tentative job offer (TJO). Please visit the Human Resources and Administration/Operations, Security, and Preparedness (HRA/OSP), https://www.va.gov/EMPLOYEE/docs/The-Fair-Chance-to-Compete-Act.pdf

• Benefits
  
  A career with the U.S. government provides employees with a comprehensive benefits package. As a federal employee, you and your family will have access to a range of benefits that are designed to make your federal career very rewarding. Opens in a new windowLearn more about federal benefits.
  
  Review our benefits
  
  Eligibility for benefits depends on the type of position you hold and whether your position is full-time, part-time or intermittent. Contact the hiring agency for more information on the specific benefits offered.

How You Will Be Evaluated

You will be evaluated for this job based on how well you meet the qualifications above.

IN DESCRIBING YOUR EXPERIENCE, PLEASE BE CLEAR AND SPECIFIC. WE WILL NOT MAKE ASSUMPTIONS REGARDING YOUR EXPERIENCE. Applicants who do not fully address the specialized experience needed for the position (as described above in the job announcement) in their resume will not be referred for consideration.

After you have met the minimum qualifications, you will be rated on the following competencies based on your application for this position:

• Database Management Systems - Knowledge of the uses of database management systems and software to control the organization, storage, retrieval, security, and integrity of data.
• Requirements Analysis - Knowledge of the principles and methods to identify, analyze, specify, design, and manage functional and infrastructure requirements; includes translating functional requirements into technical requirements used for logical design or presenting alternative technologies or approaches.
• Information Technology Performance Assessment - Knowledge of the principles, methods, and tools (for example, surveys, system performance measures) to assess the effectiveness and practicality of information technology systems.
• Problem Solving - Identifies and analyzes problems; uses sound reasoning to arrive at conclusions; finds alternative solutions to complex problems; distinguishes between relevant and irrelevant information to make logical judgements.

Narrative responses are not required at this time. If you are referred for consideration, you may be asked to submit additional job related information, which may include, but not limited to; responses to the knowledge, skills and abilities; completion of a work sample, and/or an interview.

• Benefits
  
  A career with the U.S. government provides employees with a comprehensive benefits package. As a federal employee, you and your family will have access to a range of benefits that are designed to make your federal career very rewarding. Opens in a new windowLearn more about federal benefits.
  
  Review our benefits
  
  Eligibility for benefits depends on the type of position you hold and whether your position is full-time, part-time or intermittent. Contact the hiring agency for more information on the specific benefits offered.
• Required Documents
  
  As a new or existing federal employee, you and your family may have access to a range of benefits. Your benefits depend on the type of position you have - whether you're a permanent, part-time, temporary or an intermittent employee. You may be eligible for the following benefits, however, check with your agency to make sure you're eligible under their policies.
  
  To apply for this position, you must provide a complete Application Package to include the documents detailed below. Your resume and supporting documentation will be verified. Failure to submit the documents as specified may result in loss of consideration for this job announcement.
  
  • Resume detailing specialized experience and competencies as they relate to this position.
    
    • For each position in your resume, you must specify the start and end dates (month/year) and a description of duties. If the position was Federal, you should also indicate the grade level. Resumes containing a general summary of all positions held, not specifying start/end dates, and/or not including documentation supporting Federal grade level(s) are insufficient to determine basic qualifications.
  • Your most recent NON-AWARD SF-50. The SF-50 must indicate proof of status and should identify your position title, series, grade, step, salary, tenure and type of service (Competitive or Excepted).
  • Your SF-50 reflecting when you entered your highest grade (e.g. Promotion, Appointment, etc.) in order to verify time-in-grade requirements.
  
  Additional Documents accepted:
  
  
  • CTAP documentation - RIF notice, SF-50 showing VA employee, and performance appraisal
  
  Please use this checklist to make sure you have included all documents required for your application. You will not be contacted for additional information.
• How to Apply
  
  Complete the questionnaire and submit the documentation specified in the Required Documents section below. The complete application package must be submitted by 11:59 PM (ET) on 09/03/2024 to receive consideration. It is your responsibility to ensure your responses and appropriate documentation is submitted prior to the closing date. To preview the questionnaire click https://apply.usastaffing.gov/ViewQuestionnaire/12531033.
  
  1. To begin, click Apply Online to create a USA JOBS account or log in to your existing account. Follow the prompts to select your USA JOBS resume and/or other supporting documents and complete the occupational questionnaire.
  2. Click Submit My Answers to submit your application package.
  
  Click here for instructions on viewing your application status.
  
  If you are unable to apply online or need an alternate method to submit documents, please reach out to the Agency Contact listed in the Job Opportunity Announcement.
  
  Agency contact information
  
  Kira Harris
  
  Phone
  
  (410) 230-4400
  
  Email
  
  kira.harris2@va.gov
  
  Address
  
  VBA Human Resources Center - Central Office
  
  810 Vermont Ave NW
  
  Washington, DC 20420
  
  US
  
  Next steps
  
  Once your online application is submitted you will receive a confirmation notification by email. After we receive application packages (including all required documents) and the vacancy announcement closes, we will review applications to ensure qualification and eligibility requirements are met. After the review is complete, a referral certificate(s) is issued and applicants will be notified of their status by email. Referred applicants will be notified as such and may be contacted directly by the hiring office for an interview. All referred applicants receive a final notification once a selection decision has been made.
  
  You may check the status of your application at any time by logging into your USA Jobs account and clicking on Applications. Information regarding your application status can be found in the USAJobs Help Center.
• Fair and Transparent
  
  The Federal hiring process is set up to be fair and transparent. Please read the following guidance.
  
  
  • Criminal history inquiries
  • Equal Employment Opportunity (EEO) Policy
  • Financial suitability
  • New employee probationary period
  • Privacy Act
  • Reasonable accommodation policy
  • Selective Service
  • Signature and false statements
  • Social security number request

Required Documents

To apply for this position, you must provide a complete Application Package to include the documents detailed below. Your resume and supporting documentation will be verified. Failure to submit the documents as specified may result in loss of consideration for this job announcement.

• Resume detailing specialized experience and competencies as they relate to this position.
  
  • For each position in your resume, you must specify the start and end dates (month/year) and a description of duties. If the position was Federal, you should also indicate the grade level. Resumes containing a general summary of all positions held, not specifying start/end dates, and/or not including documentation supporting Federal grade level(s) are insufficient to determine basic qualifications.
• Your most recent NON-AWARD SF-50. The SF-50 must indicate proof of status and should identify your position title, series, grade, step, salary, tenure and type of service (Competitive or Excepted).
• Your SF-50 reflecting when you entered your highest grade (e.g. Promotion, Appointment, etc.) in order to verify time-in-grade requirements.

Additional Documents accepted:

• CTAP documentation - RIF notice, SF-50 showing VA employee, and performance appraisal

Please use this checklist to make sure you have included all documents required for your application. You will not be contacted for additional information.

How to Apply

Complete the questionnaire and submit the documentation specified in the Required Documents section below. The complete application package must be submitted by 11:59 PM (ET) on 09/03/2024 to receive consideration. It is your responsibility to ensure your responses and appropriate documentation is submitted prior to the closing date. To preview the questionnaire click https://apply.usastaffing.gov/ViewQuestionnaire/12531033.

1. To begin, click Apply Online to create a USA JOBS account or log in to your existing account. Follow the prompts to select your USA JOBS resume and/or other supporting documents and complete the occupational questionnaire.
2. Click Submit My Answers to submit your application package.

Click here for instructions on viewing your application status.

If you are unable to apply online or need an alternate method to submit documents, please reach out to the Agency Contact listed in the Job Opportunity Announcement.

Agency contact information

Kira Harris

Phone

(410) 230-4400

Email

kira.harris2@va.gov

Address

VBA Human Resources Center - Central Office

810 Vermont Ave NW

Washington, DC 20420

US

Next steps

Once your online application is submitted you will receive a confirmation notification by email. After we receive application packages (including all required documents) and the vacancy announcement closes, we will review applications to ensure qualification and eligibility requirements are met. After the review is complete, a referral certificate(s) is issued and applicants will be notified of their status by email. Referred applicants will be notified as such and may be contacted directly by the hiring office for an interview. All referred applicants receive a final notification once a selection decision has been made.

You may check the status of your application at any time by logging into your USA Jobs account and clicking on Applications. Information regarding your application status can be found in the USAJobs Help Center.

Fair & Transparent

The Federal hiring process is set up to be fair and transparent. Please read the following guidance.

• Criminal history inquiries
• Equal Employment Opportunity (EEO) Policy
• Financial suitability
• New employee probationary period
• Privacy Act
• Reasonable accommodation policy
• Selective Service
• Signature and false statements
• Social security number request