Legacy Data Specialist

Alliance HCM is hiring a full‑time Legacy Data Specialist to work from its office in Shenandoah, TX. The role focuses on onboarding legacy HR and payroll data for clients using our cloud‑based single‑database platform.

• 100% paid health, vision, dental, life, and LTD insurance
• 401k with employer match
• Personal and professional development
• Help build and shape a great tax team
• Entrepreneurial culture

Oversee the accurate, efficient, and timely migration of legacy HR and payroll data into our platform. Work with clients’ HR staff to extract, cleanse, transform, and load high‑volume historical employee data, proactively identifying and resolving data discrepancies, missing values, and formatting errors. Conduct thorough data profiling, manual reconciliation, and algorithmic validation before systemic imports, and coordinate formal hand‑offs to the project manager with required technical documentation.

Continuously improve migration templates, scripts, and workflows to enhance efficiency.

• 3+ years of experience in data migration, database administration, or data analysis
• Advanced proficiency in ETL processes, relational database structures, and Microsoft Excel
• Working knowledge of SQL querying
• Familiarity with data governance principles and secure handling of sensitive PII
• Sharp attention to detail with a methodical approach to quality assurance and documentation
• PREFERRED – Experience migrating data from legacy HCM or payroll platforms
• PREFERRED – Knowledge of automated data testing frameworks, scripting languages like Python or Databricks, and/or HRIS data models and payroll structures
• PREFERRED – Familiarity with data governance programs or PII compliance frameworks