Clarification from the agency

Status Candidates (Merit Promotion and VEOA Eligibles)

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 successfully pass and are subject to random drug screenings.
• You must be registered for the Selective Service, if applicable.
• 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 in the federal sector, or the equivalent in the private sector. 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.

________________________________________________________________________________________________
ADDITIONAL INFORMATION:

The Career Transition Assistance Plan (CTAP)/Interagency Career Transition Assistance Plan (ICTAP). The CTAP/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 CTAP/ICTAP consideration, you may receive selection priority if: 1) this vacancy is within your CTAP/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 CTAP/ICTAP eligibility or a copy of your separation personnel action form. Additional information about CTAP/ICTAP eligibility is at: www.opm.gov/policy-data-oversight/workforce-restructuring/employee-guide-to-career-transition/

** PROBATIONARY INFORMATION: As a condition of employment for accepting this position, you may be required to serve a 1-year probationary or 2-year trial periodduring which we will evaluate your fitness and whether your continued employment advances the public interest. In determining if your employment advances the public interest, we may consider:- Your performance and conduct;- The needs and interests of the agency;- Whether your continued employment would advance organizational goals of the agency or the Government; and- Whether your continued employment would advance the efficiency of the Federal service.

Upon completion of your probationary or trial period your employment will be terminated unless you receive certification, in writing, that your continued employment advances the public interest.

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 a review of your application by a panel of subject matter experts. You will be assessed on the following competencies :

1. Data Management
2. Data Architecture
3. Database Administrator
4. Product Adaptation Expertise

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

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

• 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.
• SF-50 documentation (if applicable)
  • Must document (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.
• 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 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.

Next steps