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 1 year (52 weeks) of 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.
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. 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)
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.
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.
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 Member Copy #4 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)
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).
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 (90) 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:
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/.
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.
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 Member Copy #4 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)
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).
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 (90) 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:
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/.
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.
