Expert Assistant

Description

Job Summary: Data Analyst responsible for transcription, shift calculation, and operationalization in PJE-CALC, with a focus on data verification and accuracy. Key Highlights: 1. Expertise in transcription and data conversion to Excel and PJE-CALC. 2. Detailed shift analysis for calculating working hours and additional payments. 3. Proficiency in Intermediate/Advanced Excel is essential. * **Data Transcription:** Typing and converting timecard data (physical or PDF) into Excel and/or PJE\-CALC. * **Shift Calculation:** Analysis of entry, exit, and break times to determine overtime, night shift premiums, and intraday allowances. * **Operationalization:** Inputting granted 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 (with emphasis on date/time formulas and data handling). * **Preferred:** Course in Labor Calculations or Basic PJE\-CALC.