-
Help
Duties
Summary
The incumbent will serve as a Program Analyst for the Department of Veterans Affairs, Veterans Benefits Administration (VBA), Office of Performance Analysis and Integrity (PA&I), performing large data seta wide range of analyses and reporting using an Oracle based data warehouse environment.
Learn more about this agencyResponsibilities
- Analyze, troubleshoot and debug complex SQL and PL*SQL code to address stakeholder data requirements.
- Understand data warehouse artifacts, tables, table join relationships, and data marts used to fulfill data requests.
- Determine stakeholder data information needs from business requirement development.
- Communicate complex technical data-related information orally and in writing.
- Develop user response documentation and clear code to achieve technical solutions.
- Lead or participate in work teams to conduct data extraction code, to refine business requirements, to implement strategies, and to address programmatic priorities.
- Inform management of issues and events arising because of reviews and analyses
- Develop complex queries, reports, code, and dashboards to include prototyping.
- Test and implement coding solutions in a production environment.
- Collaborate with organizational counterparts to develop and recommend data policies and processes.
- Train or assist others on developing content for data and information systems, cyber security, user access, and reports.
- Apply critical thinking skills in diagnosing complex data extraction and use related problems.
- Provide reliable technical data extraction/aggregation software algorithms.
Travel Required
Not required
Supervisory status
No
Promotion Potential
13
-
Job family (Series)
-
Help
Requirements
Conditions of Employment
- You must be a U.S. citizen to apply for this job.
- Selectees are subject to a background/suitability investigation.
- Selective Service registration is required for males born after 12/31/1959.
- A probationary period may be required for employees and supervisors.
Qualifications
To qualify for this position, applicants must meet all requirements by the closing date of this announcement.
Specialized Experience:
Applicants must have one year of specialized experience equivalent to at least the next lower grade (GS-12 or a comparable pay band in Federal or other service) that demonstrates the particular competencies necessary to perform the work of this position as described in this announcement. Qualifying specialized experience for this position must clearly demonstrate expertise in designing, developing and implementing complex PL*SQL or SQL in a business environment, to include soft skills such as communication, problem-solving and analytic ability.
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.Education
This job does not have an education qualification requirement.
Additional information
Read moreWork Schedule: Monday - Friday 8:00 AM - 4:30 PM. Alternate work schedules are available.
Promotion Potential: There is no promotion potential for this position. It is expected that this position will be filled at the full performance level of grade GS-13.
Physical Requirements: The work is sedentary. Typically the employee may sit comfortably to do the work. However, there may be some walking, standing, bending or carrying of light items such as papers and books. No special physical demands are required to perform the work. The Department of Veterans Affairs provides reasonable accommodations for persons with disabilities.
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.
The Interagency Career Transition Assistance Plan (ICTAP) and Career Transition Assistance Plan (CTAP) provide eligible displaced Federal competitive service employees with selection priority over other candidates for competitive service vacancies. To be qualified you must submit appropriate documentation and be found well-qualified for this vacancy. A well-qualified candidate is defined as meeting all of the minimum qualification standards and eligibility requirements as well as possessing skills that clearly exceed the minimum qualifications requirements for this position. Specifically, a well-qualified candidate will score 90 or above within the assessment portion of this vacancy.
Information about ICTAP and CTAP eligibility can be found: here
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. Management may use any one or any combination of these methods to fill the position.
Notice to Applicants: Itis the policy of the Government not to deny employment simply because an individual has been unemployed or has had financial difficulties that have arisen through no fault of the individual. Information about an individual's employment experience will be used only to determine the person's qualifications and to assess his or her relative level of knowledge, skills, and abilities. Although an individual's personal conduct may be relevant in any employment decision, including conduct during periods of unemployment or evidence of dishonesty in handling financial matters, financial difficulty that has arisen through no fault of the individual will generally not itself be the basis of an unfavorable suitability or fitness determination.
This job opportunity announcement may be used to fill additional vacancies.How You Will Be Evaluated
Read moreYou 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.
You will be rated on the following competencies based on your application for this position:
Competency 1 - Computer Skills - Developing complex queries, reports and dashboards to include prototyping, developing code, testing, and implementing in a production environment.
Competency 2 - Communication - Communicating orally and in writing.
Competency 3 - Partnering - Collaborating with organizational counterparts in development and recommendation of policies and procedures.
Competency 4 - Technical Competence - Using project management software.
Competency 5 - Education and Training - Training others on data and information systems with regard to system functions, data content, cyber security, user access and reports.
Competency 6 - Critical Thinking - Applying critical thinking skills in diagnosing and solving complex business problems and providing reliable technical data extraction/aggregation software algorithms.
If you are referred for consideration you may be asked to submit additional job related information or maybe be offered 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.
Background checks and security clearance
Security clearance
Drug test required
No
Position sensitivity and risk
Trust determination process
-
Help
Required Documents
- Resume
Resume- Your resume may be submitted in any format, however, we strongly recommend using USA Jobs resume builder as it contains all of the information required on Federal resumes.
- 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.
- 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 4 copy of your DD Form 214 is preferable. 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 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
- Certification of expected separation, reduction-in-force separation notice, or notice of proposed removal; 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).
-
Help
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. Learn 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.
-
Help
How to Apply
Read moreTo apply for this position, you must complete the https://apply.usastaffing.gov/ViewQuestionnaire/10648779 and submit the documentation specified in the required documents section below.
The complete application package must be submitted by 11:59 PM (EST) on 11/19/2019 to receive consideration.
1. To begin, click apply online to create a USAJOBS account or log in to your existing account. Follow the prompts to select your USAJOBS résumé and/or other supporting documents and to complete the occupational questionnaire.
2. Click submit my answers to submit your application package.
Note: It is your responsibility to ensure that your response and any appropriate documentation is submitted by the closing date of the announcement. To verify that your application is complete, log into your USAJOBS account, select the application status link, and then select the more information link for this position. The details page will display the status of your application, the documentation received and processed, and any correspondence the agency has sent related to your application. Your uploaded documents may take several hours to clear the virus scan process. To return to an incomplete application, log into your USAJOBS accountand click update application in the vacancy announcement. You must re-select your resume and/or other documents from your USAJOBS account or your application will be incomplete.
Alternate Application Information: If you are unable to apply online you may review additional options: here You may also call the Alternate Application phone line Monday through Friday from 8:00 a.m. to 6:00 p.m., Eastern Standard Time, excluding Federal Holidays, at 1-478-744-2360.Agency contact information
HRC-Detroit DEU
Learn more about this agencyAddress
VBACO HRC Detroit
810 Vermont Ave NW
Washington, DC 20420
USNext steps
Read moreAfter the review is complete, a referral certificate will be issued and applicants will be notified of their status by email (if provided). 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 USAJOBS account: here
For a more detailed update of your status, click on "more information." Information regarding applicant process can be found: here -
Fair & Transparent
The Federal hiring process is setup to be fair and transparent. Please read the following guidance.
Equal Employment Opportunity Policy
Read moreThe United States Government does not discriminate in employment on the basis of race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, membership in an employee organization, retaliation, parental status, military service, or other non-merit factor.
Reasonable Accommodation Policy
Read moreFederal agencies must provide reasonable accommodation to applicants with disabilities where appropriate. Applicants requiring reasonable accommodation for any part of the application process should follow the instructions in the job opportunity announcement. For any part of the remaining hiring process, applicants should contact the hiring agency directly. Determinations on requests for reasonable accommodation will be made on a case-by-case basis.
A reasonable accommodation is any change to a job, the work environment, or the way things are usually done that enables an individual with a disability to apply for a job, perform job duties or receive equal access to job benefits.
Under the Rehabilitation Act of 1973, federal agencies must provide reasonable accommodations when:
- An applicant with a disability needs an accommodation to have an equal opportunity to apply for a job.
- An employee with a disability needs an accommodation to perform the essential job duties or to gain access to the workplace.
- An employee with a disability needs an accommodation to receive equal access to benefits, such as details, training, and office-sponsored events.
You can request a reasonable accommodation at any time during the application or hiring process or while on the job. Requests are considered on a case-by-case basis.
Learn more about disability employment and reasonable accommodations or how to contact an agency.
Legal and regulatory guidance
This job originated on www.usajobs.gov. For the full announcement and to apply, visit www.usajobs.gov/GetJob/ViewDetails/551869800. Only resumes submitted according to the instructions on the job announcement listed at www.usajobs.gov will be considered.
