Client Onboarding Data Specialist

AllianceHCM; The Woodlands (TX); On-site; USD 70,000 - 100,000; Full time

Benefits offered by this job

Health insurance

401k with employer match

Personal and professional development

Help build the tax team

Entrepreneurial culture

Job summary

Alliance HCM seeks a Client Onboarding Data Specialist to guide clients’ HR teams through legacy data requirements and establish transformation rules. You will manage extraction, cleansing, transformation, and loading of historical HR and payroll data into Alliance HCM’s platform, ensuring accuracy and a smooth cutover.

You’ll profile data, validate algorithms, reconcile data, and document processes, working with project managers and specialists to optimize templates and automated workflows for

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

• Extract, cleanse, transform, and load data from legacy HR and payroll systems into Alliance HCM platform.
• Oversee data extraction and address anomalies, missing values, or formatting errors.
• Profile data, validate algorithms, and manually reconcile data before imports.
• Coordinate with project manager and specialists for hand-offs and documentation.
• Optimize data migration templates, scripts, and automated workflows.

Skills

Attention to detail

Analytical thinking

Communication with clients' HR teams

Quality assurance

Documentation

Education

Experience-based role; no degree specified

Tools

ETL processes

Relational databases

Microsoft Excel

SQL querying

Python/Databricks (bonus)

Job description

Alliance HCM is looking for a full-time Client Onboarding Data Specialist who's comfortable communicating with clients' HR teams and helping them accurately integrate their legacy data into our system. Based in The Woodlands, TX, you'll help make our integration processes smoother and more efficient. Keep reading to learn more and see if you'd thrive as our Client Onboarding Data Specialist!

Quick Info

Pay: Based on experience and qualifications

Perks & Benefits

• 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

Client Onboarding Data Specialist: The Highlights

You’ll provide clients' HR data teams with invaluable guidance related to legacy data requirements, establishing transformation and mapping rules, and working with high volumes of historical employee data. Attentive to detail, you’ll oversee the proper extraction, cleansing, transformation, and loading of data from clients' legacy HR and payroll systems into our platform. You’ll help the HR teams learn the proper procedures and coordinate with functional team members to identify and resolve any anomalies, missing values, or formatting errors.

With a focus on accuracy and thoroughness, you’ll profile data, validate algorithms, and manually reconcile the data before systemic imports. You’ll also manage formal hand-offs to the project manager and relevant specialists, providing them with the technical documents they need to ensure a smooth cutover and verify system readiness. One of our goals is to continuously improve, and you’ll strategically optimize our data migration templates, scripts, and automated workflows to make our extraction and formatting processes even more efficient.

What You Need

• 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

Familiarity with automated data testing frameworks or scripting languages like Python or Databricks would be a bonus! Experience migrating data from legacy HCM or payroll platforms or working with HRIS data models and payroll structures would be preferred. Knowledge of data governance programs or PII compliance frameworks would be ideal.

At Alliance, we’re on a mission to be the largest independent human capital management (HCM) company in the U.S.! We empower small to mid-sized businesses with our innovative, cloud-based technology and unique single-database platform for managing payroll, HR, benefits, onboarding, and more. As the second-largest privately held payroll provider in the nation, we’re dedicated to delivering top-notch HCM solutions. When you join our dynamic team, you’ll find more than just a job; you’ll be part of a supportive community that celebrates your success and inspires you to reach new heights. Let’s grow together and make a lasting impact!