Deliver data consulting services to our customers. Utilize available ETL tool to extract and convert data from source system reports. Interpret, validate, and convert data from source system(s) to target system including demographic data, taxation, benefits, payroll balances, additional tables, contacts, dependents, beneficiaries. Extract, validate, convert, reconcile and load US People and Payroll data into HCM software through backend. Perform balancing of payroll data based on earning, 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. Utilize available data conversion tools, SQL queries, templates, and documentation to promote efficiency and standardization in compliance with approved data conversion methodology 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 input on data conversion methodology and process improvements 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 in order to gain a better understanding of system configuration and apply that knowledge to add more value during the data conversion process BE/B Tech or Master's in related field 2+ years of experience working on US Payroll and 4+ years of experience in SQL Database, Programming, and Transact SQL Experience working in project teams along with strong SQL skills and Knowledge of any ETL tool Good to have prior experience with US Payroll and any Human Capital Management Software Prior consulting experience, customer-focused, positive and professional attitude along with strong communication and interpersonal skills Able to work independently with minimal supervision, collaborative, organized, detail oriented, accurate and responsive, results driven orientation. Strong decision making, problem-solving, analysis, task and time management skills
