IT Specialist (Data Management) Job in Washington DC, DC

Vacancy No. 12442209-BSM-DE Department Justice, Office of the Inspector General
Salary $139,395.00 to $181,216.00 Grade 14 to 14
Perm/Temp Permanent FT/PT Full-time
Open Date 6/13/2024 Close Date 6/28/2024
Job Link Apply Online Who may apply Public
Locations:
Washington DC, DC


Job Description (Please follow all instructions carefully)

Summary

The Office of the Inspector General is one of the best places to work in the Department of Justice and is one of the premier inspector general offices in federal government. We are seeking a highly-motivated professional employee with experience in providing superior customer service in support of our mission to promote integrity, efficiency, and accountability within the Department of Justice.

This job is open to

Clarification from the agency

United States Citizens

Duties

The Office of the Inspector General (OIG) in the U.S. Department of Justice (DOJ) is a statutorily created independent entity that works to prevent fraud, waste, abuse, and misconduct in DOJ programs and personnel, and to promote economy and efficiency in those programs. The Office of Data Analytics (ODA) is responsible for supporting the OIG's audits, evaluations, investigations, and special reviews of the personnel and programs of all DOJ components. The goal of the Data Analytics program is to: (1) develop the OIG's capability to manage large datasets to support various OIG projects; (2) develop models to automatically identify indicators of fraud and other high-risk programs and/or transactions; and (3) represent the Department in its interactions with all federal Departments and agencies regarding data analytics activities, policies, standards, and programs.

As an IT Specialist (Data Management), your responsibilities will include, but are not limited to:

  • Provide a robust data management platform to translate complex business needs, requirements and strategy, multiple data sets and other data points that supports conceptual, relevant, and straightforward dashboards, visual tools, reports, and analytical solutions
  • Develop standard templates and data/information displays that communicate complete information in simple insightful ways that accelerate decisions, improve accountability, and increase speed to target.
  • Develop and execute strategies to improve business strategies, fraud detection and data analysis through related information systems within the DOJ-OIG.
  • Develop strategies for data acquisition, archive recovery, and implementation of data architectures to support a Data Warehouse/Data Lake environment, including data design, database architecture, and meta data repository creation for a variety of business data from various DOJ Components.
  • Evaluate highly complex database management environments identifying problems and providing expert technical advice on new or improved information technology and procedures.
  • Develop data architecture with customer as focus in meeting their needs for a scalable platform.
  • Lead full life cycle support of various RDBMS, NoSQL, Columnar Databases in development and production environments including: installing, configuring, monitoring, upgrading, troubleshooting and maintaining databases in production and non-production environments; and diagnosing and addressing database performance issues using performance monitors and various tuning techniques.
  • Integrate hardware and software components, evaluate new applications software features and technologies, and communicate new features of version updates to end users. Ensure that the rigorous application of information security/information assurance policies, principles, and practices to remain current in relation to the delivery of application software services.
  • Assist with technical consultation on areas for improvement. Support new technical enhancements in collaboration with the vendors. Product adaptation will include, but are not limited to, customer access orientation, applications navigation, and applications use
  • Develop data domains and their interoperability and paying attention to data elements and develop common nomenclature across such domains.
  • Work with developers and customer support providing technical and operational support activities, including design, troubleshooting, performance monitoring, tuning and optimizing.
  • Communicate effectively with stake holders and developers in creating high performance data assets.
  • Solve problems that arise in integrating heterogeneous systems and come up with ingenuous solutions for product integration.
Responsibilities will increase and assignments will become more complex as your training and experience progress.

Requirements

Conditions of Employment

  • You must be a U.S. Citizen or National.
  • You must be able to obtain and maintain a security clearance.
  • You must be registered for the Selective Service, if applicable.
  • You must successfully pass and are subject to random drug screenings.
  • You must meet all qualification requirements by the closing date of this announcement.
  • You may be subject to a probationary period.

Qualifications

You must possess One year (52 weeks) of specialized experience at least equivalent to the GS-2210-13 IT (Data Management) grade level. Specialized experience is paid or unpaid experience which has equipped you with the specific knowledge, skills, and abilities to successfully perform the duties of the position. Examples of specialized experience include such duties as: having hands-on experience with Hadoop Hive or similar RDBMS as an administrator in a Linux environment; working knowledge of database fundamentals, data modeling techniques to implement data warehouses, data mining, OLAP and working with NoSQL databases and tools such as Informatica; and familiarity with challenges of development and benefits of multidimensional information and best practices.

