Data Analyst

HOATalent

Data Analyst executing data mapping, validation, and quality assurance for TCC’s active deals. Working closely with the Sr.

Posted 7/13/2026full-timeChicago • Illinois • 🇺🇸 United StatesJuniorMid-Level💰 $80,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data extraction, mapping, and quality assurance, with a strong focus on accuracy and detail management in multi-system environments. Proficient in utilizing advanced Excel functions and SQL for data analysis and reporting.

Highest-signal resume keywords

Data MappingSQL Data ExtractionAdvanced Excel ProficiencyData Quality AssuranceAttention to Detail

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data ExtractionData MappingSQLExcelGoogle SheetsData ValidationPivot TablesVLOOKUPXLOOKUPData Quality Checks

Soft Skills

Attention to DetailOrganizational SkillsProblem-Solving

Industry Keywords

Data AnalystData OperationsMulti-System Data EnvironmentsData AnalyticsInformation Systems

Tech Stack

Tools & technologies

SQL

About the role

Key responsibilities & impact

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

Requirements

What you’ll need

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)

Benefits

Comp & perks

$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