Legacy Data Specialist

Pay is based on experience. Keep growing within the industry and help ensure daily success as our Legacy Data Specialist!, You'll oversee the accurate, efficient, and timely migration of legacy HR and payroll data into our platform, working with clients' HR staff as needed to ensure smooth integration. This role ensures that high volumes of historical employee data are properly extracted, cleansed, transformed, and loaded into the system, supporting functional team members as needed in proactively identifying and addressing data discrepancies, missing values, and formatting errors. You'll also work with the clients' HR teams to learn legacy data requirements and create customized data transformation and mapping rules.

Before any systemic import, you'll perform thorough data profiling, manual reconciliation, and algorithmic validation to verify that all data is accurate and complete. When ready, you'll oversee the formal data hand-offs to the project manager and provide them with the required technical documents. You'll also find ways to improve and optimize our migration templates, scripts, and workflows, helping make every day slightly more efficient and timely.

Do you have experience in Technical documentation?, * 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
• 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

Pulled from the full job description

• Health insurance
• 401(k) matching
• Vision insurance
• Dental insurance
• Disability insurance, Our benefits package offers:
• 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

At Alliance HCM, 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. Now we're hiring a full-time Legacy Data Specialist to join our office in Shenandoah, TX and support clients in onboarding their legacy HR and payroll data into our system., 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! Take the first step towards becoming our Legacy Data Specialist by completing our initial application today!