Data Analyst (TS/SCI)

Our client is looking for an experienced Mid-Level Data Analyst to support our Client customer. Analyst will provide advanced data analytics and predictive strategic workforce planning via on-demand, intuitive web-based capabilities and reporting. The candidate will assist with developing standardized data operating procedures and data reporting to ensure full and consistent application across all career fields (CF). The candidate will perform work and tasks that extend to CFs and mission owners and may also extend to DIA Equal Opportunity & Diversity Office (EO), and the Office of the Chief Financial Officer (CFO).

The Data Analyst and team will also provide the following functions:

• Create mechanisms that allow for more self-service, on-demand options for customers, such as dashboards or self-service querying capabilities — at all levels of the Agency — seeking information on Agency personnel statistics to include career field, locations, grade, race/national origin, promotion rates, hiring, attrition, etc. Create a tool to track requests from customers and customer usage of dashboards and on demand services. Compile and maintain personnel statistics to provide comprehensive and historical report on the Agency's workforce. This may also include modernizing, centralizing, and streamlining the self-service access to HR data and strategic workforce analytics dashboard/reporting.

• Support the Senior Executive Management Office (SEMO) by conducting workforce analysis to identify eligible applicant submission and panel evaluation provide annual snapshot of Defense Intelligence Senior Executive Service (DISES) and Defense Intelligence Senior Leader (DISL) population for hiring, attrition, diversity, tenure, and retirement projections; and provide ad hoc analysis and reports DISES and DISL population to SEMO and Agency leadership
• Operate and maintain an Agency HR "data dictionary” to standardize how data is defined and calculated.
• Gather key performance indicators (KPIs) and milestones for OHR's functional areas. Determine data source(s) supporting KPIs and milestones.
• Integrate and implement requirements communicated by Agency leadership, mission owners and career fields for consistency with OHR's dashboard/reporting efforts.
• Conduct predictive strategic workforce analysis to facilitate the Agency's ability to hire, develop, and retain talent in alignment with HR strategy that meet future mission planning requirements at all grade levels for all CFs. Perform advanced analytics across the five pillars of the Talent Management System throughout the enterprise to provide timely and accurate metrics and reports in order to allow the CFs to make data-driven decisions to inform talent analysis, planning, and management. Monitor and report on the health of the CFs, perform data analysis on fill rates, strength, talent pipeline, and anticipated attrition,
• Utilize "Career EXPLORER” and associated talent development tools' quantitative and qualitative data with myHR and other Agency HR Information System data to conduct strategic workforce analytics, including strategic talent acquisition, assignment and placement, and talent continuity.

REQUIRED SKILLS/EXPERIENCE:

• Advanced knowledge of Excel (formulas, pivot tables, etc.)
• Ability to write SQL code; Ability to query tables using SQL and analyze results.
• 5 - 7 Years in data analyst experience
• Experience with SQL, Python (Must be discussed in resume on use and in what positions)

DESIRED SKILLS/EXPERIENCE:

• Master's Degree
• Experience in applying analytics best practices to human capital problems and hypotheses.
• Experience with the Intelligence Community (IC)
• Experience with Workforce/Talent Management/Analytics
• Experience with Tableau highly preferred and stated in resume when used.

EDUCATION LEVEL: Bachelor's Degree in analytics or related field