Data Analyst (TS/SCI required)

Founded in 2003, IT Concepts’ core values – customer-centricity, teamwork, drive to deliver, innovation, and integrity – ensure we work together to be the best, realize objectives, and make a positive impact in our communities. We intentionally created and sustain our ITC culture that embraces change, experimentation, continuous learning, and improvement. We bring our design thinking problem-solving approach that challenges assumptions, prioritizes curiosity, and invites complexity to deliver innovative, efficient, and effective solutions. As we continue to grow in the support of our government customers, we are looking for driven and innovative individuals to join our team.

IT Concepts seeks an experienced Mid-Level Data Analyst to support our intel customer. The 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 reporting to ensure complete 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 the DIA Equal Opportunity & Diversity Office (EO) and the Office of the Chief Financial Officer (CFO).

Responsibilities:

• 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 customer requests and customer usage of dashboards and on-demand services. Compile and maintain personnel statistics to provide comprehensive and historical reports 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 submissions and panel evaluations provide annual snapshot of the 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 to ensure 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 meets 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 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.

Location: Reston, VA

Salary Range: The salary for this position is between $165,000 – $185,000 annually. Factors affecting pay within this range may include geography/market, skills, education, experience, and other qualifications of the successful candidate.

Requirements

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

Preferred Skills:

• 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