Skip Navigation

Vacancy Questions Preview

Vacancy Questions Preview

Grade: 13
* 1.GS-13 Choose the answer that best describes your experience:
  1. I have at least one year of specialized experience equivalent to the GS-12 level in the Federal service. Specialized experience is defined as experience that demonstrates the knowledge and ability to oversee planning, management, implementation, and maintenance of a data warehouse and experience in a human capital management (HCM) environment that provided familiarity with HCM data management, reporting and assessment tools and applications.
  2. I do not possess the experience described above.


GS-13 Examples of specialized experience for this position include data warehouse development and implementation requiring knowledge of relational database design, principles, and practices; experience with database objects including views, user-defined functions, triggers, stored procedures, and use of database languages such as SQL applied to the construction of queries; the ability to plan, implement and maintain backups and restore operations, log shipping and database mirroring; experience in creating requirements for human capital data reporting, querying and analytics; conducting data analysis, data mining and reporting for a HCM program; developing and supporting data resources needed for HCM operations; using HCM reporting systems to retrieve statistical data; conducting audits to test the human capital data integrity and reliability of programs; and evaluating HCM data and recommending program improvements based on findings.

Grade: 14
* 1.GS-14 Choose the answer that best describes your experience:
  1. I have at least one year of specialized experience equivalent to the GS-13 level in the Federal service. Specialized experience is defined as experience that demonstrates the knowledge and ability to oversee planning, management, implementation, and maintenance of a data warehouse and experience in a human capital management (HCM) environment that provided familiarity with HCM data management, reporting and assessment tools and applications.
  2. I do not possess the experience described above.


GS-14 Examples of specialized experience for this position include data warehouse development and implementation requiring knowledge of relational database design, principles, and practices; experience with database objects including views, user-defined functions, triggers, stored procedures, and use of database languages such as SQL applied to the construction of queries; the ability to plan, implement and maintain backups and restore operations, log shipping and database mirroring; experience in creating requirements for human capital data reporting, querying and analytics; conducting data analysis, data mining and reporting for a HCM program; developing and supporting data resources needed for HCM operations; using HCM reporting systems to retrieve statistical data; conducting audits to test the human capital data integrity and reliability of programs; and evaluating HCM data and recommending program improvements based on findings.

Grade: All Grades
* 1.I have overseen planning, management, implementation, and maintenance of a data warehouse and have experience in a human capital management (HCM) environment that provided familiarity with HCM data management, reporting and assessment tools and applications.
  1. Yes
  2. No


* 2.Which of the following best describes your IT data warehouse project leadership experience?
  1. As a project lead for an IT data warehouse project I lead two or more cross/multi- functional teams including a team(s) of IT experts and a team(s) of business/functional experts.
  2. As an IT project lead for a data warehouse project I lead a team of IT experts representing a variety of subfunctions (e.g. data architect, developer and/or modeler).
  3. As an IT project lead for a data warehouse project I lead a team of business/functional experts.
  4. As an IT project lead for a data warehouse project I lead a team other than that described above.
  5. I do not have experience leading an IT data warehouse Project.


* 3.As an IT Data Warehouse Project Lead, I was responsible for:
  1. Both application side management (navigation, data retrieval, exception cases, etc.) and data side (data integrity, meta data management, data modeling/design, etc.) management associated with separate projects.
  2. Data side management (data integrity, meta data management, data modeling/design, etc.).
  3. Both application side management (navigation, data retrieval, exception cases, etc.) and data side management (data integrity, meta data management, data modeling/design, etc.) for the same project.
  4. Applications side management (navigation, data retrieval, exception cases, etc.).
  5. I do not have experience with application side (navigation, data retrieval, exception cases, etc.) or data side management (data integrity, meta data management, data modeling/design, etc.).


* 4.Identify the position(s) in your resume in which you performed the above activity/activities; and/or gained the relevant experience.
Maximum length of 250 characters.


