Client Onboarding Data Specialist

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 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!