Skip to main content

Grade: 12

1 GS-12 Choose the answer that best describes your experience: Answer to this question is required
  • 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.
  • 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? Answer to this question is required
  • Yes
  • No
3 Which statement describes your highest level of experience manipulating data sets to extract business insights. Answer to this question is required
  • I do not have experience manipulating data sets to extract business insights.
  • I identified data sets from the same system and connected elements that I used to manipulate the data in order perform business analysis.
  • I modified source system data by the addition of computed items or other elements/techniques to enable business analysis.
  • I extracted data sets from an existing database to withdraw relevant data for business analysis.
  • I extracted data sets and modified the format of data elements (text, dates, etc.) in order to perform business analysis.
  • I extracted data sets from separate source systems, identified connecting elements and manipulated the data in order perform business analysis.
  • 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. Answer to this question is required
  • Clearly articulated the business problem/question
  • Described the sample population
  • Described the assumptions
  • Described the source systems for the data sets
  • Described the methodology for the data extraction and manipulation
  • Described observations about the data sets using charts and graphs
  • Described observations about the data sets in writing
  • Described how manipulation & extraction methodologies impacted data trends
  • Described the policies and processes that have affected the data
  • Described the characteristics of the source systems for data
  • None of the above
5 Describe your experience managing a reporting system. Answer to this question is required
  • I helped customers identify and articulate business drivers required to design and develop a reporting system.
  • I helped customers define and design new reports/dashboards tied to business needs.
  • I helped customers modify existing reports/dashboards or features to align with business needs.
  • I used existing reports, dashboards and metrics to monitor business performance.
  • I helped customers build metrics in a reporting system for data coming from multiple sources in non-complimentary formats.
  • I helped customers decide whether a report or a dashboard could be most effective.
  • I modified existing reports/dashboards and/or metrics to improve alignment to business objectives.
  • I developed report/dashboard mock-ups based on customer input.
  • I suggested new applications/views of business data to exceed customer requirements, based on my knowledge of technology capabilities.
  • I performed root cause analysis on bad report/dashboard output and determine whether errors were in source systems or data base/warehouse.
  • 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? Answer to this question is required
  • I do not have experience with data warehouse administration and management.
  • I defined administration and management processes and policies to maximize business efficiency and effectiveness based on best practices.
  • I identified and implemented changes to established administration and management processes and policies within a business function for increased organizational efficiency.
  • I defined administration and management processes and policies for a reporting warehouse based on input from business analysts.
  • I helped business analysts develop their own administration and management processes and policies within a business function based on my knowledge of best practices.
  • I defined administration and management processes and policies to support IT security, data integrity and/or performance efficiency.
  • I identified and implemented changes to established administration and management processes and policies within and IT function to support data warehouse performance for customers.
  • I oversaw adherence to established administration and management processes and policies for an IT or business function to maintain organizational efficiency.
  • 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. Answer to this question is required
  • Extracting data from databases for external analysis (e.g. exporting to Excel for pivoting).
  • Developing custom queries in SQL, MySQL, Oracle, etc.
  • Administering/maintaining Enterprise-level database.
  • Designing database architecture for optimal data management.
  • Modifying existing database architecture to enhance suboptimal data management.
  • None of the above.
8 In reference to your experience working with teams, have you: Answer to this question is required
  • Participated as a member of a team with people of similar skills, technical competencies, disciplines, and level in the organization.
  • Participated as a member of a cross-functional team where persons of different backgrounds, technical competencies, disciplines, and levels within the organization came together.
  • Facilitated a team made up of people with similar skills, technical competencies, disciplines, and level in the organization.
  • Facilitated a cross-functional team where persons of different backgrounds, technical competencies, disciplines, and levels within the organization came together.
  • Led a team with people of similar skills, technical competencies, disciplines, and level in the organization.
  • Led a cross-functional team where persons of different backgrounds, technical competencies, disciplines, and levels within the organization came together.
  • Recommended the makeup of a team of people with similar skills, technical competencies, disciplines, and level in the organization to management.
  • Recommended the makeup of a cross-functional team to management.
  • Formally evaluated the progress of a team with people of similar skills, technical competencies, disciplines, and level in the organization.
  • Formally evaluated the progress of a cross-functional team where persons of different backgrounds, technical competencies, disciplines, and levels within the organization came together.
  • 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): Answer to this question is required
  • Position Classification and Position Management
  • Recruitment
  • Executive Recruitment
  • Staffing
  • Human Resources Information Systems
  • Employee Benefits
  • Labor Relations
  • Compensation
  • Performance Management
  • Employee Relations
  • Workforce Planning/Analysis
  • Training and Employee Development
  • Human Resources Policy Development
  • Human Capital Strategic Planning
  • None of the above
10 Which of the following computer applications / automated human resource systems / data analysis packages have you had experience with? Answer to this question is required
  • Microsoft Excel
  • Microsoft Access
  • SPSS
  • STATA
  • SAS
  • Cognos
  • Hyperion (formerly BRIO)
  • QuickHire
  • FPPS
  • Other automated recruitment systems
  • Other automated personnel / payroll systems
  • Other statistical / data analysis applications
  • An automated classification system
  • None of the above

Grade: 13

