Location Remote — Pakistan / Philippines / India Engagement Contract / Freelance , About Us We’re an Australian engineering consultancy building a SharePoint‑based employee management system : timesheets , leave tracking , attendance/presence , and salary/allowance summaries (non‑payroll). The solution must live in SharePoint Online with strict per‑user privacy and manager/admin oversight . What You’ll Build Employee self‑service : daily time entry by project/job , weekly submission to manager, live leave balance , own data only (no visibility of others). Approvals & workflow : weekly approvals , comments , auto‑reminders/escalations , audit trail , lock after cut‑off . Attendance & presence : start/finish , late/early , overtime , on‑time stats , fixed shift rules , simple reason codes for exceptions. Security : item‑level permissions (creator + manager), admin global view , role‑based access across Employee / Manager / Admin . Reporting : weekly & monthly summaries , per‑employee dashboards , project roll‑ups , export to Excel/PDF . Salary view (non‑payroll) : base salary x attendance/overtime/leave → month‑end summary for review (no payslip generation). Tech Stack (preferred) SharePoint Online / Microsoft Lists (structure, views, JSON formatting, permissions). Power Automate (approvals, reminders, cut‑off/locking, permission breaking/inheritance). Power Apps (Canvas) for a clean web/mobile UI with role‑based screens . Excel ( XLOOKUP , SUMIFS , dynamic arrays , Power Query , Data Validation ) for imports/exports and admin tools. Nice to have : Power BI , Dataverse , Teams integration , Graph API . Must‑Have Skills Advanced Excel : complex formulas, data modelling with Power Query , clean templates, error handling. SharePoint Online : list design, item‑level security , unique permissions , metadata & views , JSON column formatting. Power Automate : multi‑step approval flows , SLA reminders , permission automation , PDF/email outputs . Power Apps (Canvas) : form/UI design, responsive screens, role‑based logic . Documentation & handover : admin guide, user guide, basic SOPs. Clear communication , independence, and on‑time delivery . Deliverables & Timeline Discovery & design (data model, roles, security, mock‑ups). MVP (time entry + item‑level security + basic approval). Approvals & cut‑off , reminders, audit trail. Attendance logic , late/OT rules, exception reasons. Dashboards/exports , leave balances, salary summary view. Pilot, bug‑fixing, training , documentation & handover. How to Apply Email CV + portfolio and include: 3 examples (screenshots or links) of SharePoint/Power Platform workflows you’ve built. A 1‑paragraph approach to achieving item‑level security with manager/admin visibility . Your time‑zone and AEST overlap window. Screening Questions (paste into Indeed) SharePoint security : How would you ensure employees only see their own entries , while managers see their team and admins see all ? (Be specific about item‑level permissions and flows .) Cut‑off & locking : Describe a Power Automate solution that auto‑submits/locks weekly timesheets Friday 5:00 pm AEST , sends reminders, and allows manager override . Data model : What lists/tables would you create (e.g., Employees , Projects , Timesheets , Leave , Approvals , Shifts )? Show key columns and relationships . Excel : Provide a sample formula for remaining annual leave given opening balance , monthly accrual , and days used (handle blanks and negatives robustly). Overtime rules : How would you compute OT only after 9:00–17:30 base hours, and exclude public holidays ? Performance : What do you do when SharePoint lists get large (views, indexing, pagination, delegation limits in Power Apps)? Auditability : How do you keep a tamper‑proof history of timesheet changes and approvals? Deployment : Outline your environment strategy (dev/test/prod), backup , and rollback . Handover : What documentation and training will you provide so non‑technical staff can run it? Risks : Call out the biggest privacy and data‑loss risks and how you’ll mitigate them. Short Indeed Snippet (for the summary box) Build a secure SharePoint‑based timesheet, leave & attendance system. Advanced Excel + Power Automate/Power Apps required. Remote (PK/PH/IN). My recommendation (opinion) Use SharePoint Lists + Power Apps + Power Automate (not a single Excel workbook) for row‑level privacy , approvals , and scalability . Excel should be for import/export and admin tooling , not the system of record. Want me to tailor this with your company name, rate band , and a couple of project screenshots to lift conversion? Happy to tweak tone and length for Indeed’s editor. Job Types: Part-time, Contractual / Temporary Pay: ₹15,000.00 - ₹20,000.00 per month