About the role

The Data Analyst is responsible for extracting, normalizing, and validating data across active deals to ensure accuracy in deal closings. They also perform QA testing on proprietary automation tools and maintain data mapping documentation.

What they look for

Data Mapping Data Extraction Data Validation Quality Assurance Excel Google Sheets SQL Data Normalization Exception Reporting Version Control

Requirements

Requires a bachelor's degree in a related field and 2+ years of experience in data analysis or operations. Proficiency in SQL and advanced Excel/Google Sheets is essential.

Benefits

Health Insurance Dental Insurance Vision Insurance 401(k) Performance Bonus Remote-friendly work environment Mentorship

Full description

About The CAM CollectiveThe 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 — $80,000 base + 5–8% performance bonus

The RoleThis Data Analyst is the hands-on executor of data mapping, extraction, validation, and quality assurance across all active deals, reporting directly to the Sr. Data Integration & Automation Manager. It's a critical role — the accuracy of this work directly impacts deal timelines and client outcomes — and one that plays a key part in testing and refining TCC's proprietary automation tool as it's built and deployed.

What You'll Do• Extract, normalize, and organize data from source systems for each active deal

Execute current-state data mapping documentation under the direction of the Sr. Data Integration & Automation Manager
Prepare and validate data for transition pathway execution, ensuring completeness, accuracy, and consistency before handoff
Perform data quality checks and generate exception reports for review
Conduct QA testing on automation tool outputs — log issues, verify fixes, and document results
Maintain organized, version-controlled data mapping files and support the Manager in building and updating the master data dictionary
Flag data anomalies, system discrepancies, or mapping gaps proactively
Assist Project Managers with data-related questions on active deals

What We're Looking For (Required)• 2+ years of experience in a data analyst, data operations, or similar role

Advanced proficiency in Excel or Google Sheets, including pivot tables, VLOOKUP/XLOOKUP, and data validation
Experience with SQL for data extraction and querying
Familiarity with data mapping concepts and multi-system data environments
High attention to detail and ability to manage multiple concurrent work items across different deals without losing accuracy
Bachelor's degree in Data Analytics, Information Systems, Business, or a related field (or equivalent experience)

Nice to Have• Experience with property management software or real estate data systems

Comfortable in a fast-paced, remote environment with evolving processes

Compensation & Benefits• $80,000 base salary

5–8% annual performance bonus
Comprehensive benefits package (health, dental, vision, 401(k))
Remote-friendly work environment
Hands-on experience building automation infrastructure from scratch
Direct mentorship from a senior data leader
Growth opportunity as the team and deal volume expand