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

Duties

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

Requirements

• 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, 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.

Contacts

• Address VBA Human Resources Center - Central Office 810 Vermont Ave NW Washington, DC 20420 US
• Name: HRC-Detroit DEU
• Phone: 313-596-7213
• Email: [email protected]