Job opening: IT Specialist (Data Management)
Salary: $132 368 - 172 075 per year
Published at: Oct 10 2023
Employment Type: Full-time
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.
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: (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.
Requirements
- 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
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.**
Contacts
- Address Audit Division
950 Pennsylvania Ave NW
Washington, DC 20530
US
- Name: Brandie Miller
- Phone: (202) 616-4512
- Email: [email protected]
Map