Data Analyst

Jobtailor; Chicago (IL); On-site; USD 65,000 - 85,000; Full time

Job summary

Jobtailor is seeking a data analyst to extract, normalize, and organize data across active deals, ensuring completeness and accuracy for handoff. You will run QA on automation outputs, maintain mapping files, and support master data dictionary updates.

Ideal candidates have 2+ years in data analytics or similar, strong Excel/Google Sheets skills, SQL experience, and a meticulous eye for multi-system data environments.

Qualifications

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

Responsibilities

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

Skills

Attention to detail

Multitasking

Education

Bachelor's degree in Data Analytics, Information Systems, Business, or related field

Tools

Excel

SQL

Job description

Responsibilities

• 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

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

Core Competencies

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.