Summary
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.
Duties
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.
Requirements
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.
Education
There is no education substitute at this level.
How you will be evaluated
You will be evaluated based on how well you meet the qualifications listed in this vacancy announcement. Your qualifications will be evaluated based on your application materials (e.g., resume, supporting documents), your responses on the application questionnaire, and your responses to all assessments required for this position. You will be assessed on the following competencies (knowledge, skills, abilities, and other characteristics): Accountability Attention to Detail Customer Service Decision Making Flexibility Influencing/Negotiating Integrity/Honesty Interpersonal Skills Learning Reading Comprehension Reasoning Self-Management Stress Tolerance Teamwork Computer Languages - Knowledge of computer languages and their applications to enable a system to perform specific functions. Customer Service - Anticipates and meets the needs of both internal and external customers. Delivers high-quality products and services; is committed to continuous improvement. Data Base Management Systems - Knowledge of the uses of database management systems and software to control the organization, storage, retrieval, security, and integrity of data. The USA Hire Assessments includes a cut score based on the minimum level of required proficiency in these critical general competencies. You must meet or exceed the cut score to be considered. You will not be considered for the position if you score below the cut score or fail to complete the assessment. This position will utilize a Structured Interview Assessment which includes a pass/fail score based on the minimum level of required proficiency in these critical general competencies. You must meet or exceed the pass score to be considered. You will not be considered for the position if you score below the pass score or fail to complete the assessment. Overstating your qualifications and/or experience in your application materials or application questionnaire may result in your removal from consideration. Cheating on an assessment may also result in your removal from consideration.