Sorry, this job is no longer available.

(Loading More Opportunities)

Data Warehouse Specialist


  • Duties
    Help Duties Summary

    The incumbent will assist research staff with extracting and/or restructuring data files for analysis, creating descriptive reports, and conducting data analysis.
    Learn more about this agency
    Responsibilities

    The Data Warehouse Specialist will have a blend of skills related to extracting data from a data warehouse, data wrangling, feature engineering, and data analysis. The incumbent will assist research staff with extracting and/or restructuring data files for analysis, creating descriptive reports, and conducting data analysis. The candidate will develop expertise in the data elements utilized for analysis, how to extract those elements from the data warehouse, and provide analytical support as needed. The incumbent will create descriptive reports (e.g. , district sentencing trend reports) and may assist with policy analysis, congressional research projects, or special data requests from Commissioners, federal judges and probation officers, and other federal agencies.

    The incumbent will work with research staff to:
    • Extract analytical files from the Oracle data warehouse.
    • Train ORD staff on data extraction and programming.
    • Assist with feature engineering in the data warehouse.
    • Merge and wrangle data from other federal agencies or from special USSC data collections.
    • Review existing data for errors and clean data.
    • Create automated reports.
    • Create descriptive reports ( e.g. , district sentencing trend reports).
    • Review/verify any data changes/updates to the Commission's Interactive Sourcebook of Federal Sentencing Statistics (ISB) public website.
    • Conduct descriptive analyses on defendants sentenced pursuant to the federal sentencing guidelines, responding to special requests from Commissioners, Congress, the courts, and others, as directed.
    • Assist in the design and development of tables and figures for use in special requests, presentations, and Commission reports.
    • Compile, organize, and document research-related datafiles and assist in the preparation of datafile documentation, statistical tables, and graphic displays and presentations.
    • Analyze quantitative data and contribute to published reports.
    • Learn and implement new technology to enhance ORD capabilities.
    • Perform support or administrative tasks as needed.
    The job may require occasional travel to give presentations or to attend meetings or conferences.

    Travel Required
    Occasional travel - You may be expected to travel for this position.

    Supervisory status
    No

    Promotion Potential
    13

  • Job family (Series)
    1530 Statistics

  • Requirements
    Help Requirements Conditions of Employment

    • This position is in the excepted service and does not carry the tenure rights of positions in the competitive Civil Service.
    • All information is subject to verification. Applicants are advised that false answers or omissions of information on application materials or inability to meet the following conditions may be grounds for non-selection, withdrawal of an offer of employment, or dismissal after being employed.
    • Selection for this position is contingent upon completion of OF-306, Declaration for Federal Employment during the pre-employment process and proof of U.S. citizenship or, for noncitizens, proof of authorization to work in the United States and proof of entitlement to receive compensation. Additional information on the employment of non-citizens can be found at: https://help.usajobs.gov/index.php/Employment_of_Non-citizens . For a list of documents that may be used to provide proof of citizenship or authorization to work in the United States, please refer to http://www.uscis.gov/files/form/i-9.pdf .
    • A background security investigation is required for all selectees. Appointment will be subject to a selectee's successful completion of a background security investigation and favorable adjudication. Failure to successfully meet these requirements may be grounds for appropriate personnel action. A background security reinvestigation or supplemental investigation may be required at a later time.
    • All new Commission employees must identify a financial institution for direct deposit of pay before appointment, mandated by the Federal Compensation Act.
    • All new Commission employees, those converted from a temporary appointment to a permanent appointment, and all rehired former Commission employees are required to serve a one-year probationary period. The probationary period begins on the effective date of the employee's appointment, conversion, or rehire.
    • Applicant must relocate to the Washington DC Metropolitan area.


    Qualifications
    ABOUT THE OFFICE OF RESEARCH AND DATA (ORD)
    ORD is the largest unit in the Commission, with approximately 45 employees. ORD staff collect data from sentencing documents which are submitted electronically by federal courts around the country. ORD staff provide statistical analyses to the Commissioners about the nature and extent of federal crime, the people who commit those crimes, and how the federal sentencing guidelines are applied in criminal cases. ORD's analyses are a key part of the Commission's decision-making process about changes to the guidelines. ORD analyses are also used in various publicly available publications such as the Sourcebook of Federal Sentencing Statistics , quarterly sentencing data reports, Quick Facts , and various reports to Congress.

    MANDATORY QUALIFICATION REQUIREMENTS
    • Applicants must have an undergraduate degree from an accredited university or college in a relevant field ( e.g. , data science, computer science, statistics, etc.).
    • Applicants must have three years experience with programming languages (SAS enterprise preferred).
    • Applicants must have three years experience working with databases ( e.g. , SQL queries and data warehouse modeling).
    • Applicants must have experience with data wrangling and data cleaning.
    • Applicants must have experience in creating descriptive reports and conducting descriptive analysis.
    • Applicants must have at least one year of specialized experience equivalent to the next lower level of the grade for which they are applying. For example, to qualify for the GS-13, one year of specialized experience must have been at the GS-12 level or equivalent.
    PREFERRED QUALIFICATIONS

    Preference will be given to applicants with the following areas of experience:
    • Experience with Oracle databases.
    • Experience with Apex.
    • Experience with criminal justice data.
    • A Master's degree in a relevant field from an accredited university or college.


    Education
    Applicants must have an undergraduate degree from an accredited university or college in a relevant field (e.g., data science, computer science, statistics, etc.).

    Preference will be given to applicants with a Master's degree in a relevant field from an accredited university or college.

    Additional information

    The Commission participates in the following federal benefits: The Federal Employees Health Benefits (FEHB) program; the Federal Employees Dental and Vision Insurance Program (FEDVIP), the Federal Employees Group Life Insurance (FEGLI) program, federal retirement, the Thrift Savings Plan (TSP), and the federal leave program. In addition, the Commission participates in the Judiciary's Flexible Spending Program for dependent care, health care, and commuter reimbursement, and the government-wide Long Term Care Insurance Program, unemployment, and workers' compensation benefits.

    The Commission offers a monthly transit subsidy to employees who use mass transit to commute to and from work, subject to the availability of funds. The Commission offers alternative work schedules (AWS), which are fixed work schedules that enable full-time employees to complete the basic 80-hour biweekly work requirement in less than 10 workdays.

    The Commission offers limited regular telework (not full-time) to employees in positions deemed eligible by the staff director and who meet the requirements of an approved telework arrangement in which an employee performs official duties at home or at an approved telework center.

    The Commission also offers training opportunities to employees through LinkedIn Learning, and the Judiciary's Online University, which offers academic credit and professional credit programs through web-based learning. These training tools assist Commission employees with taking online courses in a flexible way, by offering training courses in the areas of: staff training and development; credit toward undergraduate degree programs; continuing education and non-credit certificate programs; executive education; contract training; credit credentials courses for continuing professional education and credit for individuals who hold credentials and achieve certifications associated with several globally-recognized sponsored organizations.

    Read more

    How You Will Be Evaluated

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

    The Commission evaluates applicants through a structured interview. Applicants may also be screened for some jobs through a narrative/application review, and/or a preliminary telephone interview. In order to be considered for this position, applicants must address the mandatory and preferred qualifications in the questionnaire on USAJOBS as a separate submission from resume and cover letter.

    Applicants who do not address the qualification requirements (mandatory and preferred) in his or her application materials as stated in the vacancy announcement are automatically disqualified from consideration and must re-apply before the closing date to be considered for employment.

    Read more
    Background checks and security clearance

    Security clearance
    Other

    Drug test required
    No

  • Required Documents
    Help Required Documents

    • Cover Letter that address all of the qualification requirements listed in this announcement.
    • Resume.
    • College transcripts, if available.
    • Most recent performance evaluation, if available.


    If you are relying on your education to meet qualification requirements:
    Education must be accredited by an accrediting institution recognized by the U.S. Department of Education in order for it to be credited towards qualifications. Therefore, provide only the attendance and/or degrees from schools accredited by accrediting institutions recognized by the U.S. Department of Education .

    Failure to provide all of the required information as stated in this vacancy announcement may result in an ineligible rating or may affect the overall rating.

  • Benefits
    Help Benefits

    A career with the U.S. Government provides employees with a comprehensive benefits package. As a federal employee, you and your family will have access to a range of benefits that are designed to make your federal career very rewarding. Opens in a new window Learn more about federal benefits .

    Review our benefits

    Eligibility for benefits depends on the type of position you hold and whether your position is full-time, part-time, or intermittent. Contact the hiring agency for more information on the specific benefits offered.

  • How to Apply
    Help How to Apply

    In order to be considered, all applicants must submit an electronic resume and cover letter that address all of the qualification requirements listed in this announcement, and if available, provide a recent job performance evaluation and college transcripts. Applicants will also need to complete the online occupational questionnaire. All applications must be submitted at www.usajobs.gov.

    Read more
    Agency contact information Ann Hanlon

    Phone
    202-502-4500
    Email
    hr@ussc.gov

    Address

    United States Sentencing Commission
    One Columbus Circle NE Suite 2-500
    Washington, DC 20002
    US

    Learn more about this agency
    Next steps

    The Office of Human Resources:
    • Reviews the applicant's application to ensure the proper materials are submitted.
    • Ensures that the application addresses all the qualification requirements (mandatory and preferred) as stated in the vacancy announcement.
    • Determines whether the applicant meets the qualification requirements for the position and notifies the applicant about the status of his or her application.
    Applicants who meet the mandatory qualification requirements will be considered and their application materials will be forwarded to the screening panel for review.

    Applicants who do not meet the mandatory qualification requirements for the position are automatically disqualified from consideration. In addition, some applicants may be evaluated using various assessment tools not listed on the vacancy announcement to verify an applicant's experience, knowledge, and training directly related to the job in order to identify the best qualified applicants for consideration and selection.

    Read more
  • Fair & Transparent
    Fair & Transparent
    The Federal hiring process is setup to be fair and transparent. Please read the following guidance.
    Equal Employment Opportunity Policy

    The United States Government does not discriminate in employment on the basis of race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, membership in an employee organization, retaliation, parental status, military service, or other non-merit factor.
    • Equal Employment Opportunity (EEO) for federal employees & job applicants

    Read more Reasonable Accommodation Policy

    Federal agencies must provide reasonable accommodation to applicants with disabilities where appropriate. Applicants requiring reasonable accommodation for any part of the application process should follow the instructions in the job opportunity announcement. For any part of the remaining hiring process, applicants should contact the hiring agency directly. Determinations on requests for reasonable accommodation will be made on a case-by-case basis.

    A reasonable accommodation is any change to a job, the work environment, or the way things are usually done that enables an individual with a disability to apply for a job, perform job duties or receive equal access to job benefits.

    Under the Rehabilitation Act of 1973, federal agencies must provide reasonable accommodations when:
    • An applicant with a disability needs an accommodation to have an equal opportunity to apply for a job.
    • An employee with a disability needs an accommodation to perform the essential job duties or to gain access to the workplace.
    • An employee with a disability needs an accommodation to receive equal access to benefits, such as details, training, and office-sponsored events.


    You can request a reasonable accommodation at any time during the application or hiring process or while on the job. Requests are considered on a case-by-case basis.

    Learn more about disability employment and reasonable accommodations or how to contact an agency.

    Read more Legal and regulatory guidance
    • Financial suitability
    • Social security number request
    • Privacy Act
    • Signature and false statements
    • Selective Service
    • New employee probationary period



This job originated on www.usajobs.gov . For the full announcement and to apply, visit www.usajobs.gov/GetJob/ViewDetails/582614500 . Only resumes submitted according to the instructions on the job announcement listed at www.usajobs.gov will be considered.
Posted
03/10/2021
Type
Full time
Compensation
$34.62 - 64.16
per Hour
Location
Washington, DC, US