Assistant Secretary for Public and Indian Housing Logo
Position Title
Program Analyst (Data Analyst)
Agency
Assistant Secretary for Public and Indian Housing
Announcement Number
24-HUD-1196 Opens in new window
Open Period
Wednesday, April 17, 2024 to Tuesday, April 30, 2024
For preview purposes only. To apply, please return to the USAJOBS announcement and click the Apply button.
Eligibilities
1. Do you claim Veterans’ Preference? (limit characters)
2. Are you a surplus or displaced Federal employee eligible under the Career Transition Assistance Plan (CTAP)?  Click CTAP for eligibility and a detailed list of required documents you must submit in order to be eligible.
 
(limit characters)
3. Are you a displaced Federal employee eligible under the Interagency Career Transition Assistance Plan (ICTAP)?  Click ICTAP for eligibility and a detailed list of required documents you must submit in order to be eligible.
 
(limit characters)
4. Are you a current Excepted Service employee of a Federal Agency covered by an OPM Interchange agreement that conveys noncompetitive eligibility?

For more information, review Interchange Agreements with Other Merit Systems.  https://www.opm.gov/policy-data-oversight/hiring-information/competitive-hiring/#url=InterchangeAgreementsWithOtherMeritSystems

To verify your eligibility, you must submit a copy of your Notification of Personnel Action, Standard Form (SF-50) reflecting your status. 
 
(limit characters)
5. Are you eligible for competitive consideration under any of the following merit promotion categories?
  • Current Federal civilian employee in the Competitive service on a permanent career or career-conditional appointment
  • Current Excepted service employee covered by an Interchange Agreement
  • Former Federal employee with Reinstatement eligibility
  • Veterans Employment Opportunities Act of 1998 (VEOA)
  • Current Federal employee serving on a VRA appointment
  • Land Management Employee eligible under Public Law 114-47
  • Other competitive category not listed above (you must submit proof of eligibility)
(limit characters)
6. Are you eligible to be appointed under the Military Spouse Noncompetitive Appointing Authority based on any of the following categories?
  • You are the spouse of an active duty member of the Armed Forces.
  • You are the spouse of a member of the Armed Forces who retired with a disability rating at the time of retirement of 100 percent or the spouse of a member of the Armed Forces who retired or separated from the Armed Forces and has a disability rating of 100 percent from the Department of Veterans Affairs.
  • You are the widow or widower of a member of the Armed Forces killed while in active duty status, and you have not re-married.
For more information, review USAJOBS Veterans resources. (https://www.usajobs.gov/Veterans)
 
(limit characters)
7. Are you a former federal employee that has been separated for at least one full year and is eligible to be non-competitively reinstated to a higher grade or full-performance level than which you left federal employment?
(Note: you MUST provide:  1) a copy of your separation SF-50 (the "position occupied" block on the SF-50 should show a "1" and your "tenure" block should show a "1" or "2"); AND 2) the last performance appraisal you received from your federal employment which shows at least a fully successful rating.)
 
(limit characters)
8. Do you currently hold (or have you previously held) on a permanent basis, a position in the competitive service (or in another merit system with which OPM has an interchange agreement), with promotion potential equivalent to (or higher than) the full performance level of the position advertised in this vacancy announcement?
 
(limit characters)
9. Are you eligible under any other miscellaneous appointing authority not listed thus far, such as (but not all inclusive to):
  • Postal Career Service Employee;
  • Postal Rate Commission Employee;
  • Government Accountability Office (GAO) Employee; 
  • Administrative Office of the U.S. Courts Employee; or 
  • Foreign overseas employee or eligible family member of former overseas employee
 For more information, review Miscellaneous Authorities Not Regulated By U.S. Office of Personnel Management.  https://www.opm.gov/policy-data-oversight/hiring-information/competitive-hiring/#url=MiscellaneousAuthoritiesNotRegulated .  To verify your eligibility, you must submit a copy of your Notification of Personnel Action, Standard Form (SF-50) reflecting your status. 

For more information on Foreign overseas employment please review the following: https://www.opm.gov/policy-data-oversight/hiring-information/competitive-hiring/#NontemporaryForeignService or https://www.state.gov/global-community-liaison-office/family-member-employment/family-member-employment-in-the-d-c-area/non-competitive-eligibility-nce/#NCE5
(limit characters)
10. Are you eligible for consideration as a Peace Corps, VISTA, or Action volunteer?  If you select this option, you are required to provide acceptable documentation of your appointment eligibility by submitting proof of employment from the appropriate agency with your completed application.
National Service (Peace Corps and VISTA)
 
(limit characters)
11. Do you have a severe physical, psychiatric or mental disability that qualifies you for a Schedule A Disability appointment?

For more information, review USAJOBS Individuals with Disabilities resources.

