Under supervision of the Sr. Project Specialists, provide knowledge of, and skills in applying a wide range of theories, concepts, and in-depth technical knowledge of quantitative methods and methods of analytical, mathematical, or statistical principles and practices to programs; and knowledge of analytical processes, such as: setting up the problem, conducting background operation research, collecting and reducing data, and displaying data for analysis activities. Perform quantitative and qualitative analysis, data quality assurance, and develop graphics and reports based on the analysis and interpretation of formative and summative operational and management program statistics and capabilities. The Project Specialist must be self-motivation, and excellent communication skills, and strong analytical and troubleshooting skills are a must have. The Project Specialist will need to be comfortable working in a fast paced environment with shifting priorities, vague requirements, rapid iterations, and commutations with Senior Officials. Provide support for the production of trends analysis using apprehensions and intelligence data. Required to create, maintain, and update various Access databases and Excel spreadsheets for tracking operational intelligence historical data. Perform statistical percent change analysis and projections. Able to utilize advanced Structure Query Language (SQL) functionalities in Application and complex Excel formulas to research and produce useful statistics from large set of data results. Generate new and/or modify existing standardized and canned reports to provide statistical reports with percent change analysis and projections. Write and maintain complex SQL queries for data mining from various internal and external databases. Manipulate large data sets to develop statistical models and methodologies in a fast paced environment. Give briefs on statistics, analyses, and projections to Senior Officials. Able to prepare and present technical briefings, white papers, executives summaries, and other communications vehicles to Senior Officials to achieve goals and objectives. Ensure data integrity in enforcement systems and provide recommendations on improving the integrity of the systems. Conduct analysis research and analyze datasets for system and processing errors. Able to investigate data anomalies to determine root causes. Independently write brief summary white papers of the findings and present the issues and recommendations via System Change Requests to ensure data integrity. Query information in the enforcement systems in order to verify accurate data and complete information, and support various requests and reporting requirements. Must be able to define and document data quality assurance standard reports within systems to address data issues and minimize errors. Able to assistant in writing all new and/or existing Standard Operating Procedure (SOP) manual training documents for the Unit, including, but are not limited to: Daily, Weekly, Monthly, and Data Quality reports. Proficiency in MS Office Suite, including but not limited to Excel, MS Access. SQL, knowledge of relational databases, Oracle, Server Query Analyzer, v-Lookups, Macro, VBA and Visual. 4 years and above experience in the functions described above. Bachelor’s degree in computer science, information systems, mathematics, or a related field. An additional four years of relevant experience may be substituted for the bachelor’s degree.

Job Type: Full-time

Pay: $72,035.00 - $79,064.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Paid time off

Experience level:

• 4 years

License/Certification:

• PMP (Preferred)

Ability to Commute:

• Washington, DC 20004 (Required)

Ability to Relocate:

• Washington, DC 20004: Relocate before starting work (Required)

Work Location: In person