Data Analyst

Posted Yesterday
Chicago, IL, USA
In-Office
80K-80K Annually
Junior
HR Tech • Professional Services • Real Estate • Consulting
The Role
Execute data mapping, extraction, validation, and QA for deal transitions. Prepare and normalize data, run quality checks, test automation outputs, document issues, maintain version-controlled mapping files, and support project managers to ensure accurate, timely handoffs.
Summary Generated by Built In
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 — $80,000 base + 5–8% performance bonus

The Role

This 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

RequirementsWhat 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

BenefitsCompensation & 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

Skills 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 without losing accuracy
  • Bachelor's degree in Data Analytics, Information Systems, Business, or a related field (or equivalent experience)
  • Experience with property management software or real estate data systems
  • Comfortable in a fast-paced, remote environment with evolving processes
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company

What We Do

HOA Talent is a recruitment and career-advisory platform that connects HOA industry professionals with management companies that prioritize sustainable careers.

Similar Jobs

Capital One Logo Capital One

Data Analyst

Fintech • Machine Learning • Payments • Software • Financial Services
Hybrid
3 Locations
55000 Employees
183K-229K Annually

City of Chicago Office of Inspector General Logo City of Chicago Office of Inspector General

Data Analyst

Information Technology • Other • Automation
In-Office
Chicago, IL, USA
125K-125K Annually

Morningstar Logo Morningstar

Data Analyst

Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
Hybrid
Chicago, IL, USA
11500 Employees
100K-500K Annually

TransUnion Logo TransUnion

Senior Data Analyst

Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
Hybrid
Chicago, IL, USA
13000 Employees
68K-113K Annually

Similar Companies Hiring

Northslope Thumbnail
Artificial Intelligence • Information Technology • Software • Analytics • Consulting • Generative AI
London, GB
100 Employees
Compa Thumbnail
Artificial Intelligence • HR Tech • Software • Business Intelligence
Irvine, California
75 Employees
Amplify Platform Thumbnail
Fintech • Financial Services • Consulting • Cloud • Business Intelligence • Big Data Analytics
Scottsdale, AZ
62 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account