Jr Data Analyst

Responsibilities:

• Conduct annual analysis of performance management results scores, by component, to determine ratings distributions by component, occupation, work-level and Government Grade and demographic group using  reporting categories. Analysis shall be conducted both by adjective rating level and score rating level to identify trends, areas of potential adverse impact and, where appropriate, proposing follow-on root-cause analysis within the Defense components with DCIPS employees.
• Conduct annual analysis of performance-based payouts of base pay and bonuses. Base pay analyses shall include payment of performance-based pay increases including Pay- for-Performance base pay increases and other increases such as DCIPS Step Increases (DQI) and DCIPS Sustained Quality Increases  that may occur in other Defense components with DCIPS employees.
• Conduct analyses of the use and payment of other compensation elements, including overtime payments, deployment incentives, recruitment incentives, retention incentives, relocation incentives, language pay and incentives, and other allowances and differentials, that will be used to assess compliance with Departmental policy, consistency in the application of policy, and effectiveness in achieving goals and objectives of the Department. This will occur on annual basis or when needed.
• Continue development work on a predictive payroll model to forecast future impact of workforce dynamics such as attrition, hiring patterns, promotion rates on future payroll costs and workforce distributions. This will occur on a quarterly basis.

Key Skills:

• Statistics. 
• Excel. 
• SQL Structured Query Language.
• Python. 
• Data Visualization. 
• Presentation skills. 
• Problem-solving and critical thinking skills.