Education

**Some federal jobs allow you to substitute your education for the required experience in order to qualify. For this job, you must meet the qualification requirement using experience alone--no substitution of education for experience is permitted.**

Additional information

DOJ EEO Statement/Policy: http://www.justice.gov/jmd/eeos/08-eeo-policy.pdf
As the federal agency whose mission is to ensure the fair and impartial administration of justice for all Americans, the Department of Justice is committed to fostering a diverse and inclusive work environment. To build and retain a workforce that reflects the diverse experiences and perspectives of the American people, we welcome applicants from the many communities, identities, races, ethnicities, backgrounds, abilities, religions, and cultures of the United States who share our commitment to public service.

Reasonable Accommodation (RA) Requests: If you believe you have a disability (i.e., physical or mental), covered by the Rehabilitation Act of 1973 as amended, that would interfere with completing the USA Hire Competency Based Assessments, you will be granted the opportunity to request a RA in your online application. Requests for RA for the USA Hire Competency Based Assessments and appropriate supporting documentation for RA must be received prior to starting the USA Hire Competency Based Assessments. Decisions on requests for RA are made on a case-by-case basis. If you meet the minimum qualifications of the position, after notification of the adjudication of your request, you will receive an email invitation to complete the USA Hire Competency Based Assessments. You must complete all assessments within 48 hours of receiving the URL to access the USA Hire Competency Based Assessments, if you received the link after the close of the announcement. To determine if you need a RA, please review the Procedures for Requesting a Reasonable Accommodation for Online Assessments here: https://help.usastaffing.gov/Apply/index.php?title=Reasonable_Accommodations_for_USA_Hire

Selective Service: If you are a male applicant born after December 31, 1959, you must certify that you have registered with the Selective Service System, or are exempt from having to do so under the Selective Service Law. Additional information is found at: www.sss.gov.

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 windowLearn 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 You Will Be Evaluated

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

You will be evaluated based on how well you meet the qualifications listed in this vacancy announcement. You will be evaluated through the following assessment process:

USAHire Assessment: Applicants will be required to complete a USAHire Assessment. This assessment is online and measures the following competencies:

  • Accountability
  • Attention to Detail
  • Customer Service
  • Data Architecture
  • Data Management
  • Database Administration
  • Decision Making
  • Flexibility
  • Influencing/Negotiating
  • Integrity/Honesty
  • Interpersonal Skills
  • Learning
  • Oral Communication
  • Problem Solving
  • Product Adaption Expertise
  • Reading Comprehension
  • Reasoning
  • Self-Management
  • Stress Tolerance
  • Teamwork
You will not be considered for the position if you score below the cut score or fail to complete the USAHire assessment.

Resume Review: Your resume will be reviewed to determine your technical qualifications. Applicants found to meet the requirements will be eligible to proceed to a qualifying interview.

Qualifying Interview: Applicants who pass the resume review will be assessed via an interview.

For Category Rating: At the conclusion of the assessment process, qualified candidates will be placed into one of three categories. Qualified, Well Qualified and Best Qualified.

Qualified Category = Meets the basic qualifications requirements described in the "Qualifications" section of this announcement and demonstrates proficiency in the Competencies. (This category must be met to be considered under ICTAP procedures)

Well Qualified Category = Applicants possessing experience that exceeds the minimum qualifications of the position and demonstrates acceptable proficiency in all of the critical competencies as determined by the job analysis.

Best Qualified Category = Meets the basic qualifications requirements described in the "Qualifications" section of this announcement and excels in the Competencies. The category assignment is a measure of the degree in which your background matches the competencies required for this position.

The Category Rating Process does not add veterans' preference points or apply the "rule of three," but protects the rights of veterans by placing them ahead of non-preference eligibles within each category. Preference eligibles who meet the minimum qualification requirements and have a compensable service-connected disability of at least 10 percent or higher will be listed in the highest quality category.

Overstating your qualifications and/or experience in your application materials or application questionnaire may result in your removal from consideration. Cheating on the online assessment may also result in your removal from consideration.

To preview the application questionnaire, click the following link: https://apply.usastaffing.gov/ViewQuestionnaire/12442209

If you are found to be among the top candidates, you will be referred to the selecting official for further employment consideration.

