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