Tech Lead, Data Analyst, Database Administrator

Data Analyst with UKG HCM and SQL BI experience.

Location:

Lowell, Massachusetts / Weston, Florida.

Salary up to $130,000 and subcontract rate $75 per hour maximum.

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, delivering data consulting services to our customers, and applying functional and technical knowledge of HCM and Payroll systems.

• Utilize available ETL tools to extract and convert data from source system reports.
• Interpret, validate, and convert data from source system(s) to the target system, including demographic data, taxation, benefits, payroll balances, additional tables, contacts, dependents, and beneficiaries.
• Extract, validate, convert, reconcile and load US People and Payroll data into HCM software through backend processes.
• Perform balancing of payroll data based on earning, deduction and tax codes, reconciling the opening balances with the original source to ensure accurate transfer.
• Leverage data conversion tools, SQL queries, templates, and documentation to promote efficiency and standardization in compliance with approved methodology.
• Proactively communicate with peers, internal teams, and customers to keep them apprised of project status, ensuring alignment with assigned responsibilities and timelines.
• Create required post‑conversion documents including Issues and Assumptions and Tax Verification.
• Schedule and successfully complete multiple projects within the required timeline.
• Provide input on data conversion methodology and process improvements.
• Support peers by mentoring and delivering knowledge transfer sessions on new tools and processes as needed.
• Assist or shadow a System Consultant on implementation projects to gain a better understanding of system configuration and apply that knowledge during the data conversion process.
• Work shifts with overlap with the US market and be flexible for other shifts as required by organizational needs.

• BE/B.Tech or Master’s in a related field.
• 6+ years of experience working with SQL and ETL tools such as Microsoft SSIS, Informatica, or Talend in HCM projects.
• Strong knowledge of database design, programming, and Transact SQL.
• Experience working in project teams with strong SQL skills and knowledge of any ETL tool.
• Prior experience with US Payroll and any Human Capital Management Software.
• Prior consulting experience with a customer‑focused, positive and professional attitude.
• Excellent communication and interpersonal skills.
• Ability to work independently with minimal supervision, be collaborative, organized, detail‑oriented, accurate, responsive, and results‑driven.
• Strong decision‑making, problem‑solving, analysis, task and time‑management skills.

• Good understanding of HCM and Payroll systems.
• Positive attitude, client service orientation, and strong teamwork abilities.
• Capability to mentor and transfer knowledge effectively.