Required Documents

  • Current detailed resume showing relevant experience and dates the experience was obtained. Experience refers to paid and unpaid experience, including volunteer work done through National Service programs (e.g., Peace Corps, AmeriCorps) and other organizations (e.g., professional, philanthropic, religious, spiritual, community, student, and social). Volunteer work helps build critical competencies, knowledge, and skills and can provide valuable training and experience that translates directly to paid employment. You will receive credit for all qualifying experience, including volunteer experience.
  • A cover letter is optional, but encouraged.
  • Veterans' Preference documentation (if applicable)
    • If you are a veteran and you are claiming 5-point veterans' preference, you must submit a copy of your DD-214 or other proof of eligibility.
    • If you are a veteran and you are claiming 10-point veterans' preference, you must also submit an SF-15, "Application for 10-Point Veterans' Preference" plus the proof required by that form. For more information on veterans' preference click here.
  • Schedule A documentation (if applicable)
    • DOJ welcomes and encourages applications from persons with disabilities and is firmly committed to satisfying its affirmative obligations under the Rehabilitation Act of 1973 to ensure that persons with disabilities have every opportunity to be hired and advanced on the basis of merit within the Department.
  • Career Transition Assistance Programs: These programs apply to employees who have been involuntarily separated from a Federal service position within the competitive service or Federal service employees whose positions have been deemed surplus or no longer needed. To receive selection priority for this position, you must: 1) meet CTAP or ICTAP eligibility criteria; 2) be rated best qualified (85) and 3) submit the appropriate documentation to support your CTAP or ICTAP eligibility. For more information visit: http://www.opm.gov/rif/employee_guides/career_transition.asp.

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.

How to Apply

The complete Application Package must be submitted by 11:59 PM (EST) on 06/28/2024 to receive consideration.

Please read the entire announcement and all the instructions before you begin an application. To apply for this position, you must complete the initial online application, to include the initial online assessment and submission of the required documentation specified in the Required Documents section above. The complete application package must be submitted by 11:59 PM (ET) on the closing date of the announcement to receive consideration. The application process is as follows:

  1. To begin the application process, click the Apply Online button.
  2. Answer the questions presented in the application and attach all necessary supporting documentation.
  3. Click the Submit Application button prior to 11:59 PM (ET) on the announcement closing date.
  4. After submitting an online application, you will be notified whether or not you are required to take additional online assessments through the USA Hire Competency Based Assessment system. This message will be delivered to you via email notification. The email may be routed to your "Spam" or "Junk" folder.
  5. If you are asked to take the USA Hire Competency Based Assessments, you will be presented with a unique URL to access the USA Hire system. Access to USA Hire is granted through your USAJOBS login credentials. Be sure to review all instructions prior to beginning your USA Hire Assessments. Click here for Computer System Requirements (https://help.usastaffing.gov/Apply/index.php?title=USA_Hire_System_Requirements)
  6. Note, set aside at least 3 hours to take these assessments; however, most applicants complete the assessments in less time. If you need to stop the assessments and continue at a later time, you can reuse the URL sent to you via email and also found in your USAJOBS account under the "Track my application" link for the corresponding application.
To update your application, including supporting documentation, at any time during the announcement open period, return to your USAJOBS account (https://usajobs.gov). There you will find a record of your application, the application status, and an option to Edit my application. This option will no longer be available once the announcement has closed.

To verify the status of your application both during and after the announcement open period, log into your USAJOBS account at https://www.usajobs.gov. On the Home page, scroll down and locate your job application. Once the job has been located, click the "Track this application" link on the right under the application date. The page will refresh to display the Agency's Application Information page where you can scroll down and review any notifications the agency has sent you. The Application Status will appear along with the date your application was last updated. For information on what each Application Status means, visit: https://www.usajobs.gov/Help/how-to/application/status/.

Agency contact information

Brandie Miller
Address
Audit Division
950 Pennsylvania Ave NW
Washington, DC 20530
US
Learn more about this agency

Next steps

Based on your application and your responses to the application questionnaire, you may be presented with instructions on how to access the USA Hire system to complete the online assessments. The online assessments must be completed within 48 hours following the close of this announcement. You will have the opportunity to request a testing accommodation for the assessment should you have a disability covered under the Americans with Disabilities Act (ADA).

Your assessment results will be kept on record for one year and used toward future positions for which you might apply that require the same assessments.

To be considered for the position, you must meet all qualifications, including meeting or exceeding the cut score on the required assessments.


Note: We cannot accept applications on behalf of Federal Agencies. Application instructions are listed within the Job Description.