This position is located in the department of Veterans Affairs, Veterans Benefits Administration (VBA), Office of Performance Analysis and Integrity (PA&I). PA&I is responsible for VBA's data management strategy, advanced analytical and statistical services, publishing VBA performance metrics, data request responses, and management of VBA's Data Warehouse, ensuring that stakeholders have accurate and available data to support the delivery benefits to Veterans.
Summary
This position is located in the department of Veterans Affairs, Veterans Benefits Administration (VBA), Office of Performance Analysis and Integrity (PA&I). PA&I is responsible for VBA's data management strategy, advanced analytical and statistical services, publishing VBA performance metrics, data request responses, and management of VBA's Data Warehouse, ensuring that stakeholders have accurate and available data to support the delivery benefits to Veterans.
The Program Analyst for PA&I performs a wide range of analyses, reporting, project management, and training activities. The position's responsibilities include but are limited to the following:
Determine stakeholder information needs as per business requirements using data warehouse artifacts such as tables, applicable table relationships, data marts and views used to fulfill ADHOC data request
Analyzes, designs, develops, troubleshoots and debugs complex SQL and PL*SQL code to address stakeholder ADHOC requirements.
Communicates complex technical information and business concepts both in writing and verbally to stakeholders, subordinates, peers and leadership
Create technical solutions by developing user response documentation, code comments and clear code. Preparing and releasing correspondences for use by other federal, state and local agencies
Inform PA and I management of issues and events arising because of reviews and analyses for which the incumbent is assigned
Experience in database modeling, including data mart design, data cataloging management, and meta-data management in a Data Warehouse Environments.
Provide PA&I Leadership with status updates on the projects and data architecture enhancements
Assist in planning, coordination, and implementation of data marts and data architecture solutions supporting the Enterprise Data Warehouse Database internal and external partners
Create an optimal EDW data architecture design through data analysis and requirements elicitation
Collaborate with end users and contractor to identify needs and opportunities for improved data management and delivery
Develop end to end data warehousing solutions involving Informatica ETL development and front end visualization with Power BI, OBIEE or Tableau.
Promotion Potential: None
Work Schedule: Full time, Monday through Friday, 8:00 AM to 4:30 PM Compressed/Flexible: Available Telework: This position is eligible for situational (ad hoc) telework only. The selectee is required to report to the official duty station each scheduled workday. Telework may be approved only on a case-by-case basis with supervisory approval. Routine or recurring telework is not authorized for this position. Virtual: This is not a virtual position. Position Description Title/PD#: Program Analyst/PD37394A Relocation/Recruitment Incentives: Not Authorized Financial Disclosure Report: Not required Bargaining Unit: No
As a condition of employment for accepting this position, you may be required to serve a 1-year or 2-year probationary period during which we will evaluate your fitness and whether your continued employment advances the public interest. In determining if your employment advances the public interest, we may consider:
Your performance and conduct;
The needs and interests of the Agency;
Whether your continued employment would advance organizational goals of the Agency or the Government; and
Whether your continued employment would advance the efficiency of the Federal service.
Upon completion of your probationary or trial period, your employment will be terminated unless you receive certification, in writing, that your continued employment advances the public interest. Additional Conditions of Employment are as follows:
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 or trial period
Subject to background/security investigation
Required to attend an 8 week training session, which may require travel.
Selected applicants will be required to complete an online onboarding process. Acceptable form(s) of identification will be required to complete pre-employment requirements I-9 Acceptable Documents.
Effective May 7, 2025, driver's licenses or state-issued identification cards that are not REAL ID compliant cannot be utilized as an acceptable form of identification for employment.
Qualifications
To qualify for this position, applicants must meet all requirements by the closing date of this announcement, 07/31/2026.
MINIMUM QUALIFICATION REQUIREMENT: You may qualify based on your experience as described below:
GS-13 Specialized Experience: Applicants must have one (1) year of specialized experience equivalent to at least the next lower grade (GS-12) in the federal, state, local, public, or private sector. Specialized experience for this position is defined as: Designing, developing and implementing complex Structured Query Language (SQL) or Procedural Language Extensions (PL/SQL) in a business environment. OR, designing and developing frontend solutions utilizing OBIEE, PowerBI or APEX; data warehousing development and architecture experience; leveraging data marts, working with Informatica or with Extra Transfer Loading (ETL) tools, and the ability to perform tune Oracle Procedural Language Extensions (PL/SQL) and Structured Query Language (SQL).
Note: 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 you document, to include 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.
Reasonable Accommodation (RA) Requests: If you believe you have a disability (i.e., physical or mental), covered by the Rehabilitation Act of 1973 as amended that would interfere with completing the USA Hire Competency Based Assessments, you will be granted the opportunity to request a RA in your online application. Requests for RA for the USA Hire Competency Based Assessments and appropriate supporting documentation for RA must be received prior to starting the USA Hire Competency Based Assessments. Decisions on requests for RA are made on a case-by-case basis. If you meet the minimum qualifications of the position, after notification of the adjudication of your request, you will receive an email invitation to complete the USA Hire Competency Based Assessments, based on your adjudication decision. You must complete all assessments within 48 hours of receiving the URL to access the USA Hire Competency Based Assessments if you received the link after the close of the announcement. To determine if you need a RA, please review the Procedures for Requesting a Reasonable Accommodation for Online Assessments. (https://appsupport.usastaffing.gov/hc/en-us/sections/28980686389652-Reasonable-Accommodation-Inform…)
The Interagency Career Transition Assistance Plan (ICTAP) and Career Transition Assistance Plan (CTAP) provide eligible displaced VA competitive service employees with selection priority over other candidates for competitive service vacancies. To be well-qualified, applicants must possess experience that exceeds the minimum qualifications of the position including all selective factors if applicable, and must be proficient in most of the requirements of the job. Information about ICTAP and CTAP eligibility is on OPM's Career Transition Resources website which can be found at https://www.opm.gov/.
Receiving Service Credit for Earning Annual (Vacation) Leave: Federal Employees earn annual leave at a rate (4, 6 or 8 hours per pay period) which is based on the number of years they have served as a Federal employee. VA may offer newly-appointed Federal employee's credit for their job-related non-federal experience or active duty uniformed military service. This credited service can be used in determining the rate at which they earn annual leave. Such credit must be requested and approved prior to the appointment date and is not guaranteed.
This job opportunity announcement may be used to fill additional vacancies.
If you are unable to apply online or need an alternate method to submit documents, please reach out to the Agency Contact listed in this Job Opportunity Announcement.
Candidates should be committed to improving the efficiency of the Federal government, passionate about the ideals of our American republic, and committed to upholding the rule of law and the United States Constitution.
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.
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 in their resumes the specialized experience needed for the position (as described in the job announcement), or who do not possess the education to substitute for it, will not be referred for further consideration.
If you are referred for consideration you will be rated on the following competencies (knowledge, skills and abilities) based on your application for this position:
Accountability
Attention to Detail
Customer Service
Decision Making
Flexibility
Influencing/Negotiating
Integrity/Honesty
Interpersonal Skills
Learning
Reading Comprehension
Reasoning
Self-Management
Stress Tolerance
Teamwork
You will also be rated on the following agency-specific competencies (KSAs):
Computer Skills
Data Management
Problem Solving
Data Base Management Systems
Information Technology Performance Assessment
You may be asked to submit additional job related information, which may include responses to the knowledge, skills and abilities identified in the announcement; and/or completion of a work sample; and/or an interview. Your resume and/or supporting documentation will be verified. Please follow all instructions carefully. Errors or omissions may affect your rating or your further consideration for employment.
After we receive application packages (including all required documents) and the vacancy announcement closes, we review applications to ensure qualification and eligibility requirements are met. During our review, if your résumé and application package does not support your questionnaire answers, we will adjust your rating accordingly.
Your application will be evaluated using the category rating method based on your responses to the assessment questions and the documents you submit. If you meet the basic requirements for the position, your application will be evaluated and placed into one of three categories:
Best Qualified Category - Candidates who meet the minimum qualification requirements and demonstrate a high level of the knowledge, skills, and abilities necessary to perform the duties of the position.
Well Qualified Category - Candidates who meet the minimum qualification requirements and demonstrate a satisfactory level of the knowledge, skills, and abilities necessary to perform the duties of the position.
Qualified Category - Candidates who meet the minimum qualifications requirements.
Note: Candidates eligible for Veterans' preference will be placed ahead of other candidates in the appropriate category for which they have been rated. Additionally, preference eligible who have a compensable service-connected disability of at least 10 percent and who meet the minimum qualification requirements will automatically be placed in the best qualified category.
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.
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.
You must provide a resume detailing your specialized experience and competencies relevant to the position.
For qualifications determinations your resume must reflect hours worked per week, the inclusive dates of employment, and the level of your experience. If your resume does not reflect this information you will not receive credit for the experience.
If you submit more than one copy of your resume, the most recent version will be reviewed. The latest timestamp will be used to determine which version of your resume is "most recent." It is your responsibility to check the status and timestamp of all documents you submit as part of your application. We would recommend that you not submit more than one version of your resume.
If your resume includes a photograph or other inappropriate material or content, we will not use it to make eligibility and qualification determinations, and you may not be considered further for the vacancy.
Accepted Documents:
Cover Letter
DD-214/ Statement of Service
Disability Letter (Schedule A)
Disability Letter (VA)
CTAP/ICTAP Documents
PCS Orders
Performance Appraisal
Proof of Marriage Status
Resume
Separation Notice (RIF)
SF-15
SF-50/ Notification of Personnel Action
Transcript
Applicants claiming Veterans' preference must also submit:
A legible copy of your DD Form 214, "Certificate of Release or Discharge from Active Duty," showing all dates of service, as well as character of service (Honorable, General, etc.) is required. The member copy 2 or 4 of your DD Form 214 is preferable, as they show the characterization of service. Copies of DD-214's can be requested: Here
Current active duty members must submit a signed statement of service from their commander dated within the last 120 days that reflects their expected discharge date, their release from active duty under honorable conditions, any medals awarded, and the timeframe of their service so that eligibility can be determined.
Veterans and others (Spouse, Parents, Widows/Widowers) claiming 10 point preference must also submit an SF-15 and all documents indicated on the form as proof of type of preference. This includes a VA letter supporting your disability claim with the overall percentage listed.
If you are unsure as to whether you qualify for Veterans' preference, please consult the U.S. Department of Labor's Veterans' Preference Advisor: Here
Applicants claiming CTAP/ICTAP eligibility must also submit: Here
Certification of expected separation, reduction-in-force separation notice and your most recent performance evaluation; and an SF-50 demonstrating your separation or the position you will be separated from; or
Worker's compensation separation (agency certification of inability to place employee and notification of separation or a separation SF-50; or
Disability annuity termination (notification from OPM of disability annuity termination and separation SF-50 of the last position held); or
Military reserve or National Guard technician special disability retirement annuity under 5 U.S.C. 8337(h) or 8456 (certification of special disability retirement annuity from a military department or National Guard bureau and separation SF-50 of the last position held).
Failure to submit any of the above mentioned required documents may result in loss of consideration due to an incomplete application package. It is your responsibility to ensure that all required documents have been submitted by the closing date of the announcement. You will not be contacted for additional information.
The complete application package must be submitted by 11:59 PM (EST) on the closing date 07/31/2026 to receive consideration.
The application process is as follows:
Click the Apply Online button.
Answer the questions presented in the application and attach all necessary supporting documentation.
Click the Submit Application button prior to 11:59 PM (ET) on the announcement closing date.
If you are required to complete any USA Hire Assessments, you will be notified after submitting your application. The notification will be provided in your application submission screen and via email. The notification will include your unique assessment access link to the USA Hire system and the completion deadline. Additionally, in USAJOBS you can click "Track this application" to return to your assessment completion notice.
Access USA Hire using your unique assessment link. Access is granted through your USAJOBS login credentials.
Review all instructions prior to beginning your assessments. You will have the opportunity to request a testing accommodation before beginning the assessments should you have a disability covered under the Rehabilitation Act of 1973 as amended.
Set aside about two (2) hours to take the USA Hire Assessments; however, most applicants complete the assessments in less time. If you need to stop the assessments and continue later, you can re-use your unique assessment link.
Your responses to the USA Hire Assessments will be reused for one year (in most cases) from the date you complete an assessment. If future applications you submit require completion of the same assessments, your responses will be automatically reused.
To view the announcement status or your application status: Visit https://help.usajobs.gov/how-to/application/status. Your application status page is where you can view your application status, USA Hire assessment completion status, and review your notifications sent by the hiring agency regarding your application.
Beginning September 27, 2025, Federal agencies will only accept resumes up to two pages in length to comply with the Merit Hiring Plan. Resumes longer than two pages will result in ineligibility for further consideration for the position. USAJOBS will not allow you to upload or build resumes longer than two pages, and you will need to update the resumes in your profile before applying for a job. Resumes should include information relevant to the knowledge, skills, abilities, and competencies of the position to which you are applying. VA is unable to make assumptions about qualifications if not clearly listed.
Resumes must be legible so they can be reviewed for eligibility, minimum qualifications and other position requirements listed in the job opportunity announcement.
Your resume must be 5MB or less. We recommend saving and uploading your resume as a PDF to maintain formatting and number of pages. We also accept GIF, JPG, JPEG, PNG, RTF, TXT, PDF, ODT or Word (DOC or DOCX). We do not accept PDF portfolio files. We recommend using a sans-serif font size like Lato, if available. Other widely available options are Calibri, Helvetica, Arial, Verdana, Open San Source Sans Pro, Roboto or Noro Sans. Make your page margins 0.5 inches. Consider using 14-point size font for titles and 10-point for the main text in your resume. The resume builder can help you create a resume using these recommendations and uses the information in your USAJOBS profile to help you get started.
Helpful Hints for Creating a Two-Page Resume:
Prioritize most relevant and recent experience
Use concise, results focused language
Align language from the job announcement
Focus on demonstrating skills and competencies
Remove outdated or unrelated experience
Use the USAJOBS resume builder
Additional guidance on this new requirement and resume building tools can be found at:
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.
Referred applicants may be contacted at any time during the hiring process. Please check all forms of communication (including email, voicemail, and spam folders), based on the contact information provided with your application, regularly to ensure you don't miss any updates. Failure to respond to communications may result in you being disqualified from consideration. You will receive a final notification of results once a 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.
The Federal hiring process is set up to be fair and transparent. Please read the following guidance.
You must provide a resume detailing your specialized experience and competencies relevant to the position.
For qualifications determinations your resume must reflect hours worked per week, the inclusive dates of employment, and the level of your experience. If your resume does not reflect this information you will not receive credit for the experience.
If you submit more than one copy of your resume, the most recent version will be reviewed. The latest timestamp will be used to determine which version of your resume is "most recent." It is your responsibility to check the status and timestamp of all documents you submit as part of your application. We would recommend that you not submit more than one version of your resume.
If your resume includes a photograph or other inappropriate material or content, we will not use it to make eligibility and qualification determinations, and you may not be considered further for the vacancy.
Accepted Documents:
Cover Letter
DD-214/ Statement of Service
Disability Letter (Schedule A)
Disability Letter (VA)
CTAP/ICTAP Documents
PCS Orders
Performance Appraisal
Proof of Marriage Status
Resume
Separation Notice (RIF)
SF-15
SF-50/ Notification of Personnel Action
Transcript
Applicants claiming Veterans' preference must also submit:
A legible copy of your DD Form 214, "Certificate of Release or Discharge from Active Duty," showing all dates of service, as well as character of service (Honorable, General, etc.) is required. The member copy 2 or 4 of your DD Form 214 is preferable, as they show the characterization of service. Copies of DD-214's can be requested: Here
Current active duty members must submit a signed statement of service from their commander dated within the last 120 days that reflects their expected discharge date, their release from active duty under honorable conditions, any medals awarded, and the timeframe of their service so that eligibility can be determined.
Veterans and others (Spouse, Parents, Widows/Widowers) claiming 10 point preference must also submit an SF-15 and all documents indicated on the form as proof of type of preference. This includes a VA letter supporting your disability claim with the overall percentage listed.
If you are unsure as to whether you qualify for Veterans' preference, please consult the U.S. Department of Labor's Veterans' Preference Advisor: Here
Applicants claiming CTAP/ICTAP eligibility must also submit: Here
Certification of expected separation, reduction-in-force separation notice and your most recent performance evaluation; and an SF-50 demonstrating your separation or the position you will be separated from; or
Worker's compensation separation (agency certification of inability to place employee and notification of separation or a separation SF-50; or
Disability annuity termination (notification from OPM of disability annuity termination and separation SF-50 of the last position held); or
Military reserve or National Guard technician special disability retirement annuity under 5 U.S.C. 8337(h) or 8456 (certification of special disability retirement annuity from a military department or National Guard bureau and separation SF-50 of the last position held).
Failure to submit any of the above mentioned required documents may result in loss of consideration due to an incomplete application package. It is your responsibility to ensure that all required documents have been submitted by the closing date of the announcement. You will not be contacted for additional information.
The complete application package must be submitted by 11:59 PM (EST) on the closing date 07/31/2026 to receive consideration.
The application process is as follows:
Click the Apply Online button.
Answer the questions presented in the application and attach all necessary supporting documentation.
Click the Submit Application button prior to 11:59 PM (ET) on the announcement closing date.
If you are required to complete any USA Hire Assessments, you will be notified after submitting your application. The notification will be provided in your application submission screen and via email. The notification will include your unique assessment access link to the USA Hire system and the completion deadline. Additionally, in USAJOBS you can click "Track this application" to return to your assessment completion notice.
Access USA Hire using your unique assessment link. Access is granted through your USAJOBS login credentials.
Review all instructions prior to beginning your assessments. You will have the opportunity to request a testing accommodation before beginning the assessments should you have a disability covered under the Rehabilitation Act of 1973 as amended.
Set aside about two (2) hours to take the USA Hire Assessments; however, most applicants complete the assessments in less time. If you need to stop the assessments and continue later, you can re-use your unique assessment link.
Your responses to the USA Hire Assessments will be reused for one year (in most cases) from the date you complete an assessment. If future applications you submit require completion of the same assessments, your responses will be automatically reused.
To view the announcement status or your application status: Visit https://help.usajobs.gov/how-to/application/status. Your application status page is where you can view your application status, USA Hire assessment completion status, and review your notifications sent by the hiring agency regarding your application.
Beginning September 27, 2025, Federal agencies will only accept resumes up to two pages in length to comply with the Merit Hiring Plan. Resumes longer than two pages will result in ineligibility for further consideration for the position. USAJOBS will not allow you to upload or build resumes longer than two pages, and you will need to update the resumes in your profile before applying for a job. Resumes should include information relevant to the knowledge, skills, abilities, and competencies of the position to which you are applying. VA is unable to make assumptions about qualifications if not clearly listed.
Resumes must be legible so they can be reviewed for eligibility, minimum qualifications and other position requirements listed in the job opportunity announcement.
Your resume must be 5MB or less. We recommend saving and uploading your resume as a PDF to maintain formatting and number of pages. We also accept GIF, JPG, JPEG, PNG, RTF, TXT, PDF, ODT or Word (DOC or DOCX). We do not accept PDF portfolio files. We recommend using a sans-serif font size like Lato, if available. Other widely available options are Calibri, Helvetica, Arial, Verdana, Open San Source Sans Pro, Roboto or Noro Sans. Make your page margins 0.5 inches. Consider using 14-point size font for titles and 10-point for the main text in your resume. The resume builder can help you create a resume using these recommendations and uses the information in your USAJOBS profile to help you get started.
Helpful Hints for Creating a Two-Page Resume:
Prioritize most relevant and recent experience
Use concise, results focused language
Align language from the job announcement
Focus on demonstrating skills and competencies
Remove outdated or unrelated experience
Use the USAJOBS resume builder
Additional guidance on this new requirement and resume building tools can be found at:
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.
Referred applicants may be contacted at any time during the hiring process. Please check all forms of communication (including email, voicemail, and spam folders), based on the contact information provided with your application, regularly to ensure you don't miss any updates. Failure to respond to communications may result in you being disqualified from consideration. You will receive a final notification of results once a 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.
