Data Warehouse Specialist - OIG

Washington D.C.
Mar 02, 2018
Apr 23, 2018
Full Time
Job Description



     •    Graduation from an accredited four (4) year college or university with a Bachelor’s degree in Computer Science and/or Database Design.  


     •    A minimum of four (4) years thorough knowledge of database and data warehouse technologies, IT principles, concepts, processes, and practices and their application to the conduct of audits, including knowledge of sophisticated IT systems and tools for capturing, analyzing, and integrating large-scale databases   and electronic files and other data mining activities. Thorough knowledge of standard computer applications and statistical/analytical techniques. Knowledge of database environments and server experience including upgrades, data dictionaries, security systems, communication software, end user software,  networks and firewalls. Five (5) years’ experience in Oracle database security and encryption technology.

     •    The ability to acquire specific knowledge of regulations, policies, procedures, guidance, and techniques directly applicable to the Authority's programs and operations.


     •    Oracle Certified Professional (OCP) in 11g and 12c 
     •    Certified Big Data Analytics Specialist
     •    Agile Certified Product Owner/Manager


     •    None

Medical Group:

Satisfactorily complete the medical examination for this position, if required.  The incumbent must be able to perform the essential functions of this position either with or without reasonable accommodations.


This position is the principal database warehouse technical expert and advisor for the Office of Inspector General (OIG).  This position has principal responsibility for design and development of an OIG data warehouse to perform continuous monitoring and analysis to identify fraud, waste and abuse in WMATA. These responsibilities include collecting, reviewing, interpreting, evaluating, and integrating large volumes of data from multiple data sources; using sophisticated IT systems and tools for data mining and statistical analyses and other computer techniques; and conducting, coordinating, and guiding the development and application of advanced computer and statistical techniques. Incumbent serves as the database administrator for both the audit and investigative tracking systems within the OIG and supports the Metro Transit Police Department in forensic and data mining analysis related to their investigations, as needed. Incumbent works independently under general guidelines and supervision from the Senior Information Technology Specialist.                                


     •    Responsible for all OIG data warehouse activities, including design, infrastructure, architecture, application development, reengineering business processes, networks, firewalls and computer operations within the OIG. Tracks a broad range of emerging technologies to determine their maturity and applicability to the           OIG. Assesses the relative impact of emerging technologies to the strategic business needs and interprets their meaning to senior leadership. Participates in overall business technology planning, bringing a current knowledge and future vision of technology and systems as related to OIG current and emerging                   requirements.

     •    Understands OIG core IT competencies and the value they bring to ensure the agency meets goals and objectives. Interacts with internal and external stakeholders to ensure continuous customer satisfaction. Analyzes requests for data mining and statistical analyses, especially 
     •    those involving complaints and/or allegations of fraud, waste, and abuse, and establishes priorities for initiatives and scope of assignments based on such factors as safety, mission impact and technology impact factors.

     •    Designs, develops, and executes strategies, methodologies, and analytical tools for data mining initiatives focused on potentially fraudulent, wasteful, and/or improper activity.;  Conducts special IT research, providing comprehensive assessments of broad, complex, or highly sensitive issues within the Authority.             Develops methods of evaluating the validity, accuracy, and reliability of a broad array and high volume of electronic data and information for translation into business intelligence relevant to the work of the OIG.

     •    Provides essential information and technical assistance to audit teams and investigators, which are responsible for planning, managing, conducting, and reporting on complex information technology audits, reviews and investigations. Takes lead role with investigators and auditors in data mining and other computer-           related analyses and data matching activities. Establishes and maintains procedures related to the Authority's network interface with the OIG server. Ensures appropriate security measures and firewalls are in place. Maintain the OIG case management systems for investigations and audits.

     •    Under direction of OIG auditors and/or investigators, applies information systems audit sampling techniques; analyzes internal controls; conducts forensic analysis; examines financial records, procedures, and administrative controls to ensure that records and policies comply with applicable regulations or                         specifications and that information systems functions are being performed effectively and efficiently.  Ensures information technology reviews adequately assess the effectiveness of technical controls and are in accordance with established criteria and industry best practices for information systems.


The essential duties listed are not intended to limit specific duties and responsibilities of any particular position. Nor is it intended to limit in any way the right of managers and supervisors to assign, direct and control the work of employees under their supervision.

Evaluation Criteria:

Consideration will be given to applicants whose resumes demonstrate the required education and experience. Applicants should include all relevant education and work experience.
Evaluation criteria may include one or more of the following:

  • Personal Interview 
  • Skills Assessments 
  • Verification of education and experience 
  • Criminal Background Check 
  • Successful completion of a medical examination including a drug and alcohol screening 
  • Review of a current Motor Vehicle Report


Washington Metropolitan Area Transit Authority, a Federal contractor, is an Equal Opportunity / Affirmative Action employer.  All qualified applicants receive consideration for employment without regard to race, color, creed, religion, national origin, sex, gender, gender identity, age, sexual orientation, genetic information, physical or mental disability, or status as a protected veteran, or any other status protected by applicable federal law, except where a bona fide occupational qualification exists.  Our hiring process is designed to be accessible and free from discrimination.

This posting is an announcement of a vacant position under recruitment.  It is not intended to replace the official job description.  Job descriptions are available upon confirmation of an interview.

Similar jobs