Skip Navigation

Vacancy Questions Preview

Vacancy Questions Preview

Grade: 12
* 1.GS-12 Choose the answer that best describes your experience:
  1. I possess 1 year of specialized experience equivalent to the GS-11 level. Examples of this experience include: identifying, analyzing, and making recommendations to resolve conventional problems and situations in work-flow, work distribution, staffing, performance appraisal, organizational structure, and/or administration; analyzing and making recommendations concerning the efficiency and productivity of administrative operations in a component of an organization.
  2. I do not meet the requirements as described above.


* 2.Do you have experience utilizing statistical sampling and modeling to identify data sets and utilize statistical software (SPSS, SAS, MATLAB, STATISTICA, Minitab and/or Microsoft Excel add-ons such as Analyse-it, SigmaXL, etc.) for analyzing large and complex data sets to identify correlations and perform causal analyses?
  1. Yes
  2. No


* 3.Which statement describes your highest level of experience manipulating data sets to extract business insights.
  1. I do not have experience manipulating data sets to extract business insights.
  2. I identified data sets from the same system and connected elements that I used to manipulate the data in order perform business analysis.
  3. I modified source system data by the addition of computed items or other elements/techniques to enable business analysis.
  4. I extracted data sets from an existing database to withdraw relevant data for business analysis.
  5. I extracted data sets and modified the format of data elements (text, dates, etc.) in order to perform business analysis.
  6. I extracted data sets from separate source systems, identified connecting elements and manipulated the data in order perform business analysis.
  7. I integrated qualitative data sets (survey, interview data, etc.) with quantitative data sets from one or more systems in order to perform business analysis.


* 4.Select the five activities below that you view as the most important to the analyses you present. Be prepared to provide specific detailed examples of analyses you have completed if you are called for an interview.
  1. Clearly articulated the business problem/question
  2. Described the sample population
  3. Described the assumptions
  4. Described the source systems for the data sets
  5. Described the methodology for the data extraction and manipulation
  6. Described observations about the data sets using charts and graphs
  7. Described observations about the data sets in writing
  8. Described how manipulation & extraction methodologies impacted data trends
  9. Described the policies and processes that have affected the data
  10. Described the characteristics of the source systems for data
  11. None of the above


* 5.Describe your experience managing a reporting system.
  1. I helped customers identify and articulate business drivers required to design and develop a reporting system.
  2. I helped customers define and design new reports/dashboards tied to business needs.
  3. I helped customers modify existing reports/dashboards or features to align with business needs.
  4. I used existing reports, dashboards and metrics to monitor business performance.
  5. I helped customers build metrics in a reporting system for data coming from multiple sources in non-complimentary formats.
  6. I helped customers decide whether a report or a dashboard could be most effective.
  7. I modified existing reports/dashboards and/or metrics to improve alignment to business objectives.
  8. I developed report/dashboard mock-ups based on customer input.
  9. I suggested new applications/views of business data to exceed customer requirements, based on my knowledge of technology capabilities.
  10. I performed root cause analysis on bad report/dashboard output and determine whether errors were in source systems or data base/warehouse.
  11. I do not have any experience managing a reporting system.


* 6.Which statement describes your highest level of experience with data warehouse administration and management?
  1. I do not have experience with data warehouse administration and management.
  2. I defined administration and management processes and policies to maximize business efficiency and effectiveness based on best practices.
  3. I identified and implemented changes to established administration and management processes and policies within a business function for increased organizational efficiency.
  4. I defined administration and management processes and policies for a reporting warehouse based on input from business analysts.
  5. I helped business analysts develop their own administration and management processes and policies within a business function based on my knowledge of best practices.
  6. I defined administration and management processes and policies to support IT security, data integrity and/or performance efficiency.
  7. I identified and implemented changes to established administration and management processes and policies within and IT function to support data warehouse performance for customers.
  8. I oversaw adherence to established administration and management processes and policies for an IT or business function to maintain organizational efficiency.
  9. I followed existing administration and management processes and policies for a reporting warehouse ensuring alignment with business objectives.


* 7.Select the highest level of experience you have with relationship databases.
  1. Extracting data from databases for external analysis (e.g. exporting to Excel for pivoting).
  2. Developing custom queries in SQL, MySQL, Oracle, etc.
  3. Administering/maintaining Enterprise-level database.
  4. Designing database architecture for optimal data management.
  5. Modifying existing database architecture to enhance suboptimal data management.
  6. None of the above.


