Sr. Data Integration & Automation Manager

Job Description

Job Description

About The CAM Collective

The CAM Collective (TCC) is a specialized advisory and operations firm focused on community association management (CAM) transitions. We work with sellers, buyers, and management companies to ensure seamless, data-driven deal closings across a growing national portfolio. Our team moves fast, operates with precision, and is building the infrastructure to scale.

Data & Automation | Remote / Hybrid | Full-Time — $150,000 base + 12–15% performance bonus

This is a hands-on leadership role at the center of TCC's data infrastructure: designing and building an internal automation tool that transforms how deals are processed, owning current-state data mapping across multiple source systems, and directly managing a Data Analyst. It's a rare opportunity to architect something from the ground up with real operational impact from day one.

• 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
• Strong documentation skills, producing clear, usable artifacts
• Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent experience)

• Experience with property management, real estate, or HOA/CAM platforms (e.g., CINC, Vantaca, AppFolio, Buildium, or similar)
• Advanced degree in a related field
• Comfort working in a startup-like environment where the roadmap evolves

Benefits

• $150,000 base salary
• 12–15% annual performance bonus
• Comprehensive benefits package (health, dental, vision, 401(k))
• Remote-friendly work environment
• Full ownership over data infrastructure and automation strategy
• Direct line to senior leadership and meaningful influence on how the business scales
• Opportunity to build a team as deal volume grows