Clarification from the agency

U.S. Citizens

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 a Information Technology Specialist (Data Architect), your responsibilities will include, but are not limited to:

• Provide a robust data management platform to translate complex business needs, requirements and strategies, multiple data sets and other data points that support 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 OIG operations, fraud detection and data analysis through related information systems within the DOJ-OIG
• Develop strategies for data acquisition and archive recovery while implementing data architectures to support a data warehouse or data lake environment, including data design, data engineering, database architecture, and metadata repository creation
• Evaluate highly complex database management environments identifying problems and providing expert technical advice on new or improved information technology and procedures
• Design data architecture with a customer-focused approach to meet their needs for a scalable platform.
• Lead full life cycle support of various lakehouse or columnar databases in development and production environments including configuring, monitoring, troubleshooting and maintaining databases in production and non-production environments; and diagnosing and addressing database performance issues using performance monitors and various tuning techniques in cloud environment
• Integrate networking and software components, evaluate new applications software features and technologies, migrate data from on premises to secure cloud environments and communicate new features of version updates to end users. Ensure that the rigorous application of information security/information assurance policies, principles, and practices remain current for 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, application navigation, and application usage
• Develop data domains and their interoperability and pay attention to data elements and develop common nomenclature across such domains
• Support customers and work with developers to provide technical and operational support, including design, troubleshooting, performance monitoring, tuning, and optimization
• Communicate effectively with stakeholders and developers in creating high performance data assets
• Solve problems that arise in integrating heterogeneous systems and coming up with inventive solutions for product integration

Responsibilities will increase and assignments will become more complex as your training and experience progress.

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

To qualify for this position at the GS-14 grade level, applicants must have at least one year of specialized experience at or above the GS-13 grade level. Specialized experience is defined as experience that is typically in or related to work of the position to be filled and has equipped and has equipped you with the particular knowledge, skills, and abilities to successfully perform the duties of the position. For this position your specialized experience must demonstrate the following:

• Professional experience developing pipelines or applications with Databricks, Snowflake, or equivalent tools in a cloud environment;
• Professional experience with data modeling techniques to implement data warehouses and analytical framework in columnar or lakehouse databases;
• Knowledge and/or training in ETL tools or processes; and
• Expertise in Python and SQL.

In addition, you must possess IT related experience (paid or unpaid experience and/or completion of specific, intensive training (e.g., IT certification), as appropriate) demonstrating each of the four competencies listed below.

1. Attention to Detail - Is thorough when performing work and conscientious about attending to detail.
2. Customer Service - Works with clients and customers (i.e., any individuals who use or receive the services or products that your work unit produces, including the general public, individuals who work in the agency, other agencies, or organizations outside the Government) to assess their needs, provide information or assistance, resolve their problems, or satisfy their expectations; knows about available products and services; is committed to providing quality products and services.
3. Oral Communication - Expresses information (e.g., ideas or facts) to individuals or groups effectively, taking into account the audience and nature of the information (e.g., technical, sensitive, controversial); makes clear and convincing oral presentations; listens to others, attends to nonverbal cues, and responds appropriately.
4. Problem Solving - Identifies problems; determines accuracy and relevance of information; uses sound judgment to generate and evaluate alternatives, and to make recommendations.

Your resume and supporting documents must also clearly demonstrate that you have the experience listed to qualify for this position.

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 by a panel of subject matter experts 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 Administrator
• Decision Making
• Flexibility
• Influencing/Negotiating
• Integrity/Honesty
• Interpersonal Skills
• Learning
• Oral Communication
• Problem Solving
• Product Adaptation 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.

Interview: Applicants who pass the resume review may be invited to an interview with an interview panel and/or selecting official.

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

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.

Well 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)

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)

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. If your resume or transcript is incomplete or does not support the responses you provided in your online questionnaire, or if you fail to submit all required documentation before the vacancy closes, you may be rated 'ineligible', 'not qualified', or your score may be adjusted accordingly.

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

• Resume
  • Your resume must not exceed two (2) pages. If your resume exceeds the two-page limit, you will be removed from consideration for this announcement. The resume and required supporting documentation should provide the minimum qualifications and relevant experience for the announced position. 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.
• 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.
• 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, 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.
• 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. DOJ also encourages eligible Schedule A applicants to submit their resumes.

Next steps