Impress employers and recruiters.
Choose from hundreds of resume examples.

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

This Data Analyst role is a critical position responsible for the hands-on execution of data mapping, extraction, validation, and quality assurance for all active deals. The role directly impacts deal timelines and client outcomes, and plays a key part in testing and refining the company's proprietary automation tool.

Responsibilities

• Extract, normalize, and organize data from source systems for each active deal
• Execute current-state data mapping documentation
• 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, including logging issues, verifying fixes, and documenting 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

Requirements

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

Skills

• Excel
• Google Sheets
• Pivot tables
• VLOOKUP
• XLOOKUP
• Data validation
• SQL
• Data mapping

Location

• Remote
• Hybrid

Work Type

• Full-Time
• Remote-friendly

Experience Level

• 2+ years

Education Level

• Bachelor's degree in Data Analytics, Information Systems, Business, or a related field (or equivalent experience)

Salary/Compensations

• $80,000 base salary
• 5–8% annual performance bonus

Benefits

• Comprehensive benefits package (health, dental, vision, 401(k))
• Hands-on experience building automation infrastructure from scratch
• Direct mentorship from a senior data leader
• Growth opportunity as the team and deal volume expand

About the Company

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