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