Sr. Data Analyst

The Sr. Data Analyst will support Barrow Wise’s DHS – Customs & Border Protection Border Enforcement Strategic Planning Analysis Directorate /Systems Division (SD) project and perform the following duties:

1. Provide business intelligence reporting and analytical support through data mining techniques and pulling data from database systems such as Microsoft SQL Server or Oracle.
2. Maintain state-of-the-art knowledge of technology, processes, methodologies, procedural solutions, and products used by or are applicable to the needs of the CBP; identify possible solutions, develop evaluation criteria, evaluate possible solutions, and recommend a solution based upon the evaluation. As appropriate, the recommended solution will include short, mid and long-term solutions and actions and will recommend a migration path; define and continually refine metrics to be used in the assessment of procedures; review and interpret government directives and regulations; and provide technical advice and assessments or impacts on non-web-based application software and hardware requirements
3. Install and configure applications; provide second-tier support
4. Provide professional knowledge of various theories and concepts and in-depth technical knowledge of quantitative methods of analytical, mathematical, or statistical principles and practices for U.S. government programs.
5. Knowledge of analytical processes, such as setting up the problem, conducting background operation research, collecting and reducing data, displaying data for analysis, formulating mathematical expressions, and drawing conclusions.
6. Perform quantitative and qualitative analysis, data quality assurance, and develop graphics and reports based on analyzing and interpreting formative and summative operational and management program statistics and capabilities.
7. Provide support for the production of trends analysis using CBP enforcement and intelligence data.
8. Oversee, train, and provide Project Specialists with effective technical techniques, advice, and directions for short- or long-term major ah-hoc projects.
9. Create, maintain, and update various CBP databases and Excel spreadsheets to track historical data on CBP operational intelligence.
10. Perform statistical percent change analysis and projections.
11. Able to utilize advanced Structure Query Language (SQL) functionalities in Aqua Data Studio Application and complex Excel formulas to research and produce valuable statistics from large data sets.
12. Generate new and/or modify existing CBP standardized and canned reports to provide statistical reports with percent change analysis and projections.
13. Write and maintain complex SQL queries for data mining from various internal and external databases.
14. Manipulate large data sets to develop statistical models and methodologies in a fast-paced environment.
15. Give briefs on statistics, analyses, and projections to Senior U.S. Government Officials.
16. Ensure data integrity in enforcement systems and provide recommendations on improving the integrity of the systems.
17. Conduct analysis research and analyze CBP’s datasets for system and processing errors.
18. Able to investigate data anomalies to determine root causes.
19. Write summary white papers of the findings and present the issues and recommendations via System Change Requests to ensure the data integrity of CBP’s systems.
20. Query information in the enforcement systems to verify data is accurate and complete information, and support various requests and reporting requirements.
21. Define and document data quality assurance standard reports within CBP systems to address data issues and minimize errors.
22. Write and manage all new and/or existing Standard Operating Procedure (SOP) manual training documents for the Statistics Data Integrity (SDI) Unit, including, but not limited to, Daily, Weekly,
23. Monthly, and Data Quality reports.
24. Work on-site in Washington, DC.