Program Analyst

Summary

This position is located in the Department of Veterans Affairs, Office of Performance Analysis and Integrity (PA&I), aligned to VBA's Chief of Staff. The candidate provides support in developing accurate reporting solutions using their experience in data analytics, relational database technologies and ETL tools such as Informatica and Oracle PL/SQL and SQL. Additionally, the candidate provides status updates on the projects and data architecture enhancements.

Learn more about this agency

Help

Overview

• Accepting applications

• Open & closing dates

06/18/2024 to 06/25/2024

• Salary

$112,015 - $145,617 per year

• Pay scale & grade

GS 13

• Help

Location

2 vacancies in the following location:

• Washington, DC

• Remote job

No

• Telework eligible

Yes-as determined by the agency policy.

• Travel Required

Not required

• Relocation expenses reimbursed

No

• Appointment type

Permanent

• Work schedule

Full-time

• Regular office hours, Monday

• Friday, 8:00 AM - 4:30 PM. Alternate work Schedules may be available.

• Service

Competitive

• Promotion potential

13

• Job family (Series)

0343 Management And Program Analysis

• Supervisory status

No

• Security clearance

Other

• Drug test

No

• Position sensitivity and risk

Noncritical-Sensitive (NCS)/Moderate Risk

• Trust determination process

Suitability/Fitness

• Announcement number

CASK-12422336-24-MS

• Control number

796239300

Help

This job is open to

• The public

U.S. Citizens, Nationals or those who owe allegiance to the U.S.

Clarification from the agency

All U.S. Citizens

Help

Duties

• Database modeling, including data mart design, data cataloging management, and meta-data management in a Data Warehouse Environments

• Provide Leadership with status updates on the projects and data architecture enhancements.

• Assist in planning, coordination, and implementation of data marts and data architecture solutions supporting the Enterprise Data Warehouse Database internal and external partners.

• Create an optimal EDW data architecture design through data analysis and requirements elicitation.

• Collaborate with end users and contractor to identify needs and opportunities for improved data management and delivery.

• Develop end to end data warehousing solutions involving Informatica ETL, PL/SQL, SQL, Shell Scripting development and front end visualization with Power BI, OBIEE or Tableau.

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.

• 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, 06/25/2024.

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:

GS-13: Applicants must have one (1) year of specialized experience equivalent to at least the next lower grade (GS-12) in the federal service. Specialized experience is work experience that equipped the applicant with the knowledge, skills and abilities (KSA's) to perform successfully the duties of the position. Specialized experience for this position is defined as: 1) Developing end to end data warehousing solutions involving Informatica ETL development and front-end visualization with Power BI, OBIEE or Tableau; AND 2) Communicating, problem-solving, and analytic abilities as required to perform job tasks.

There is no educational substitution for this GS-13 level position.

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

An unofficial or official copy of your transcripts must be submitted with your application if you are basing all or part of your qualifications on education.

Note: Only education or degrees recognized by the U.S. Department of Education from accredited colleges, universities, schools, or institutions may be used to qualify for Federal employment. You can verify your education: http://ope.ed.gov/accreditation/

If you are using foreign education to meet qualification requirements, you must send a Certificate of Foreign Equivalency with your transcript in order to receive credit for that education. For further information, visit: https://www2.ed.gov/about/offices/list/ous/international/usnei/us/edlite-visitus-forrecog.html

Additional information

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.

Physical Requirements: The work is sedentary.

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-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. Telework is subject to approval by individual supervisors and managers, is considered a privilege not a right, is subject to approval based on performance and other varying factors, and is not guaranteed.

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.

Read more

• Benefits

Help

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 window

Learn more about federal benefits.

Review our 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.

If you are referred for consideration you will be rated on the following competencies (knowledge, skills and abilities) based on your application for this position:

• Data Management

• Decision Making

• Information Technology Performance Assessment

• Problem Solving

You may be asked to submit additional job related information, which may include responses to the knowledge, skills and abilities identified in the announcement; and/or completion of a work sample; and/or 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.

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.