About the Role
We are seeking a Robotic Process Automation (RPA) Developer to design, build, and maintain bots that streamline operational, accounting, and reporting workflows across our real estate portfolio. You will automate high-volume tasks in accounts payable, lease administration, compliance, property management operations, and investor reporting—improving accuracy, cycle times, and scalability.
Responsibilities
Key Responsibilities
- Design, develop, test, and deploy attended and unattended RPA workflows using Power Automate Desktop, UiPath or Automation Anywhere.
- Automate end-to-end processes: intake, validation, transformation, system updates, reconciliations, and exception handling.
- Build integrations with real estate systems (e.g., RMS, Costar or Realquest) and corporate tools (ERP, CRM, SharePoint, Outlook, Teams, SQL).
- Implement robust document processing using OCR/IDP (e.g., UiPath Document Understanding) for invoices, lease abstracts, W-9s, and bank statements.
- Create reusable components, libraries, and templates; enforce development standards and code reviews.
- Configure orchestration, scheduling, and monitoring in UiPath Orchestrator/AA Control Room; set up alerting, logging, and dashboards.
- Partner with business stakeholders to assess processes, quantify ROI, and prioritize an automation pipeline; document PDD/SDD and runbooks.
- Ensure security best practices: credential vaults (CyberArk/Azure Key Vault), role-based access, audit logs, and PII handling.
- Support production operations: incident triage, root cause analysis, SLAs, and continuous improvement.
- Collaborate with Data/BI to feed automated outputs into Power BI dashboards and financial reporting packages.
Real Estate–Specific Use Cases You’ll Tackle
- Accounts Payable: ingest vendor invoices, 3-way match, post to GL in Yardi/MRI, route exceptions, and reconcile vendor statements.
- Lease Administration: extract key terms from leases/amendments, update critical dates, rent steps, and options; automate abstract QA.
- Bank and Cash: daily bank feed ingestion, cash reconciliation, and variance alerts.
- Resident/Tenant Operations: automate move-in/move-out checklists, delinquency outreach, payment posting, and fee reversals under rules.
- Compliance and Lender Reporting: compile DSCR/LTV metrics, covenant tracking, and package submission with document assembly.
- Data Hygiene: normalize rent rolls, COA mapping, unit and tenant IDs, and address standardization for portfolio reporting.
- Market/Regulatory Monitoring: scrape public records, permits, and property tax updates; notify asset managers of changes.
Qualifications
Required Qualifications
- 3+ years building and deploying RPA solutions with UiPath, Automation Anywhere, or Power Automate Desktop.
- Strong skills in workflow design, selectors, queues, exception handling, retry logic, and parallelization.
- Experience with OCR/IDP and document classification/extraction; supervised learning models for template variability.
- Proficiency with SQL and APIs (REST/JSON); ability to connect bots to databases and enterprise systems.
- Solid understanding of accounting workflows (AP/AR, GL postings, reconciliations) and data validation controls.
- Clear communication and documentation skills; ability to translate business processes into technical specs (PDD/SDD).
Preferred Qualifications
- Experience with real estate platforms (Yardi, MRI, RealPage) and Argus Enterprise exports.
- Power Platform (Power Automate cloud, Power Apps), Power BI, and DAX for reporting handoffs.
- Basic scripting/programming: Python or .NET for custom activities, web scraping, and data transformations.
- Process mining (Celonis, UiPath Process Mining, Power Automate Process Advisor) and task mining for discovery and ROI sizing.
- Familiarity with SOX/internal controls, audit evidence, and secure bot credentialing.
Tools & Tech Stack
- RPA: UiPath, Automation Anywhere, or Power Automate Desktop
- Data: SQL Server/PostgreSQL, Excel/Power Query, SharePoint/OneDrive
- APIs/Integration: REST/JSON, ODBC/ADO, Outlook/Exchange, Teams
- Security: Azure AD, CyberArk/Azure Key Vault, role-based access
- BI/Reporting: Power BI, scheduled refresh, dataflows
