Client Data Onboarding Specialist — HRIS & Legacy Data

Alliance HCM; The Woodlands (TX); On-site; USD 65,000 - 95,000; Full time

Benefits offered by this job

Health insurance

Vision insurance

Dental insurance

Life insurance

LTD insurance

401k with employer match

Professional development

Entrepreneurial culture

Job summary

Alliance HCM is seeking a full-time Client Onboarding Data Specialist based in The Woodlands, TX. The role centers on guiding client HR data teams through legacy data integration, defining transformation rules, and managing large volumes of data from legacy HR and payroll systems into our cloud platform.

You will validate data, reconcile issues, and ensure accurate hand-offs to the project manager. The position emphasizes improving data migration processes through templates, scripts, and

Qualifications

• 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 the secure handling of sensitive PII.
• Sharp attention to detail with a methodical approach to quality assurance and documentation.

Responsibilities

• Guide legacy data requirements and establish transformation and mapping rules.
• Oversee extraction, cleansing, transformation, and loading of data from legacy systems into our platform.
• Profile data, validate algorithms, and reconcile data before imports.
• Coordinate with project manager and specialists for smooth cutover and readiness checks.
• Optimize data migration templates, scripts, and automated workflows.

Skills

Data migration

Database administration

Data analysis

ETL processes

SQL querying

Microsoft Excel

Attention to detail

Python

Databricks

Tools

Python

Databricks

HRIS data models

Job description

Alliance HCM is seeking a full-time Client Onboarding Data Specialist based in The Woodlands, TX. The role centers on guiding client HR data teams through legacy data integration, defining transformation rules, and managing large volumes of data from legacy HR and payroll systems into our cloud platform.

You will validate data, reconcile issues, and ensure accurate hand-offs to the project manager. The position emphasizes improving data migration processes through templates, scripts, and