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.
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.
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.
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
Specialized Experience: To qualify for this position your resume must show in detail that you have specialized experience with RDBMS, Hive, Informatica setup and configuration in a Linux/Windows environment. You must also have working knowledge of database fundamentals, data modeling techniques to implement data warehouses, data mining, OLAP and working with NoSQL databases. Additionally, you must be familiar with challenges of development and benefits of multidimensional information and best practices in data catalogs.
Time in Grade Requirement: Applicants who have held a General Schedule (GS) position within the last 52 weeks must have 52 weeks of Federal service at the next lower grade level (or equivalent).
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.
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.
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. Your qualifications will be evaluated based on your application materials (e.g., resume, supporting documents), the responses you provide on the application questionnaire, and the result of the online assessments required for this position and a review of your application by a panel of subject matter experts. You will be assessed on the following competencies (knowledge, skills, abilities, and other characteristics):
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
To be considered for this position, you must complete all required steps in the process. In addition to the application and application questionnaire, this position requires an online assessment. The online assessment measures critical general competencies required to perform the job.
The assessment includes a cut score based on the minimum level of required proficiency in these critical general competencies. You must meet or exceed the cut score to be considered. You will not be considered for the position if you score below the cut score or fail to complete the assessment.
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.
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.
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.
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 not required, but encouraged.
SF-50 (most recent Promotion, Within Rate Increase, or Appointment/Conversion SF-50 or Notification of Personnel Action if you are applying as a current or former Federal Employee) that shows you have acquired competitive status, and the highest grade or promotion potential you held.
Time-In-Grade: If you are applying for a higher grade, but your SF-50 doesn't clearly demonstrate you meet the 52-week time-in-grade requirement, you may need to provide an additional SF-50, or equivalent. (e.g., Promotion with an effective date more than one (1) year old, Within-Grade-Increase at the highest grade held.)
A list of three Professional References is not required, but encouraged.
If you are a veteran and you are claiming 5-point veterans' preference, you must submit a copy of your DD-214 (Member copy #4) 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.
CTAP/ICTAP documentation (if applicable)
Interagency Career Transition Assistance Plan (ICTAP): The ICTAP provides eligible displaced Federal competitive service employees with selection priority over other candidates for competitive service vacancies. If your agency has notified you in writing that you are a displaced employee eligible for ICTAP consideration, you may receive selection priority if: 1) this vacancy is within your ICTAP eligibility; 2) you apply under the instructions in this announcement; and 3) you are found well-qualified for this vacancy. To be well qualified, you must satisfy all qualification requirements for the vacant position and (for scored examining) score 85 or better on established ranking criteria OR (for category rating criteria) rate equivalent to the Highly Qualified or better category using established category rating criteria. You must provide proof of eligibility with your application to receive selection priority. Such proof may include a copy of your written notification of ICTAP eligibility or a copy of your separation personnel action form. Additional information about ICTAP eligibility is at: http://www.opm.gov/ctap/index.asp.
The Career Transition Assistance Plan (CTAP): provides eligible surplus and displaced competitive service employees in the Department of Justice with selection priority over other candidates for competitive service vacancies. If your Department of Justice component has notified you in writing that you are a surplus or displaced employee eligible for CTAP consideration, you may receive selection priority if: 1) this vacancy is within your CTAP eligibility, 2) you apply under the instructions in this announcement, and 3) you are found well-qualified for this vacancy. To be well qualified, you must satisfy all qualification requirements for the vacant position and (for scored examining) score 85 or better on established ranking criteria OR (for category rating criteria) rate equivalent to the Highly Qualified or better category using established category rating criteria. You must provide a copy of your written notification of CTAP eligibility with your application. Additional information about CTAP eligibility is at: http://www.opm.gov/ctap/index.asp.
Schedule A documentation (if applicable)
Schedule A: 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. DOJ also encourages eligible Schedule A applicants to submit their resumes. You must include a Schedule A letter from a physician, local, state or federal rehabilitation office citing your eligibility under 5 CFR 213.3102 (u).
If you are relying on your education to meet qualification requirements:
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.
The complete Application Package must be submitted by 11:59 PM (EST) on 10/24/2023 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:
To begin the application process, click the Apply Online button.
Answer the questions presented in the application and attach all necessary supporting documentation.
Click the Submit Application button prior to 11:59 PM (ET) on the announcement closing date.
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.
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/.
Veterans Employment Opportunity Act (VEOA): VEOA allows eligible veterans to apply and compete for positions announced under merit promotion procedures when the hiring agency is recruiting from outside its own workforce. To be eligible for a VEOA appointment, a veteran must be honorably separated and either a preference eligible or have substantially completed three (3) or more years of continuous active military service. If you are applying for a Merit Promotion announcement and wish to be considered under the VEOA, you must submit a copy of the Member Copy 4 of your DD-214, in addition to any other required documents listed on this announcement.
Audit Division
950 Pennsylvania Ave NW
Washington, DC 20530
US
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.
The Federal hiring process is set up to be fair and transparent. Please read the following guidance.
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 not required, but encouraged.
SF-50 (most recent Promotion, Within Rate Increase, or Appointment/Conversion SF-50 or Notification of Personnel Action if you are applying as a current or former Federal Employee) that shows you have acquired competitive status, and the highest grade or promotion potential you held.
Time-In-Grade: If you are applying for a higher grade, but your SF-50 doesn't clearly demonstrate you meet the 52-week time-in-grade requirement, you may need to provide an additional SF-50, or equivalent. (e.g., Promotion with an effective date more than one (1) year old, Within-Grade-Increase at the highest grade held.)
A list of three Professional References is not required, but encouraged.
If you are a veteran and you are claiming 5-point veterans' preference, you must submit a copy of your DD-214 (Member copy #4) 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.
CTAP/ICTAP documentation (if applicable)
Interagency Career Transition Assistance Plan (ICTAP): The ICTAP provides eligible displaced Federal competitive service employees with selection priority over other candidates for competitive service vacancies. If your agency has notified you in writing that you are a displaced employee eligible for ICTAP consideration, you may receive selection priority if: 1) this vacancy is within your ICTAP eligibility; 2) you apply under the instructions in this announcement; and 3) you are found well-qualified for this vacancy. To be well qualified, you must satisfy all qualification requirements for the vacant position and (for scored examining) score 85 or better on established ranking criteria OR (for category rating criteria) rate equivalent to the Highly Qualified or better category using established category rating criteria. You must provide proof of eligibility with your application to receive selection priority. Such proof may include a copy of your written notification of ICTAP eligibility or a copy of your separation personnel action form. Additional information about ICTAP eligibility is at: http://www.opm.gov/ctap/index.asp.
The Career Transition Assistance Plan (CTAP): provides eligible surplus and displaced competitive service employees in the Department of Justice with selection priority over other candidates for competitive service vacancies. If your Department of Justice component has notified you in writing that you are a surplus or displaced employee eligible for CTAP consideration, you may receive selection priority if: 1) this vacancy is within your CTAP eligibility, 2) you apply under the instructions in this announcement, and 3) you are found well-qualified for this vacancy. To be well qualified, you must satisfy all qualification requirements for the vacant position and (for scored examining) score 85 or better on established ranking criteria OR (for category rating criteria) rate equivalent to the Highly Qualified or better category using established category rating criteria. You must provide a copy of your written notification of CTAP eligibility with your application. Additional information about CTAP eligibility is at: http://www.opm.gov/ctap/index.asp.
Schedule A documentation (if applicable)
Schedule A: 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. DOJ also encourages eligible Schedule A applicants to submit their resumes. You must include a Schedule A letter from a physician, local, state or federal rehabilitation office citing your eligibility under 5 CFR 213.3102 (u).
If you are relying on your education to meet qualification requirements:
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.
The complete Application Package must be submitted by 11:59 PM (EST) on 10/24/2023 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:
To begin the application process, click the Apply Online button.
Answer the questions presented in the application and attach all necessary supporting documentation.
Click the Submit Application button prior to 11:59 PM (ET) on the announcement closing date.
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.
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/.
Veterans Employment Opportunity Act (VEOA): VEOA allows eligible veterans to apply and compete for positions announced under merit promotion procedures when the hiring agency is recruiting from outside its own workforce. To be eligible for a VEOA appointment, a veteran must be honorably separated and either a preference eligible or have substantially completed three (3) or more years of continuous active military service. If you are applying for a Merit Promotion announcement and wish to be considered under the VEOA, you must submit a copy of the Member Copy 4 of your DD-214, in addition to any other required documents listed on this announcement.
Audit Division
950 Pennsylvania Ave NW
Washington, DC 20530
US
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.
Fair and transparent
The Federal hiring process is set up to be fair and transparent. Please read the following guidance.
