Enjoy problem-solving, need a venue to display your creativity, and emerging technologies pique your interest; if so, Barrow Wise Consulting, LLC is for you. As a multi-disciplined leader, you understand the gifts that set you apart from everyone else. Demonstrate innovative solutions to our clients. Join Barrow Wise Consulting, LLC today.

Responsibilities:

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

• Provide business intelligence reporting and analytical support through data mining techniques and pulling data from database systems such as Microsoft SQL Server or Oracle.
• 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
• Develop, install, and configure applications; provide second-tier support
• 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.
• 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.
• Create, maintain, and update various CBP databases and Excel spreadsheets to track historical data on CBP operational intelligence.
• Perform statistical percent change analysis and projections.
• 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.
• Generate new and/or modify existing CBP 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 U.S. Government Officials.
• Ensure data integrity in enforcement systems and provide recommendations on improving the integrity of the systems.
• Conduct analysis research and analyze CBP's datasets for system and processing errors.
• Able to investigate data anomalies to determine root causes.
• 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.
• Query information in the enforcement systems to verify data is accurate and complete information, and support various requests and reporting requirements.
• Define and document data quality assurance standard reports within CBP systems to address data issues and minimize errors.
• Work on-site in Washington, DC.

• U.S. Citizenship
• Bachelor's Degree in computer science, information systems management, mathematics, engineering, or related field.
• Minimum of 8 (eight) years of data and statistical experience.
• Have and maintain CBP/DHS clearance
• Expert proficiency in Aqua Data Studios and MS Office Suite, including but not limited to Excel and MS Access. SQL, knowledge of relational databases, Oracle, Server Query Analyzer, v Lookups, Macro, and SharePoint.
• Must be experienced with Procedural Language (PL) /Structured Query Language (SQL), Qlik, and Tableau
• Must have prior experience writing database functions and stored procedures.
• VBA and Visual Basic, intermediate qualifications are needed to create automated statistical databases