This Program Analyst position GS-0343-14 is located in the Veterans Benefits Administration, Performance Analysis & Integrity, (PA&I) in Washington, DC. PA&I develops and maintains VBA's Enterprise DATA Warehouse (EDW), publishes authoritative operating performance reports, ad hoc data reports, performs data mining activities and provides statistical evaluations of VBA activities to gain insights into the workload and operations that support VBA missions
Summary
This Program Analyst position GS-0343-14 is located in the Veterans Benefits Administration, Performance Analysis & Integrity, (PA&I) in Washington, DC. PA&I develops and maintains VBA's Enterprise DATA Warehouse (EDW), publishes authoritative operating performance reports, ad hoc data reports, performs data mining activities and provides statistical evaluations of VBA activities to gain insights into the workload and operations that support VBA missions
Plan, coordinate, and implement activities necessary for effective operations and maintenance of Enterprise Data Warehouse Database (EDW)
Develop policies and procedures that meet data management or operational performance objectives
Experience in back up and recover enterprise data warehouse
Document customer requirements for business intelligence tools and recommend solutions
Expert knowledge of how to build reports using business intelligence reporting system (Oracle BI, Tableau, and Tableau Server).
Review code to ensure industry, standards and best practices are met with a focus on business requirements.
Identify architectural issues and technical problems with organization's Enterprise Data Warehouse.
Develop complex queries, reports, dashboards, and designing report formats, prototyping, developing code, testing, and implementing in the production environment.
Serve as the subject-matter-expert and assists in the planning, coordination, and implementation of the operation and maintenance of Enterprise Data Warehouse databases.
Assist in planning, coordination, and implementation of data marts and data architecture solutions supporting the Enterprise Data Warehouse Database internal and external partners.
Architecting data warehousing reporting solutions from conception to delivery consisting of analysis, high level design, data modeling, ETL development, user interface development, integration and implementation using the appropriate tools,.
Identify flaws and weaknesses in the composition and design of the database structures, queries and application code and web-based software
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.
A complete application package; Resume, Transcripts, etc.
Selected applicants will be required to complete an online onboarding process.
Qualifications
To qualify for this position, applicants must meet all requirements by the closing date of this announcement, 04/29/2024.
Please Note: The closing date for this announcement has been extended.
The Office of Personnel Management's (OPM's) group qualification standards covering white collar occupations in the Federal competitive service can be found: Here
Specialized Experience: To qualify, applicants must have one year of specialized experience equivalent to at least the next lower grade level (GS 13) in the normal line of progression for the occupation in the organization. Specialized experience is defined as: (1) Working in an Oracle data warehouse environment, as a Database Administrator; (2) Demonstrated experience in developing Extract Transfer and Load (ETL) functionality; (3) Demonstrated proficiency in optimizing Oracle tables or data marts; AND (4) Proficiency in using PL/ SQL, SQL, and APEX or products similar to APEX.
There is no option to Substitute education for experience at the Grade Level GS-14.
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
There is no option to Substitute education for experience at the Grade Level GS-14.
Additional information
Note: This announcement has been amended to extend the closing date, 04/29/2024
This is not a Virtual/Remote Position.
Work Schedule: Regular office hours, Monday -Friday, 8:00 AM - 4:30 PM. Alternate work Schedules may be available.
Promotion Potential: The selectee may be promoted to the full performance level without further competition when all regulatory, qualification, and performance requirements are met. Selection at a lower grade level does not guarantee promotion to the full performance level. The full performance level of this position is grade GS-11.
Physical Requirements: The work is sedentary Work is primarily sedentary but involves use of a government issued laptop. A degree of manual dexterity, and visual acuity is required to utilize these tools. Occasional standing, bending, walking, and stooping may also be experienced. Some slight physical effort is required in that incumbent lifts and carries reference books, working papers, and similar items to and from meetings. A moderate amount of standing and walking is required in getting to and from meeting places away from the worksite. The incumbent may become fatigued due to reading difficult types of printed and handwritten material over an extended period. No special physical demands are required. The Department of Veterans Affairs makes reasonable accommodations for persons with disabilities.
VA supports the use of telework as a way to help attract and retain talented individuals in public service, increase worker productivity, and better prepare the agency to operate during emergencies. This position may be authorized for telework. Telework eligibility will be discussed during the interview process.
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.
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.
This job opportunity announcement may be used to fill additional vacancies.
If you are unable to apply online or need to fax a document you do not have in electronic form, view the following link for information regarding an Alternate Application
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. Applicants will be referred in alphabetical order.
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.
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.
Accepted Documents:
Cover Letter
DD-214/ Statement of Service
Disability Letter (Schedule A)
Disability Letter (VA)
CTAP/ICTAP
PCS Orders
Performance Appraisal
Proof of Marriage Status
Resume
Separation Notice (RIF)
SF-15
SF-50/ Notification of Personnel Action
Transcript
Transcripts
If you are basing all or some of your qualifications on education or if a degree is required for the position, a transcript must be included as part of your application package.
An unofficial transcript may be submitted, however, it must reflect the course names, levels, credits earned, grades received, and degree conferred if applicable.
Your transcript (official of unofficial) must reflect the degree conferred date if you are substituting a degree for experience.
A photocopy of your degree is not acceptable in lieu of a transcript.
An official transcript will be required at a later date if you are selected for the position.
Whenever possible it is preferable that you submit copies of official transcripts. Unofficial transcripts may lack essential information necessary for a full evaluation of your qualifications.
Applicants claiming CTAP/ICTAP eligibility must also submit: 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).
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. Please review the above list(s) to ensure you have included all necessary documents required for your application. Not every applicant will require the same documents, therefore it is the applicants responsibility to ensure that their application package includes all necessary documents to determine qualifications and eligibility for appointment, such as a copy of your SF-50, transcript, ICTAP/CTAP documentation (for displaced Federal employees).You will not be contacted for additional information. Applicants will be deemed ineligible if supporting documentation is not submitted.
Veterans' Preference: Since the Direct-Hire Recruitment Authority is being used, traditional Veterans' Preference rules do not apply. Qualified veterans will, however, be given full consideration for this position.
Applications are accepted online. Applying online will allow you to review and track the status of your application.
If you are relying on your education to meet qualification requirements:
Failure to provide all of the required information as stated in this vacancy announcement may result in an ineligible rating or may affect the overall rating.
To apply for this position, you must complete the occupational questionnaire and submit the documentation specified in the Required Documents section. The complete application package must be submitted by 11:59 PM (EST) on 04/29/2024 to receive consideration. To preview the questionnaire clickhttps://apply.usastaffing.gov/ViewQuestionnaire/12353637
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 resume and/or other supporting documents and complete the occupational questionnaire.
2. Click Submit My Answers to submit your application package.
NOTE: It is your responsibility to ensure your responses and appropriate documentation is submitted prior to the closing date. To verify your application is complete, log into your USAJOBS account, https://my.usajobs.gov/Account/Login 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 this application. Your uploaded documents may take several hours to clear the virus scan process.
To return to an incomplete application, log into your USAJOBS account and 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.
Additional information for your consideration when making application:
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 Hatps://vv.opm.gov/
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. If you are unable to apply online or need to fax a document you do not have in electronic form, view the following link for information regarding an Alternate Application
VBA Human Resources Center - Central Office
810 Vermont Ave NW
Washington, DC 20420
US
Next steps
After the vacancy announcement closes, applicants are evaluated 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.
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
The Federal hiring process is set up to be fair and transparent. Please read the following guidance.
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.
Accepted Documents:
Cover Letter
DD-214/ Statement of Service
Disability Letter (Schedule A)
Disability Letter (VA)
CTAP/ICTAP
PCS Orders
Performance Appraisal
Proof of Marriage Status
Resume
Separation Notice (RIF)
SF-15
SF-50/ Notification of Personnel Action
Transcript
Transcripts
If you are basing all or some of your qualifications on education or if a degree is required for the position, a transcript must be included as part of your application package.
An unofficial transcript may be submitted, however, it must reflect the course names, levels, credits earned, grades received, and degree conferred if applicable.
Your transcript (official of unofficial) must reflect the degree conferred date if you are substituting a degree for experience.
A photocopy of your degree is not acceptable in lieu of a transcript.
An official transcript will be required at a later date if you are selected for the position.
Whenever possible it is preferable that you submit copies of official transcripts. Unofficial transcripts may lack essential information necessary for a full evaluation of your qualifications.
Applicants claiming CTAP/ICTAP eligibility must also submit: 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).
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. Please review the above list(s) to ensure you have included all necessary documents required for your application. Not every applicant will require the same documents, therefore it is the applicants responsibility to ensure that their application package includes all necessary documents to determine qualifications and eligibility for appointment, such as a copy of your SF-50, transcript, ICTAP/CTAP documentation (for displaced Federal employees).You will not be contacted for additional information. Applicants will be deemed ineligible if supporting documentation is not submitted.
Veterans' Preference: Since the Direct-Hire Recruitment Authority is being used, traditional Veterans' Preference rules do not apply. Qualified veterans will, however, be given full consideration for this position.
Applications are accepted online. Applying online will allow you to review and track the status of your application.
If you are relying on your education to meet qualification requirements:
Failure to provide all of the required information as stated in this vacancy announcement may result in an ineligible rating or may affect the overall rating.
To apply for this position, you must complete the occupational questionnaire and submit the documentation specified in the Required Documents section. The complete application package must be submitted by 11:59 PM (EST) on 04/29/2024 to receive consideration. To preview the questionnaire clickhttps://apply.usastaffing.gov/ViewQuestionnaire/12353637
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 resume and/or other supporting documents and complete the occupational questionnaire.
2. Click Submit My Answers to submit your application package.
NOTE: It is your responsibility to ensure your responses and appropriate documentation is submitted prior to the closing date. To verify your application is complete, log into your USAJOBS account, https://my.usajobs.gov/Account/Login 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 this application. Your uploaded documents may take several hours to clear the virus scan process.
To return to an incomplete application, log into your USAJOBS account and 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.
Additional information for your consideration when making application:
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 Hatps://vv.opm.gov/
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. If you are unable to apply online or need to fax a document you do not have in electronic form, view the following link for information regarding an Alternate Application
VBA Human Resources Center - Central Office
810 Vermont Ave NW
Washington, DC 20420
US
Next steps
After the vacancy announcement closes, applicants are evaluated 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.
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 and transparent
The Federal hiring process is set up to be fair and transparent. Please read the following guidance.
