Management Information Specialist

Employer
USAJobs
Location
Washington, D.C
Posted
Jul 23, 2021
Closes
Jul 28, 2021
Hours
Full Time
Duties

Summary

This position is located in the Department of Housing and Urban Development, Assistant Secretary for Public and Indian Housing.

If you do not meet any of the categories listed above, you may wish to apply under announcement 21-HUD-1512-P which is open for any U.S. citizen to apply. Please refer to that announcement for details on open period, eligibility, and how to apply.
Learn more about this agency

Responsibilities

The following are the duties of this position at the GS-14. If you are selected at a lower grade level, you will have the opportunity to learn to perform all these duties, and will receive training to help you grow in this position.

As a Management Information Specialist, you will:
  • Design, develop, and run complex queries using complex Microsoft Access Structured Query Language (SQL) methods; and manipulates data and generates reports using Microsoft Access Structured Query Language (SQL) and maintains routine and ad hoc reports.
  • Operate as a technical authority in the review, development and implementation of policies and regulations related to information systems and reporting tools that could significantly change the way the agency conducts its business with the public or with private industry, or which modify important inter-agency relationships.
  • Assist in the design, development, testing and execution of various complex SQL statements using Oracle/Microsoft databases and multidimensional data sources in very large data warehouses.
  • Run test queries, generate complex queries and reports and manipulate data, using query language, in response to Division or customer requirements; design, develop, and maintain complex routine and ad hoc reports for the division; and presents reports to customers in various formats such as a spreadsheet, pdf or word processor document.
  • Design, develop, and maintain data management systems that meet current and future business requirements of the Division; design, develop, and maintain relational databases; monitors and optimizes database performance and assists IT personnel in trouble shooting database problem.


Travel Required

Occasional travel - You may be expected to travel for this position. 1-5 nights per month.

Supervisory status
No

Promotion Potential
14

Requirements

Conditions of Employment



Candidates will be selected for a job assigned to one of the official duty stations listed in this announcement. Failure to report to duty at the location for which the candidate is selected may be grounds for a disciplinary action, including removal.

