Lead Data Services Consultant

A Data Services Consultant for UKG is an integral member of a dynamic organization responsible for data conversion in the field of Human Capital Management. The consultant is accountable for accurately converting US Payroll data from customers source system(s) into UKG Pro. Deliver data consulting services to our customers. Skills essential to this role are knowledge of US Payroll, Taxation, SQL, analysis, consulting, organization, written and verbal communication. Functional and technical knowledge of HCM and Payroll systems is must to have.

The candidate is expected to work in shift having overlap with US and be flexible for other shifts as applicable per the organization needs. On some days the consultant will have flexibility based on project work or customer call.

The candidate is also responsible for interacting with other businesses and technical project stakeholders to gather business requirements and ensure successful delivery. The candidate must have good communication skills and able to effectively communicate ideas both verbally and in writing at all levels in the organization, from executive staff to technical resources. The role requires working with the Program/Project manager, Solution Consultant, and customer representative to deliver the solution based upon the defined design requirements and ensure it meets the scope and customer expectations.

Primary/Essential Duties and Key Responsibilities:

• Interpret, validate, and convert HCM data from source system(s) to target system including demographic data, taxation, benefits, payroll balances, additional tables, contacts, dependents, beneficiaries.
• Validate, reconcile and load US People and Payroll data into PRO (HCM software) through SQL stored procedures and backend. Perform balancing of payroll data based on earnings, deduction and tax codes. Reconciling the opening balances data to be loaded with the original source to ensure that all information has been accurately transferred and that there is no missing information.
• Proactively communicate with peers, internal teams, and customers to keep them apprised of project status and ensure they are on track with assigned responsibilities and project timeline and effectively implement change-control
• Create required post conversion documents including Issues and Assumptions and Tax Verification
• Schedule and successfully complete multiple projects within the timeline required
• Provide support to peers (e.g., mentoring, knowledge transfer) including developing and delivering knowledge transfer sessions on new tools and processes as needed/requested
• Successfully assist or shadow System Consultant on implementation projects, gain a better understanding of system configuration and apply that knowledge to add more value during the data conversion process.

Required Qualifications:

• BE/B Tech or Masters in related field.
• 4+ years of experience working on US Payroll.

• Baseline understanding of U.S. W2 and/or U.S. tax reports (941 reporting).
• Advanced competency level of current year check history/opening balances process.
• Knowledge of writing SQL Queries to troubleshoot and fix errors in database. 2+ years of experience in database SQL.
• Proficient in Microsoft Excel.

• Good to have US payroll certification.

• Prior consulting experience, customer-focused, positive and professional attitude along with strong communication and interpersonal skills.

• Ability to work independently and balance multiple priorities.
• Ability to participate in teams, assist and mentor other team members as needed.
• Strong decision making, problem-solving, analysis, task and time management skills.
• Must be consultative, organized, detail-oriented, accurate, and responsive.
• Ability to work in US shift.