* 8.In reference to your experience working with teams, have you:
  1. Participated as a member of a team with people of similar skills, technical competencies, disciplines, and level in the organization.
  2. Participated as a member of a cross-functional team where persons of different backgrounds, technical competencies, disciplines, and levels within the organization came together.
  3. Facilitated a team made up of people with similar skills, technical competencies, disciplines, and level in the organization.
  4. Facilitated a cross-functional team where persons of different backgrounds, technical competencies, disciplines, and levels within the organization came together.
  5. Led a team with people of similar skills, technical competencies, disciplines, and level in the organization.
  6. Led a cross-functional team where persons of different backgrounds, technical competencies, disciplines, and levels within the organization came together.
  7. Recommended the makeup of a team of people with similar skills, technical competencies, disciplines, and level in the organization to management.
  8. Recommended the makeup of a cross-functional team to management.
  9. Formally evaluated the progress of a team with people of similar skills, technical competencies, disciplines, and level in the organization.
  10. Formally evaluated the progress of a cross-functional team where persons of different backgrounds, technical competencies, disciplines, and levels within the organization came together.
  11. I have not functioned in any of the roles mentioned.


* 9.Select the human capital areas where you have had personal and direct experience providing advice or guidance to customers (such as managers, administrative officers, selecting officials, applicants, employees, union officials, etc):
  1. Position Classification and Position Management
  2. Recruitment
  3. Executive Recruitment
  4. Staffing
  5. Human Resources Information Systems
  6. Employee Benefits
  7. Labor Relations
  8. Compensation
  9. Performance Management
  10. Employee Relations
  11. Workforce Planning/Analysis
  12. Training and Employee Development
  13. Human Resources Policy Development
  14. Human Capital Strategic Planning
  15. None of the above


* 10.Which of the following computer applications / automated human resource systems / data analysis packages have you had experience with?
  1. Microsoft Excel
  2. Microsoft Access
  3. SPSS
  4. STATA
  5. SAS
  6. Cognos
  7. Hyperion (formerly BRIO)
  8. QuickHire
  9. FPPS
  10. Other automated recruitment systems
  11. Other automated personnel / payroll systems
  12. Other statistical / data analysis applications
  13. An automated classification system
  14. None of the above


Grade: 13
* 1.GS-13 Choose the answer that best describes your experience:
  1. I possess 1 year of specialized experience equivalent to the GS-12 level. Examples of this experience include: planning, scheduling, and conducting projects and studies to assess the effectiveness and efficiency of program operations; establishing criteria to measure and/or predict the attainment of program or organizational goals and objectives; developing administrative regulations, such as those governing the allocation and distribution of personnel, supplies, equipment, and other resources.
  2. I do not meet the requirements as described above.


* 2.Do you have experience utilizing statistical sampling and modeling to identify data sets and utilize statistical software (SPSS, SAS, MATLAB, STATISTICA, Minitab and/or Microsoft Excel add-ons such as Analyse-it, SigmaXL, etc.) for analyzing large and complex data sets to identify correlations and perform causal analyses?
  1. Yes
  2. No


* 3.Which statement describes your highest level of experience manipulating data sets to extract business insights.
  1. I do not have experience manipulating data sets to extract business insights.
  2. I identified data sets from the same system and connected elements that I used to manipulate the data in order perform business analysis.
  3. I modified source system data by the addition of computed items or other elements/techniques to enable business analysis.
  4. I extracted data sets from an existing database to withdraw relevant data for business analysis.
  5. I extracted data sets and modified the format of data elements (text, dates, etc.) in order to perform business analysis.
  6. I extracted data sets from separate source systems, identified connecting elements and manipulated the data in order perform business analysis.
  7. I integrated qualitative data sets (survey, interview data, etc.) with quantitative data sets from one or more systems in order to perform business analysis.


* 4.Select the five activities below that you view as the most important to the analyses you present. Be prepared to provide specific detailed examples of analyses you have completed if you are called for an interview.
  1. Clearly articulated the business problem/question
  2. Described the sample population
  3. Described the assumptions
  4. Described the source systems for the data sets
  5. Described the methodology for the data extraction and manipulation
  6. Described observations about the data sets using charts and graphs
  7. Described observations about the data sets in writing
  8. Described how manipulation & extraction methodologies impacted data trends
  9. Described the policies and processes that have affected the data
  10. Described the characteristics of the source systems for data
  11. None of the above


