This position is located in the Department of Veterans Affairs, Veterans Benefits Administration (VBA), Office of Performance Analysis and Integrity (PA&I), on the Data Warehouse Team.

Duties

SPECIFIC DUTIES INCLUDE: A. Develop complex queries, reports, dashboards, and designing report formats, prototyping, developing code, testing, and implementing in the production environment. B. Serves as the subject-matter-expert and assists in the planning, coordination, and implementation of the operation and maintenance of Enterprise Data Warehouse databases. C. Assist in planning, coordination, and implementation of data marts and data architecture solutions supporting the Enterprise Data Warehouse Database internal and external partners. D. 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 E. Collaborate with end users and contractor to identify needs and opportunities for improved data management and delivery. Work Schedule: Full time, Monday through Friday Compressed/Flexible: Available. Telework: Available per agency and program policies. Virtual: This is not a virtual position. Position Description/PD#: Senior Program Analyst; 30178A Relocation/Recruitment Incentives: Not Authorized. Financial Disclosure Report: Not Required.

Requirements

• Subject to background/security investigation
• 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

Qualifications

To qualify for this position, applicants must meet all requirements by the closing date of this announcement:12/17/2023. TIME-IN-GRADE REQUIREMENT: Applicants who are current Federal employees and have held a GS grade any time in the past 52 weeks must also meet time-in-grade requirements. To verify your eligibility, you must submit a copy of your most recent Notification of Personnel Action, Standard Form 50 (SF-50). The grade may have been in any occupation, but must have been held in the Federal service. You must provide a copy of your most recent SF-50 that indicates proof of status, and shows Time in Grade (for example, you were a career or career-conditional employee) and identifies your position title, series, grade, step, salary, tenure, and type of service (Competitive or Excepted). If the most recent SF-50 has an effective date within the past year, it may not clearly demonstrate you possess one-year time-in-grade, as required by the announcement. In this instance, you must also submit your most recent promotion or within-grade increase in addition to your recent SF-50. If you previously held a higher grade, you must also submit any SF-50 showing that grade. DO NOT submit Award SF-50's and/or General Adjustment SF-50's as they cannot be used to prove time-in-grade. For a GS-14 position you must have served 52 weeks at the GS-13 level. MINIMUM QUALIFICATION REQUIREMENT: You may qualify based on your experience as described below: GS-14 Grade Level: Specialized Experience: As a Senior Extract Transform Load (ETL) Developer, candidate must demonstrate proficiency using Informatica PowerCenter to develop mappings, Workflow Manger to create tasks and workflows, and Workflow Monitor to monitor the workflows. The candidate must understand dimensional modeling and star schemas to include, collecting and documenting requirements from business users, designing dimension and fact tables, developing ETL processes, and supporting front end reports. The candidate must have experience in Oracle Database and Informatica ETL performance tuning approaches in Data Warehouse Environments. Additionally, the candidate must have experience building BI solutions in OBIEE, PowerBI, C Sharp or Apex. Education Substitution: There is no educational substitution at the GS-14 grade level. Volunteer Experience: 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. Full vs. Part-Time Employment: Full-time employment is considered to be at least 35 hours per week. Part-time experience will be credited on a pro-rated basis; when including part-time employment in your resume you must specify the average hours worked per week. Physical Requirements: The work is sedentary, although some slight physical effort may be required. For more information on these qualification standards, please visit the United States Office of Personnel Management's website at http://://www.opm.gov/policy-data-oversight/classification-qualifications/general-schedule-qualification-standards/.

Education

There is no educational substitute at the GS-14 grade level.

Contacts

• Address VBA Human Resources Center - Central Office 810 Vermont Ave NW Washington, DC 20420 US
• Name: Martin Manchev
• Email: [email protected]