Senior Data Analyst with Security Clearance

Senior Data Analyst (EO) with an ability to provide analytical support services for the agency's Human Resources department. Carry out data collection and analysis activities, interpret data and analytic results, development, and vet recommendations on Human Capital, such as promotion, attrition, hiring, and total composition rates compared to other agencies. Perform most work independently in a senior, non-managerial role. The EO analyst will perform the following functions:
• The candidate will perform data statistical analysis for the Equal Opportunity & Diversity Office (EO) focusing on diversity initiatives including demographic data reporting.

• Develop and deliver reports and presentations to a variety of audiences throughout client agency, to include senior leaders. Analytical tools used Tableau or PowerPoint for visualizations; SQL and Excel for pulling data and analyzing percentage shares/rates of client workforce population.

• Analyze data using percentage rates and shares to show historical and present trends for annual and adhoc data calls (See list below for mandatory annual data calls)

• Utilize, develop and deliver queries and reports from the client's HRIS system to present to client. (myHR is the main system pulled from, utilizing SQL to access and pull the data), using appropriate data science and business intelligence tools such as MySQL, Python/C , Tableau, PowerPoint, and Excel

• Identify, collect, and analyze data; then report on findings concerning triggers and barriers to equal employment opportunities and an inclusive workplace, the current and historical status of the customer's workforce metrics, and employee sentiment for historical trends and projections

• Display analytic results in text and visually using appropriate data science, business intelligence, and visualization tools, such as Python, R, SQL, Tableau, PowerPoint, Excel, and communicate results to client audiences at all levels with presentations and briefings

• Administer quality control and process improvement activities, including data entry and data cleanup before doing proper analysis

• Collect, analyze, and report data to enable the Government to complete required reports such as MD-715, No FEAR, ODNI Annual Report to Congress, Disabled Veterans, FEORP, CDIP, etc.

• Create monthly diversity dashboards to display demographic profiles for each DIA organization.

• Provide EO quarterly reports as required.

• Prepare and submit ad hoc workforce diversity reports displaying quick-turn data analytic efforts based on project requirements (e.g. barrier analysis).

• Extract and compile data from Government data sources. Create and administer DIA's PULSE survey tool and resulting reports.

• Perform data management and analysis for quarterly and annual reports. Annual reports to be familiar with:

• MD 715

• Annual Demographic Report, also known as 'ADR'

• Disabled Veterans Affirmative Action Program, also known as 'DVAAP' (Another EEOC mandated report; Analyst is only responsible for the data portion of report) Other internal and adhoc reports that are commonly asked for:

• Promotion Analysis Reports

• Hiring and Attrition Reports

• Student Demographic Reports

• Demographic Breakdowns by Directorates Requirements

• Bachelor's Degree in data analytics or equivalent and minimum experience

• 8+ years in business (or data) analytics

• Experience querying and joining data using SQL and Python.

• Advanced knowledge of Excel

• Experience analyzing and producing EO reports (e.g. MD 715, DVAAP, Annual Demographic Report, etc.)

• Experience preparing quick-turn data analytics based on project requirements (e.g. barrier analysis).

• Experience using data science, business intelligence, and visualization tools: SQL, Python, R, Tableau, PowerPoint, Excel. Preferred skills:

• Experience in applying analytics best practices to human capital problems and hypotheses

• Experience with the Intelligence Community (IC)

• Experience with Workforce/Talent Management/Analytics

• Ability to communicate results to client audiences at all levels with presentations and briefings
Clearance requirements:

• Must have an active TS/SCI at the time of hire, and willing/able to get CI Polygraph