Sr. Data Application Developer

barrowwise; Washington (District of Columbia); On-site; USD 80,000 - 110,000; Full time

Job summary

Barrowwise in Washington, DC is seeking an individual for a role that focuses on data analysis, reporting, and support in a government setting. Candidates should have expertise in SQL, Aqua Data Studio, and Excel, along with a Bachelor’s degree in a related field and at least 8 years of experience.

This role offers the opportunity to grow within a supportive environment where commitment to diversity is a priority. U.S. Citizenship is mandatory, and the position requires on-site work.

Qualifications

• U.S. Citizenship is required.
• Minimum of 8 years of data and statistical experience.
• Expert proficiency in Aqua Data Studio and MS Excel.

Responsibilities

• Provide business intelligence reporting and analytical support.
• Develop, install, and configure applications, providing support.
• Query internal and external databases to mine data.

Skills

SQL

Data analysis

Aqua Data Studio

Excel

Statistical methods

Education

Bachelor’s Degree in computer science or related field

Tools

Tableau

Qlik

Job description

Enjoy problem‑solving? Barrow Wise Consulting, LLC is for you.

Responsibilities

• 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 standardised 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 analyse 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 minimise errors.
• Work on‑site in Washington, DC.

Qualifications

• 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 Studio and MS Office Suite, including but not limited to Excel and MS Access. SQL knowledge of relational databases, Oracle, Server Query Analyzer, lookups, macros, 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.

Barrow Wise is an equal opportunity, drug‑free employer committed to diversity in the workplace. Minority/Female/Disabled/Protected Veteran/LBGT are welcome to apply.