Onboarding Data Specialist

We're offering our Onboarding Data Specialist experience-based compensation, 100% paid health, vision, dental, life, and LTD insurance, and benefits and perks like a 401k with employer match, personal/professional development opportunities, a dynamic entrepreneurial culture, and the ability to shape a great tax team! If that sounds good to you, keep reading to see if you're the Onboarding Data Specialist we're looking for at our Shenandoah, TX office!, * Leading the accurate, thorough, and efficient extraction, cleansing, transformation, and loading of historical employee data into our system

• Rigorously profiling data, validating algorithms, and manually reconciling high loads of historical employee data from legacy HR and payroll systems
• Collaborating with clients' HR teams to learn legacy data requirements and execute custom transformation and mapping rules
• Managing and continuously improving our data migration scripts, templates, and automated workflows
• Collaborating with functional team members to identify, troubleshoot, and address anomalies, formatting errors, and missing values
• Overseeing formal data hand-offs to the project manager, delivering technical documents, and verifying systemic readiness
• Completing additional responsibilities as assigned

• 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

Our Ideal Onboarding Data Specialist

• Demonstrated experience migrating data from legacy HCM or payroll platforms
• Working knowledge of HRIS data models and payroll structures, PII compliance frameworks, and data governance programs
• Proficiency in automated data testing frameworks or scripting languages (Python, Databricks, etc.)

Pulled from the full job description

• 401(k) matching
• Vision insurance
• Dental insurance
• Disability insurance

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!