Information Technology Specialist (Data Architect)

Full Job Description

The OIG's Office of Data Analytics is seeking highly motivated technology professionals to support the agency's mission to promote integrity, efficiency, and accountability within the Department of Justice.

The Office of Data Analytics collaborates across the OIG and is committed to innovation and delivering results. The incumbent will serve as a Data Architect in the Office of Data Analytics.

We offer excellent work-life flexibilities.

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.

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.

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) ________________________________________________________________________________________________ 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 period during 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.

Major 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:

develop the OIG's capability to manage large datasets to support various OIG projects;

develop models to automatically identify indicators of fraud and other high-risk programs and/or transactions; and

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.