Program Analyst

Washington D.C.
Feb 21, 2019
Feb 21, 2019
Full Time

Occasional travel - You may be expected to travel for this position.

Relocation expenses reimbursed No

  • 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.
  • Telework: May be discussed at the time of interview.
  • Virtual: This is not a virtual position.
  • Work schedule: 8:00am - 4:30pm. A compressed or flexible schedule may be available.
  • Relocation/Recruitment Incentives: Not Authorized.
  • To qualify for this position, applicants must meet all requirements by the closing date of this announcement, 02/20/2019.

    You will be rated on the following competencies based on your application for this position. Applicants MUST possess experience that clearly demonstrates the following competencies. This experience and/or training MUST be reflected by descriptions of your experience in your resume:

    Competency 1: Ability to professionally interact with a variety of stakeholders and customers using oral and written skills.
    Competency 2: Ability to design business intelligence tools to extract data sets for data analysis.
    Competency 3: Ability to write and review complex code, SQL, and conduct ETL (extract, transform and load) reviews using Informatica or a similar tool.
    Competency 4: Knowledge of building an Oracle Repository and Data Marts.
    Competency 5: Ability to build reports using Oracle Business Intelligence Enterprise Edition (OBIEE).

    Physical Requirements: The work is typically performed in an adequately lighted and climate-controlled office. There are no special physical requirements. The Department of Veterans Affairs provides reasonable accommodations for persons with disabilities.

    You may qualify based on your specialized experience as described below. There is no provision for substitution of education for experience at the grade GS-13.

    GS-13: you must have one year of specialized experience equivalent to grade GS-12 in Federal or other service is qualifying.

    Specialized experience for this position may have been gained in a position that equipped you with the particular competencies needed to carry out the major responsibilities listed in this announcement. Experience querying and extracting data from information management systems (to include related data warehousing) and working with relational and non-relational databases using database technology is desired. Your application must show that you have:
    • Experience in an Enterprise Data Warehouse production environment, such as with ORACLE Business Intelligence Enterprise Edition (OBIEE) and Virtual Analyzer (or similar tools) for reporting;
    • Experience in developing code using Structured Query Language (or similar) that indicates a clear understanding of large relational databases;
    • Experience in developing ETL (extract, transform and load) algorithms to migrate large volumes of data into a star schema.
    If you are referred for consideration, you may be asked to submit additional job related information, which may include, but not limited to, responses to the above listed competencies, completion of work samples and/or contact for an interview.

    IN DESCRIBING YOUR EXPERIENCE, PLEASE BE CLEAR AND SPECIFIC. WE MAY NOT MAKE ASSUMPTIONS REGARDING YOUR EXPERIENCE. If your resume does not support your questionnaire answers, we will not allow credit for your response(s).

    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, including volunteer experience.

    Note: A full year of work is considered to be 35-40 hours of work per week. Part-time experience will be credited on the basis of time actually spent in appropriate activities. Applicants wishing to receive credit for such experience must indicate clearly the nature of their duties and responsibilities in each position and the number of hours a week spent in such employment.

    Applicants will be ranked based on three quality groups, as follows:
    • Highly Qualified - applicants possessing experience that substantially exceeds the minimum qualifications of the position including all selective factors, and who are highly proficient in all requirements of the job and can perform effectively in the position;
    • Best Qualified - applicants possessing experience that meets the minimum qualifications of the position including all selective factors, and who are proficient in some, but not all, of the requirement of the job;
    • Well Qualified - Applicants possessing experience and/or education that meets the minimum qualifications of the position including all selective factors.
    Note: Candidates eligible for veterans' preference will be placed ahead of other candidates in the appropriate category for which they have been rated. Additionally, preference eligibles who have a compensable service-connected disability of at least 10 percent and who meet the minimum qualification requirements will automatically be placed in the best qualified category.

    Note: There is no provision for substitution of education for experience at grade GS-13.

    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 may be discussed during the interview process.

    Receiving Service Credit for Earning Annual (Vacation) Leave: Federal Employees earn annual leave at a rate (4, 6, 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.

    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. When promotion potential is shown, the agency is not making a commitment and is not obligated to provide future promotions to you if you are selected. Future promotions will be dependent on your ability to perform the duties at a higher level, the continuing need for an employee assigned to the higher level, and administrative approval.

    The Interagency Career Transition Assistance Plan (ICTAP) and Career Transition Assistance Plan (CTAP) provide eligible displaced Federal/VA competitive service employees with selection priority over other candidates for competitive service vacancies. To be qualified you must submit appropriate documentation (a copy of the agency notice, your most recent performance rating, and your most recent SF-50 noting current position, grade level, and duty location) and be found well-qualified (have a final rating of 85 or more) for this vacancy. Information about ICTAP and CTAP eligibility is on OPM's Career Transition Resources website at

    Read more

    You will be evaluated for this job based on how well you meet the qualifications above.


    Narrative responses are not required at this time. If you are referred for consideration, you may be asked to submit additional job related information, which may include, but not limited to; responses to the knowledge, skills and abilities; completion of a work sample, and/or contact for an interview.Your resume and/or supporting documentation will be verified. Please follow all instructions carefully. Errors or omissions may affect your rating or consideration for employment.

    Read more Security clearance Other

    Drug test required No

    Similar jobs

    More searches like this