Microsoft 365 SharePoint + Power Automate Developer for Credential Compliance SystemFreelanceJobs • Canada
Cette offre d'emploi n'est plus disponible
Microsoft 365 SharePoint + Power Automate Developer for Credential Compliance System
FreelanceJobs
- Canada
- Canada
À propos
The solution must be built entirely within Microsoft 365 using SharePoint Online, Microsoft Lists, and Power Automate. Power Apps may be included if needed. No external databases, third-party hosting, or off-platform storage solutions are permitted.
The system must include a structured Employee Master List with one record per employee and a Credential Register List that supports multiple credentials per employee using a relational lookup model. The credential structure must support tracking of credential type, category, contract applicability, state applicability, issue date, expiration date, renewal frequency, validation status, validator, validation date, and whether the item is required for TAMS upload.
Credential artifacts must be stored in a secure SharePoint document library with required metadata, version history enabled, and controlled permissions.
A structured validation workflow must be implemented using Power Automate. The workflow must include status stages: Uploaded, Admin Verified, Compliance Verified, TAMS Ready, and Rejected. The system must prevent users from bypassing validation controls and must route items for approval before they can be marked TAMS Ready.
The solution must generate automated expiration alerts at 90, 60, and 30 days prior to expiration and must provide weekly compliance reporting by contract, state, and site. The system must also include a TAMS-ready packet generation process that compiles only approved and validated documents for a specific employee into a structured export folder.
The database must support scan-to-upload capability. Users must be able to scan documents and upload directly into a controlled SharePoint intake location, such as an Incoming Uploads folder. Upon upload, automation must create or update the associated credential record and route the item for review. Acceptable methods include scanning to email with automated ingestion, scanning directly to SharePoint or OneDrive via copier integration, mobile scanning using Microsoft 365 applications, or a Power Apps upload interface that captures required metadata at upload.
If a Power Apps upload form is implemented, it must require selecting the employee name, credential type, issue date, and expiration date before submission to ensure structured data integrity.
Security is critical. The system must operate under least-privilege access principles with clearly defined roles such as HR Admin, Compliance Approver, Site Supervisor, Recruiting Uploader, and Read-Only Auditor. Supervisors must only see their assigned site employees. Uploaders must not be able to approve credentials. Public sharing must be disabled. Version history, audit logging, and retention controls must be enabled.
The developer must work in a development environment using synthetic test data until final approval of the system structure. Production employee data will not be provided until the configuration is approved.
Applicants must demonstrate prior experience building SharePoint Online solutions that include Microsoft Lists relational design, Power Automate workflows, and structured role-based permissions. In your proposal, please provide examples of similar compliance or workflow systems you have built, describe your architecture approach, outline your security design approach, and provide a proposed timeline with a fixed-price milestone structure
Contract duration of 1 to 3 months.
Mandatory skills: Microsoft SharePoint Development, Microsoft SharePoint Designer, Microsoft SharePoint, Microsoft Office SharePoint Server, Microsoft Power Automate, Microsoft SharePoint Administration
Compétences linguistiques
- English
Avis aux utilisateurs
Cette offre a été publiée par l’un de nos partenaires. Vous pouvez consulter l’offre originale ici.