Sr. Data Integration & Automation Manager

HOA INC
Chicago, United States of America
3 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 150K

Job location

Chicago, United States of America

Tech stack

Automation of Tests
Information Systems
Information Engineering
Data Infrastructure
Data Integration
ETL
Data Mapping
Data Migration
Document-Oriented Databases
Python
SQL Databases
Systems Integration
Technical Data Management Systems
Information Technology
No-code Tools
low-code
Data Management
Data Pipelines

Job description

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. What You'll Do

  • 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)

Nice to Have

  • 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 & conditions

Pulled from the full job description

  • 401(k)
  • Health insurance
  • Vision insurance
  • Dental insurance, Compensation & 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

About the company

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

Apply for this position