1 GS-13 Choose the answer that best describes your experience: Answer to this question is required
  • 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.
  • 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? Answer to this question is required
  • Yes
  • No
3 Which statement describes your highest level of experience manipulating data sets to extract business insights. Answer to this question is required
  • I do not have experience manipulating data sets to extract business insights.
  • I identified data sets from the same system and connected elements that I used to manipulate the data in order perform business analysis.
  • I modified source system data by the addition of computed items or other elements/techniques to enable business analysis.
  • I extracted data sets from an existing database to withdraw relevant data for business analysis.
  • I extracted data sets and modified the format of data elements (text, dates, etc.) in order to perform business analysis.
  • I extracted data sets from separate source systems, identified connecting elements and manipulated the data in order perform business analysis.
  • 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. Answer to this question is required
  • Clearly articulated the business problem/question
  • Described the sample population
  • Described the assumptions
  • Described the source systems for the data sets
  • Described the methodology for the data extraction and manipulation
  • Described observations about the data sets using charts and graphs
  • Described observations about the data sets in writing
  • Described how manipulation & extraction methodologies impacted data trends
  • Described the policies and processes that have affected the data
  • Described the characteristics of the source systems for data
  • None of the above
5 Describe your experience managing a reporting system. Answer to this question is required
  • I helped customers identify and articulate business drivers required to design and develop a reporting system.
  • I helped customers define and design new reports/dashboards tied to business needs.
  • I helped customers modify existing reports/dashboards or features to align with business needs.
  • I used existing reports, dashboards and metrics to monitor business performance.
  • I helped customers build metrics in a reporting system for data coming from multiple sources in non-complimentary formats.
  • I helped customers decide whether a report or a dashboard could be most effective.
  • I modified existing reports/dashboards and/or metrics to improve alignment to business objectives.
  • I developed report/dashboard mock-ups based on customer input.
  • I suggested new applications/views of business data to exceed customer requirements, based on my knowledge of technology capabilities.
  • I performed root cause analysis on bad report/dashboard output and determine whether errors were in source systems or data base/warehouse.
  • 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? Answer to this question is required
  • I do not have experience with data warehouse administration and management.
  • I defined administration and management processes and policies to maximize business efficiency and effectiveness based on best practices.
  • I identified and implemented changes to established administration and management processes and policies within a business function for increased organizational efficiency.
  • I defined administration and management processes and policies for a reporting warehouse based on input from business analysts.
  • I helped business analysts develop their own administration and management processes and policies within a business function based on my knowledge of best practices.
  • I defined administration and management processes and policies to support IT security, data integrity and/or performance efficiency.
  • I identified and implemented changes to established administration and management processes and policies within and IT function to support data warehouse performance for customers.
  • I oversaw adherence to established administration and management processes and policies for an IT or business function to maintain organizational efficiency.
  • 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. Answer to this question is required
  • Extracting data from databases for external analysis (e.g. exporting to Excel for pivoting).
  • Developing custom queries in SQL, MySQL, Oracle, etc.
  • Administering/maintaining Enterprise-level database.
  • Designing database architecture for optimal data management.
  • Modifying existing database architecture to enhance suboptimal data management.
  • None of the above.
8 In reference to your experience working with teams, have you: Answer to this question is required
  • Participated as a member of a team with people of similar skills, technical competencies, disciplines, and level in the organization.
  • Participated as a member of a cross-functional team where persons of different backgrounds, technical competencies, disciplines, and levels within the organization came together.
  • Facilitated a team made up of people with similar skills, technical competencies, disciplines, and level in the organization.
  • Facilitated a cross-functional team where persons of different backgrounds, technical competencies, disciplines, and levels within the organization came together.
  • Led a team with people of similar skills, technical competencies, disciplines, and level in the organization.
  • Led a cross-functional team where persons of different backgrounds, technical competencies, disciplines, and levels within the organization came together.
  • Recommended the makeup of a team of people with similar skills, technical competencies, disciplines, and level in the organization to management.
  • Recommended the makeup of a cross-functional team to management.
  • Formally evaluated the progress of a team with people of similar skills, technical competencies, disciplines, and level in the organization.
  • Formally evaluated the progress of a cross-functional team where persons of different backgrounds, technical competencies, disciplines, and levels within the organization came together.
  • 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): Answer to this question is required
  • Position Classification and Position Management
  • Recruitment
  • Executive Recruitment
  • Staffing
  • Human Resources Information Systems
  • Employee Benefits
  • Labor Relations
  • Compensation
  • Performance Management
  • Employee Relations
  • Workforce Planning/Analysis
  • Training and Employee Development
  • Human Resources Policy Development
  • Human Capital Strategic Planning
  • None of the above
10 Which of the following computer applications / automated human resource systems / data analysis packages have you had experience with? Answer to this question is required
  • Microsoft Excel
  • Microsoft Access
  • SPSS
  • STATA
  • SAS
  • Cognos
  • Hyperion (formerly BRIO)
  • QuickHire
  • FPPS
  • Other automated recruitment systems
  • Other automated personnel / payroll systems
  • Other statistical / data analysis applications
  • An automated classification system
  • None of the above

Grade: All Grades

No specific questions.