Legacy Data Specialist

At Alliance HCM were 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 were 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.

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

Pay is based on experience. Keep growing within the industry and help ensure daily success as our Legacy Data Specialist!

THE INS AND OUTS OF BECOMING OUR LEGACY DATA SPECIALIST

YOUR RESPONSIBILITIES:

Youll 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. Youll also work with the clients HR teams to learn legacy data requirements and create customized data transformation and mapping rules.

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

OUR REQUIREMENTS:

• 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

JOIN US!

As the second-largest privately held payroll provider in the nation were dedicated to delivering top-notch HCM solutions. When you join our dynamic team youll find more than just a job; youll be part of a supportive community that celebrates your success and inspires you to reach new heights. Lets grow together and make a lasting impact! Take the first step towards becoming our Legacy Data Specialist by completing our initial application today!

Required Experience:

IC