To verify your eligibility, you must provide appropriate medical documentation, i.e., a letter signed by a licensed medical professional or licensed vocational rehabilitation specialist stating your condition and restrictions.
 
(limit characters)
Preferences
1. Select the location(s) you want to be considered for. You must choose at least one location. (limit characters)
2. Are you currently serving or have served in the last five years in a Political Appointment in the Federal Government? (limit characters)
3. If you were born a male after December 31, 1959, and are at least 18 years of age, have you registered with the Selective Service System (select "Not applicable" if this question does not apply to you)? (limit characters)
4. Are you a current Federal employee? (limit characters)
5. If you are, or ever were a Federal civilian employee, indicate the pay plan and grade level or pay band of the highest graded position you have ever held. (limit 250 characters)
6. I am interested in having my application shared with other HUD hiring managers. I understand that electing this option will not impact my chances of selection from this vacancy announcement and does not guarantee that a similar vacancy announcement will be opened by another hiring manager for which I can be considered or selected. Please select one or more of the following HUD Program Offices that you authorize to receive your application information. If you do not wish for your application to be shared, please select "Please do not share my application information with other HUD hiring managers. (limit characters)
Performance Appraisal
1. As outlined in the vacancy announcement, you must submit a copy of all pages of your most recent completed annual performance appraisal, dated within the last 12 months, that includes the final rating. If you have not submitted an appraisal meeting these specific requirements, you must explain why you are unable to do so in the next question. If you do not provide a copy of the performance appraisal, or a statement advising why it is unavailable, you will be removed from further consideration. If you are unable to provide a performance appraisal with your application, you will need to provide a reason in the text box below.

(Note: If you answer "NO" to this question, you must provide a reason as to why you were not able to provide a performance appraisal in the text box of the following question)

Have you submitted a copy of all pages of your most recent completed annual performance appraisal, dated within the last 12 months, that includes the final rating?
(limit characters)
2. If you answered "NO" to the previous question, please provide a reason as to why you were not able to provide a performance appraisal in the text box below. (limit characters)
Assessment 1
Specialized Experience for the GS-14 level: To be qualified for this position at the GS-14 level, you must have at least one year of specialized experience equivalent to the GS-13 level. This experience is defined as:

Developing IT solutions using Microsoft Power Platform (i.e., PowerApps, Power Automate, PowerBI), VBA, Relational Databases (preferably Oracle), ETL, SQL, PL/SQL, and analyzing data to answer critical policy and business questions using data management tools and techniques.

Examples of such experience could include:
-Developing data-driven analytical reports and presenting that data to management; OR
- Addressing data anomalies, modelling and analyzing large volumes of financial and programmatic data, and applying analytical and problem-solving techniques to identify trends and issues, develop solutions, and make forecasts;
OR
-Designing business systems and processes, using modern technologies (i.e., Microsoft Power Platform, Relational Databases, Access, VBA, Excel, Python) and techniques, to manage data and produce value-added programmatic insight.
(limit characters)
Select “Yes” or “No” to the following question(s). (limit characters)
1. Do you meet the specialized experience as described above? (limit characters)
2. Make sure experience is clearly documented in your resume. Please give the dates/resume reference when you gained this experience so it may be found to ensure you receive proper credit. (limit 250 characters)
3. Select the response(s) that demonstrate(s) techniques you have used on the job generating a range of complex reports and data presentations. Select all that apply. (limit characters)
4. What experience do you have regarding modeling, managing, and analyzing large volumes of financial data? (Select all that apply) (limit characters)
5. What tasks have you performed to modernize a database system? (limit characters)
6. Please select the statement(s) that describe your experience(s) gathering and evaluating information and data. Select all that apply. (limit characters)
7. Which activities have you performed to identify relationships or trends in the information you review at work? (limit characters)
8. What tasks have you performed while solving problems? (limit characters)
9. Choose the statement below that best represents your experience generating alternatives to solve problems when precedents did not exist? (limit characters)
10. For which purposes or goals have you prepared written materials? (limit characters)
11. Select the response(s) that best describes your oral communication experience. (limit characters)
12. Whom have you interviewed to collect information about a program? (limit characters)
13. Select the documents you have independently written in a professional setting? (limit characters)
14. For which audiences have you authored written material? (limit characters)
15. Which types of software have you used to collect and disseminate information to an internal working group (Select all that apply)? (limit characters)
16. Which types of software have you used for analyzing and presenting data (Check all that apply)? (limit characters)
17. Which types of tools or programming languages have you used to manipulate or extract, transform, and load data (Select all that apply)? (limit characters)
18. Which functions have you used to process data within spreadsheet software (e.g., Microsoft Excel)? (limit characters)
19. Which types of software programs have you used in your work? (limit characters)
20. Which statement best describes your highest level of experience manipulating data with an automated data processing system (e.g., SQL Server, Oracle Database, MySQL)? (limit characters)