* 5.Select the three (3) areas that reflect your greatest strength as it related to data warehouse project leadership.
  1. Ability to manage scope creep
  2. Ability to present information to management
  3. Ability to understand the technical and functional/business requirements
  4. Ability to stay on schedule
  5. Ability to manage conflicts among project team/stakeholders
  6. Ability to stay on budget
  7. Ability to follow system development life cycle processes
  8. Ability to oversee contract requirements
  9. Ability to communicate with stakeholders
  10. Ability to translate the technical and functional/business requirements within the team
  11. Ability to oversee contract and federal support
  12. Ability to understand relational database systems
  13. None of the above


* 6.Are you currently an IT project manager with authority and responsibility for making key project decisions on project design, budget, resource assignments and schedule?
  1. Yes

        BRANCHED: * 1.Which of the following reflects your level of responsibility for project decisions?
    1. I monitor project budgets and project goals.
    2. I research, evaluate and recommend new technology investments for my organization.
    3. I serve as a COTR or procurement official.
    4. I used earned value management and other techniques to identify strategies for achieving project goals with reduced funding or staffing.
    5. I recommend new project goals to leadership officials to advance organizational goals.
    6. I develop fiscal year project budget projections and project goals.
    7. I serve as the staffing resource manager for IT at my organization.
    8. I develop three to five year project budget projections and project goals.
    9. I monitor resource assignments.
    10. I adjust resource assignments based on accomplishments and budget.
    11. I develop roadmaps for our organization’s IT strategy.
    12. I approve new project goals to advance organizational goals.
    13. I reassign resources to new projects based on availability and need.
    14. None of the above.
  2. No


* 7.Describe your experience procuring IT Services including software and support.
  1. I have written Statements of Work and/or Objectives.
  2. I have secured funding by presenting a business need to management (i.e. developed a business case, cost analysis, and high level functional requirements).
  3. I serve as a COTR for an enterprise IT services contract.
  4. I have done market research and cost benefit analyses on a variety of IT services/software.
  5. I have worked directly with procurement personnel through all phases of the procurement lifecycle (pre-solicitation, solicitation, evaluation and award).
  6. I lead a benchmarking study including identification of benchmarking organizations, evaluation criteria and presentation of results to management.
  7. I developed and documented technical requirements based on my work gathering business/functional needs inputs and synthesizing them in a business case.
  8. I have served on an evaluation panel reviewing proposal submissions against Statements of Work for best agency value.
  9. None of the above.


* 8.As an IT Data Warehouse Project Manager I have lead projects supporting the integration of applications with interdependencies/interfaces for systems in the following functional areas.
  1. Finance/Budget
  2. Human Resources
  3. Facilities Management
  4. Security
  5. Mission/Program Areas
  6. None of the above


* 9.Identify the position(s) in your resume in which you performed the above activity/activities; and/or gained the relevant experience.
Maximum length of 250 characters.


* 10.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.


* 11.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.


* 12.For Enterprise Reporting Systems (ERP), Business Intelligence tools such as: Oracle, IBM Cognos, SAP Business Objects, or equivalent tools:
  1. I led the ongoing operations of a data warehouse including design and implementation of standard operations procedures.
  2. I led a business unit in standing up/implementing structure and processes to support ongoing operations of a data warehouse.
  3. I led the technical design of a data warehouse solution.
  4. I led the implementation of a data warehouse for a large and complex organization (at least 10,000 employees).
  5. I implemented database architecture standard s and best practices to maximize performance, scalability, availability, and data exchange with other systems.
  6. I led the evaluation of Commercial-Off-The-Shelf products.
  7. None of the above.


* 13.Which Business Intelligence Tools/Suites have you used:
  1. Microsoft Excel or Access
  2. SAS
  3. IBM Cognos
  4. Seibel
  5. Informatica
  6. Oracle
  7. SAP Business Objects
  8. Microstrategy
  9. Other
  10. None of the above


* 14.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.






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).