Data Services Consultant II

Company Overview

With 80,000 customers across 150 countries, UKG is the largest U.S.-based private software company in the world. And we’re only getting started. Ready to bring your bold ideas and collaborative mindset to an organization that still has so much more to build and achieve? Read on.

At UKG, you get more than just a job. You get to work with purpose. Our team of U Krewers are on a mission to inspire every organization to become a great place to work through our award-winning HR technology built for all.

Here, we know that you’re more than your work. That’s why our benefits help you thrive personally and professionally, from wellness programs and tuition reimbursement to U Choose — a customizable expense reimbursement program that can be used for more than 200+ needs that best suit you and your family, from student loan repayment, to childcare, to pet insurance. Our inclusive culture, active and engaged employee resource groups, and caring leaders value every voice and support you in doing the best work of your career. If you’re passionate about our purpose — people —then we can’t wait to support whatever gives you purpose. We’re united by purpose, inspired by you.

Job Summary

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 should be able to leverage the strengths and capabilities of the software tools to provide an optimized solution to the customer.

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
• 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

Required Qualifications
• 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

Where we’re going

UKG is on the cusp of something truly special. Worldwide, we already hold the #1 market share position for workforce management and the #2 position for human capital management. Tens of millions of frontline workers start and end their days with our software, with billions of shifts managed annually through UKG solutions today. Yet it’s our AI-powered product portfolio designed to support customers of all sizes, industries, and geographies that will propel us into an even brighter tomorrow!

UKG is proud to be an equal opportunity employer and is committed to promoting diversity and inclusion in the workplace, including the recruitment process.

Disability Accommodation in the Application and Interview Process

For individuals with disabilities that need additional assistance at any point in the application and interview process, please email UKGCareers@ukg.com