Program Analyst

The Data Requests (DR) team is responsible for delivering timely and accurate customized data extraction solutions to support the data reporting needs of the Agency. DR develops coding solutions that extract and transform warehouse data as per user business requirements into reporting artifacts, using a combination of Oracle SQL, Oracle PL*SQL, and Microsoft Excel.

The Data Requests (DR) team provides data and written responses to tasks from the Office of Executive Review (OER) in response to requests from the White House, Congress, VA Central Office, VBA Central Office, the Congressional Budget Office (CBO), the Government Accountability Office (GAO), the Office of the Inspector General (OIG), the media, Freedom of Information Act (FOIA) requests, and other external stakeholders. Specific duties include: 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. Inform PA&I management of issues and events arising because of reviews and analyses for which the incumbent is assigned. Work Schedule: Full time, Monday through Friday. 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/PD#: Program Analyst; GS-0343-13 PD# 37394-A. Relocation/Recruitment Incentives: Not Authorized. Financial Disclosure Report: Not Required.

As a condition of employment for accepting this position, you will be required to serve a 1-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, your employment will be terminated unless you receive certification, in writing, that your continued employment advances the public interest. 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 Selected applicants will be required to complete an online onboarding process 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.

There is no education substitute at this level.