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.

Duties

Help

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

Requirements

Help

Conditions of employment

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.

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

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. For more information about the Act and the complaint process, visit Human Resources and Administration/Operations, Security, and Preparedness (HRA/OSP) at The Fair Chance Act.

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/[redacted]2-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.

Benefits

Help

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.