* 5.Describe your experience managing a reporting system.
  1. I helped customers identify and articulate business drivers required to design and develop a reporting system.
  2. I helped customers define and design new reports/dashboards tied to business needs.
  3. I helped customers modify existing reports/dashboards or features to align with business needs.
  4. I used existing reports, dashboards and metrics to monitor business performance.
  5. I helped customers build metrics in a reporting system for data coming from multiple sources in non-complimentary formats.
  6. I helped customers decide whether a report or a dashboard could be most effective.
  7. I modified existing reports/dashboards and/or metrics to improve alignment to business objectives.
  8. I developed report/dashboard mock-ups based on customer input.
  9. I suggested new applications/views of business data to exceed customer requirements, based on my knowledge of technology capabilities.
  10. I performed root cause analysis on bad report/dashboard output and determine whether errors were in source systems or data base/warehouse.
  11. I do not have any experience managing a reporting system.


* 6.Which statement describes your highest level of experience with data warehouse administration and management?
  1. I do not have experience with data warehouse administration and management.
  2. I defined administration and management processes and policies to maximize business efficiency and effectiveness based on best practices.
  3. I identified and implemented changes to established administration and management processes and policies within a business function for increased organizational efficiency.
  4. I defined administration and management processes and policies for a reporting warehouse based on input from business analysts.
  5. I helped business analysts develop their own administration and management processes and policies within a business function based on my knowledge of best practices.
  6. I defined administration and management processes and policies to support IT security, data integrity and/or performance efficiency.
  7. I identified and implemented changes to established administration and management processes and policies within and IT function to support data warehouse performance for customers.
  8. I oversaw adherence to established administration and management processes and policies for an IT or business function to maintain organizational efficiency.
  9. I followed existing administration and management processes and policies for a reporting warehouse ensuring alignment with business objectives.


* 7.Select the highest level of experience you have with relationship databases.
  1. Extracting data from databases for external analysis (e.g. exporting to Excel for pivoting).
  2. Developing custom queries in SQL, MySQL, Oracle, etc.
  3. Administering/maintaining Enterprise-level database.
  4. Designing database architecture for optimal data management.
  5. Modifying existing database architecture to enhance suboptimal data management.
  6. None of the above.


* 8.In reference to your experience working with teams, have you:
  1. Participated as a member of a team with people of similar skills, technical competencies, disciplines, and level in the organization.
  2. Participated as a member of a cross-functional team where persons of different backgrounds, technical competencies, disciplines, and levels within the organization came together.
  3. Facilitated a team made up of people with similar skills, technical competencies, disciplines, and level in the organization.
  4. Facilitated a cross-functional team where persons of different backgrounds, technical competencies, disciplines, and levels within the organization came together.
  5. Led a team with people of similar skills, technical competencies, disciplines, and level in the organization.
  6. Led a cross-functional team where persons of different backgrounds, technical competencies, disciplines, and levels within the organization came together.
  7. Recommended the makeup of a team of people with similar skills, technical competencies, disciplines, and level in the organization to management.
  8. Recommended the makeup of a cross-functional team to management.
  9. Formally evaluated the progress of a team with people of similar skills, technical competencies, disciplines, and level in the organization.
  10. Formally evaluated the progress of a cross-functional team where persons of different backgrounds, technical competencies, disciplines, and levels within the organization came together.
  11. I have not functioned in any of the roles mentioned.


* 9.Select the human capital areas where you have had personal and direct experience providing advice or guidance to customers (such as managers, administrative officers, selecting officials, applicants, employees, union officials, etc):
  1. Position Classification and Position Management
  2. Recruitment
  3. Executive Recruitment
  4. Staffing
  5. Human Resources Information Systems
  6. Employee Benefits
  7. Labor Relations
  8. Compensation
  9. Performance Management
  10. Employee Relations
  11. Workforce Planning/Analysis
  12. Training and Employee Development
  13. Human Resources Policy Development
  14. Human Capital Strategic Planning
  15. None of the above


* 10.Which of the following computer applications / automated human resource systems / data analysis packages have you had experience with?
  1. Microsoft Excel
  2. Microsoft Access
  3. SPSS
  4. STATA
  5. SAS
  6. Cognos
  7. Hyperion (formerly BRIO)
  8. QuickHire
  9. FPPS
  10. Other automated recruitment systems
  11. Other automated personnel / payroll systems
  12. Other statistical / data analysis applications
  13. An automated classification system
  14. None of the above






This is a Federal job application system. Providing false information, creating fake IDs, or failing to answer all questions truthfully and completely may be grounds for not hiring, for disbarment from Federal employment, or for dismissal after the applicant begins work. Falsifying a Federal job application, attempting to violate the privacy of others, or attempting to compromise the operation of this system may be punishable by fine or imprisonment (US Code, Title 18, section 1001).