SharePoint & Excel (Power Platform) Developer — Timesheets, Leave & Attendance

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