




Job Summary: Responsible for transcription, calculation, and operationalization of labor data, with emphasis on verification and proficiency in intermediate/advanced Excel. Key Highlights: 1. Focus on transcription and detailed analysis of labor data 2. Process optimization with proficiency in intermediate/advanced Excel 3. Rigorous verification to ensure data accuracy * **Data Transcription:** Typing and converting timecard data (physical or PDF) into Excel and/or PJE\-CALC. * **Work Schedule Calculation:** Analysis of entry, exit, and break times to determine overtime, night shift premiums, and intraday breaks. * **Operationalization:** Inputting awarded benefits and variable data into the PJE\-CALC system. * **Verification:** Reviewing spreadsheets to ensure no typing errors occurred (attention to detail is critical). **Intermediate/Advanced Excel**: Proficiency in time formulas, conditional functions (IF, SUMIFS), and data formatting is essential. * **Essential:** Intermediate/Advanced Excel (focus on date/time formulas and data handling). * **Preferred:** Course in Labor Calculations or Basic PJE\-CALC.


