Summary This is a Direct Hire Authority (DHA) solicitation utilizing the DHA for AcqDemo Business and Technical Management Career Path (NH) About the Position: Serves as program analyst and is recognized as having extensive knowledge of the mission, functions, interrelationships, operating processes and force structure procedures internal to the AAW P&A Division and USAASC. Responsibilities Retrieves large amounts of career management and workforce data from various sources. Uses relational database concepts, star schema, class and object source data, tables, joins, dimensions, and measures (sum, count, average, maximum, minimum) to mine data, build reports and develop various dashboards. Uses visualization software (e.g. Power BI and Tableau) to visualize data in a clear, concise and actionable manner. Prepares ad hoc reports and analysis. Designs and maintains related key performance indicators. Develops the most efficient and effective automated approaches for presenting operational data and graphics required to satisfy various requirements. Uses systematic approaches to problem solving, recommending alternative courses of actions and implementation of innovative approaches to data mining and analysis. Identify problems and develop innovative solutions. Gather, analyze, and present facts. Requirements Conditions of Employment Qualifications Who May Apply: US Citizens In order to qualify, you must meet the experience requirements described below. 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; religious; spiritual; community; student; social). You will receive credit for all qualifying experience, including volunteer experience. Your resume must clearly describe your relevant experience; if qualifying based on education, your transcripts will be required as part of your application. Additional information about transcripts is in this document. I have one year of specialized experience equivalent to the GS-11/(NH-02) level in the Federal service which includes: 1) Retrieving large amounts of data from various sources utilizing Structured Query Language (SQL), Systems Applications Products (SAP) and using relational database concepts to mine data, build reports and develop various dashboards. 2) Using visualization software (e.g. Power BI and Tableau) to visualize data in a clear, concise and actionable manner. Capturing, integrating, organizing, visualizing and analyzing data using a variety of analysis software, data mining methods and statistical concepts. 3) Interfacing with leaders to understand and define crucial data requirements. 4) Developing standardized reporting formats for uniformity for regular and recurring reports, as well as a centralized storage source for maintaining historical data. This definition of specialized experience is typical of work performed at the next lower grade/level position in the federal service (NH-02 or GS-11). Education Additional Information Direct Deposit of Pay is required. Male applicants born after December 31, 1959, must complete a Pre-Employment Certification Statement for Selective Service Registration. You will be required to provide proof of U.S. Citizenship. Selection is subject to restrictions resulting from Department of Defense referral system for displaced employees. If you have retired from federal service and you are interested in employment as a reemployed annuitant, see the information in the Reemployed Annuitant information sheet. This is a(n) 36 Career Field position Multiple positions may be filled from this announcement. Salary includes applicable locality pay or Local Market Supplement. Payment of Permanent Change of Station (PCS) costs is not authorized, based on a determination that a PCS move is not in the Government interest.