Automation Engineer for Maintenance Management System

Description

We are seeking a highly skilled and experienced AI Engineer or Software Developer to design and implement an automated maintenance management system for a property management agency. The system will streamline tenant maintenance requests, ensuring efficient handling and tracking of issues.
The ideal candidate should have a strong background in workflow automation, web development, and API integrations. A deep understanding of tools like Google Workspace, online forms, and PDF generation is essential.
Project Requirements1. Automated Tenant Communication:
When a tenant sends an email regarding a maintenance issue, they should automatically receive a response with a link to an online form.
2. Online Form Design:The form should:
Capture essential fields:Tenant's NameTenant's Email AddressTenant's Phone NumberLocation of the Maintenance Issue (e.g., kitchen, bathroom)Detailed Description of the Maintenance IssueFile Upload Field for images or videos (mandatory to complete).Ensure all fields are mandatory.Prevent submission until all required fields are completed.
3. Automated Reference Number Generation:
Upon successful form submission, tenants should receive a unique reference number for their maintenance issue.This reference number must be:Automatically updated on the backend Google Sheet alongside all other submitted form data.Included on the downloadable PDF work order created for the contractors.
4. Backend Integration with Google Sheets:
All submitted form data must automatically populate a Google Sheet in real time.The Google Sheet should include:All the details submitted by the tenant.The unique reference number.The data must be clearly organized for the property management team to view and manage.
5. Automatic Work Order Creation:
Once the form data is logged into the Google Sheet, the system should automatically generate a downloadable PDF work order.The work order must include:All details submitted by the tenant.The unique reference number.The PDF should be formatted for easy sharing with contractors.
6. System Efficiency:
The process should be seamless and require minimal manual intervention.The system must ensure data accuracy and security at all stages.Desired Skills and Expertise:The ideal candidate should possess:
Deliverables:A fully functional automated system meeting all outlined requirements.Documentation explaining system functionality, including:Workflow diagrams.Instructions for future updates or troubleshooting.Support for initial deployment and testing.
Timeline and Budget:Timeline: ASAPBudget: Flexible
Application Process:Interested candidates should provide:
A portfolio of similar projects.A brief proposal explaining how they plan to approach the project.An estimated timeline for completing the work.