IC/LE Data Analyst
Number of Positions: One (1)
Clearance: TS/ with SCI
Location : Washington, D.C.
Technical Skill: Expert with Excel, large data sets, and reporting
-
Advanced Formulas
-
Data, Power Query, Tables and Formatting
-
Conditional Formatting
-
Advanced Charting
-
Pivot Tables and Pivot Reporting
-
VBA and Macros
-
Data Tables, Simulations and Solver
-
Integrating Excel with other tools and optimizing Excel
Job Experience :
-
Top Secret Security Clearance from a Single Scope Background Investigation (SSBI) with Sensitive Compartment Information (SCI) access approval eligibility
-
Bachelor's Degree in Business and Management, Statistical Analysis, Mathematics, Accounting, Technology Management , or Science
-
5 years of specialized experience in Advanced Excel Skills
-
Providing expert Excel and database management and reporting skills for large data set
-
Provide business process analysis, requirements analysis, business process engineering, or statistical analysis within the federal intelligence, defense, or law enforcement community
-
Fusion Center experience with IC and LE databases
-
Experience using advanced Excel skills to create Microsoft Excel spreadsheets and pivot tables, PowerPoint presentations and demonstrative graphics, and SharePoint lists and workflow tools
-
Providing data visualization tools and analytical applications
-
Use of business analytics qualitative and quantitative techniques and processes
-
Designing and conducting comprehensive management and program studies where the boundaries are broad and difficult to determine and to develop logical, clear, and well documented analyses, recommendations, and conclusions
-
Providing expert business process analysis, requirements analysis, business process engineering, communications, and training support
-
Data analysis ( including written or verbal information ), risk assessment, and formulation of recommendations that align to organizational goals
-
Coordination and performance of in-depth studies involving program development, assessment, and strategic planning
-
Translating and communicating complex subject matter between technical and non-technical audiences
-
Providing critical thinking and problem-solving skills
-
A highly motivated team player working well independently and in a team environment through collaboration, strong communication skills, and team management effectiveness
-
Researching, analyzing, interpreting, and presenting existing or newly developed reports ( data, dashboards, graphs, charts ), guidelines, directives, policies, etc., in order to obtain accurate and relevant information