Design, build, and maintain a proprietary automation tool that streamlines the CAM deal data pipeline from intake through closing
Own current-state data mapping across all source systems involved in deal transitions (property management platforms, CRM, financial systems, association records)
Develop and document data transition pathways for each deal, ensuring accurate data movement between systems
Partner with the TAAS Director to define data standards, naming conventions, and integration protocols across the deal portfolio
Manage the Data Analyst — setting priorities and workload, reviewing data mapping output for accuracy, and providing mentorship and technical development
Serve as the data and automation partner to both Project Managers, translating deal-level requirements into data tasks
Maintain a master data dictionary and living system integration map while identifying and eliminating manual, repetitive data processes
QA automation tool output and iterate rapidly based on deal learnings
Requirements
5+ years of experience in data integration, data engineering, or automation, including at least 2 years in a senior or lead role
Proven experience building automation tools or workflows using Python, SQL, ETL pipelines, or low-code/no-code platforms
Strong background in data mapping and multi-system data migration or integration
Ability to translate operational business requirements into technical data solutions
Experience managing or mentoring junior data team members