There is 1 vacancy for this position that may be filled in either of the below locations:
  • Kansas City, KS
  • Washington, DC
  • Key Requirements:
  • Please refer to "Conditions of Employment."
  • Must be U.S. Citizen or U.S. National.


  • Qualifications

    You must meet the following requirements within 30 days of the closing date of this announcement.
    Specialized Experience:
    For the GS-14, you must have one year of specialized experience at a level of difficulty and responsibility equivalent to the GS-13 grade level in the Federal service.
    Specialized Experience for this position includes:
    • Accessing, scrubbing, modeling and analyzing financial and programmatic data, applying analytical and problem solving techniques to identify issues and develop solutions; AND
    • Performing system and process analysis (i.e. researching problems, planning solutions, recommending process, software and systems solutions, and coordinating development to meet business needs); AND
    • Writing reports with commercial off the shelf (COTS) software.
    For the GS-13, you must have one year of specialized experience at a level of difficulty and responsibility equivalent to the GS-12 grade level in the Federal service.
    Specialized Experience for this position includes:
    • Assisting in accessing, scrubbing, modeling and analyzing financial and programmatic data and applying analytical problem-solving techniques to identify issues; AND
    • Assisting in performing system and process analysis (i.e. researching problems, planning solutions, recommending process, software and systems solutions, and assisting in development to meet business needs); AND
    • Writing reports with commercial off the shelf (COTS) software.
    Experience may have been gained in either the public, private sector or volunteer service . One year of experience refers to full-time work; part-time work is considered on a prorated basis. To ensure full credit for your work experience, please indicate dates of employment by month/day/year, and indicate number of hours worked per week on your resume.

    Time-in-Grade: In addition to the above requirements, you must meet the following time-in-grade requirement, if applicable:
    For the GS-14 you must have been at the GS-13 level for 52 weeks.
    For the GS-13 you must have been at the GS-12 level for 52 weeks.

    Time After Competitive Appointment: Candidates who are current Federal employees serving on a non-temporary competitive appointment must have served at least three months in that appointment.

    Education

    The education generally must be from an accredited (or pre-accredited) college or university recognized by the U.S. Department of Education. If you are qualifying based on foreign education, you must submit proof of creditability of education as evaluated by a credentialing agency. Refer to the OPM instructions .

    Additional information

    OTHER INFORMATION:
    • We may select from this announcement or any other source to fill one or more vacancies.
    • Relocation expenses will not be paid.
    • Relocation incentive will not be paid.
    • A recruitment incentive may be paid to newly appointed (non-Federal) applicants. A service agreement will be required.
    • This is a bargaining unit position.
    • This position is Exempt from the Fair Labor Standards Act (FLSA).
    • HUD offers alternative and flexible work schedules.
    CONDITIONS OF EMPLOYMENT:
    • A one year probationary period may be required.
    • Must successfully complete a background investigation.
    • Complete a Declaration for Federal Employment to determine your suitability for Federal employment, at the time requested by the agency.
    • Have your salary sent to a financial institution of your choice by Direct Deposit/Electronic Funds Transfer.
    • If you are a male applicant born after December 31, 1959, certify that you have registered with the Selective Service System or are exempt from having to do so.
    • Go through a Personal Identity Verification (PIV) process that requires two forms of identification from the Form i-9. Federal law requires verification of the identity and employment eligibility of all new hires in the U.S.
    • Obtain and use a Government-issued charge card for business-related travel.

    HUD employees are subject to a number of government-wide and HUD specific ethics laws and regulations, including restrictions on working in a real estate related business, and having Section 8 tenants, along with other prohibited interests and activities. To review applicable ethics rules and HUD specific restrictions, please visit https://portal.hud.gov/hudportal/HUD?src=/program_offices/general_counsel/ethics .

    How You Will Be Evaluated

    You will be evaluated for this job based on how well you meet the qualifications above.

    Your application includes your résumé, responses to the online questions, and required supporting documents. Please be sure that your résumé includes detailed information to support your qualifications for this position; failure to provide sufficient evidence in your résumé may result in a "not qualified" determination.

    Rating : Your application will be evaluated in the following areas: Project Management, Systems and Technology, and Technical.
    Your application will be rated and ranked among others, based on your responses to the online questions, regarding your experience, education, training, performance appraisals and awards relevant to the duties of this position. Your rating may be lowered, if your responses to the online questions are not supported by the education and/or experience described in your application.
    Referral : If you are among the top qualified candidates, your application may be referred to a selecting official for consideration. You may be required to participate in a selection interview.

    If you are a displaced or surplus Federal employee (eligible for the Career Transition Assistance Plan (CTAP)/Interagency Career Transition Assistance Plan (ICTAP) ) you must receive a rating of at least 84 out of 100 to be rated as "well qualified" to receive special selection priority.

    Background checks and security clearance

    Security clearance
    Other

    Drug test required
    No

    Required Documents

    A complete application includes 1. A résumé, 2. Vacancy question responses, and 3. Submission of any required documents.
    Please note that if you do not provide all required information, as specified in this announcement, you may not be considered for this position (or may not receive the special consideration for which you may be eligible)

    All applicants are required to submit a résumé either by creating one in USAJOBS or uploading one of their own choosing. (Cover letters are optional.) To receive full credit for relevant experience, please list the month/date/year and number of hours worked for experience listed on your résumé. We suggest that you preview the online questions, as you may need to customize your résumé to ensure that it supports your responses to these questions. Please view résumé tips .
    CURRENT AND FORMER EMPLOYEES -- Documentation Relating to Your Federal Employment:-
    • Submit a copy of your SF-50 (Notification of Personnel Action) showing competitive service as Tenure 1 or 2 (Block 24), Position Occupied as 1 - Competitive Service (Block 34), current Grade (Block 18) and Salary (Block 20).
    • Typically Award SF-50s do not provide the required information.
    • If the full performance level of your position is different from the grade indicated in Block 18, please provide proof of the full performance level.
    • If your highest permanent grade is different from your current grade, submit a copy of an additional SF-50 showing that grade.
    • If you are currently on a Veterans' Recruitment Appointment (VRA), submit a copy of an SF-50 indicating that type of appointment. Also, you must submit a copy of your DD214 or other documentation showing dates of service and type of discharge and any other applicable documents such as SF-15, VA letters, etc.


    Performance Appraisal (ALL APPLICANTS): 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. In cases where the performance appraisal is more than 12 months old, incomplete or unavailable, you must attach a written explanation of the reasons.

    If you are applying under a special hiring authority (e.g. Military Spouses, Interchange Agreement, VEOA, Schedule A Disability, etc.), please see applicant guide for required documentation . In order to be eligible under one of these authorities, you must submit all required documentation as outlined in the applicant guide.
    CAREER TRANSITION ASSISTANCE PLAN (CTAP) OR INTERAGENCY CAREER TRANSITION ASSISTANCE PLAN (ICTAP) DOCUMENTATION: If you are a displaced or surplus Federal employee, click CTAP/ICTAP for eligibility and a detailed list of required documents you must submit in order to be eligible.

    REINSTATEMENT: If you are a former federal employee and wish to be non-competitively reinstated for a higher grade or full performance level than which you left federal employment, you MUST provide a copy of your separation SF50 (the "position occupied" block on the SF-50 should show a "1" and your "tenure" block should show a "1" or "2") AND the last performance appraisal you received from your federal employment which shows at least a fully successful rating.

    Land Management Eligibles must provide all required documentation to verify eligibility, prior performance, and qualifications for the target position. You can find information on the Land Management Workforce Flexibility Act and eligibility here .

    Similar jobs