Occasional travel - You may be expected to travel for this position.
Relocation expenses reimbursed No
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.
- 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.
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: 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 http://www.opm.gov/policy-data-oversight/workforce-restructuring/employee-guide-to-career-transition/.
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.
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.