Sr. Data Analyst

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

Benefits offered by this job

Competitive compensation packages

Excellent benefits

Growth opportunities

Job summary

Barrowwise is seeking a qualified candidate in Washington, DC, for a crucial data analyst role involving business intelligence reporting and extensive data analysis. The ideal applicant will possess at least 8 years of experience in data and statistical fields and must have U.S. Citizenship.

Responsibilities include providing analytical support, developing statistical models, and maintaining data integrity across various systems. Strong skills in SQL and proficiency in Aqua Data Studio are essential for success in this position.

Qualifications

• Minimum of 8 years of data and statistical experience.
• Must be experienced with PL/SQL, Qlik, and Tableau.
• U.S. Citizenship required.

Responsibilities

• Provide business intelligence reporting and analytical support.
• Install and configure applications; provide second-tier support.
• Oversee, train, and guide Project Specialists.

Skills

Statistical analysis

SQL programming

Data mining

Project management

Data quality assurance

Excel proficiency

Data visualization (Qlik, Tableau)

Education

Bachelor's Degree in relevant field

Tools

Aqua Data Studio

MS Office Suite

Oracle

SharePoint

Job description

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.
• 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.
• 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.
• Provide support for the production of trends analysis using CBP enforcement and intelligence data.
• Oversee, train, and provide Project Specialists with effective technical techniques, advice, and directions for short‑ or long‑term major ah‑hoc projects.
• 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.
• 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, Monthly, and Data Quality reports.
• Work on‑site in Washington, DC.

Ideal Candidate

• 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 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.

Benefits

We offer competitive compensation packages, excellent benefits, and unique opportunities for growth and advancement.

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.