Associate -HR reporting

Job description

Essential Functions of the Job:


The key function of this position is to prepare People reports and analyse human resources metrics and results. Analyse transactions to determine root causes, variances and recommend corrections to management. Design and create complex reports to user specifications. The position will ideally have to handle more complex issues and special projects than a junior analyst.

·  Conduct an in-depth analysis of (People metrics) to analyse the open items in reconciliation and resolve the same
·  Root cause analysis of issues ensuring adequate internal control procedures are put in place
·  Performing variance analysis and providing necessary inputs/inferences out of report findings  Responsibilities:

·  Must be able to Read and Write SQL queries
·  Use technology to continually learn, share knowledge with team members, and enhance service delivery
·  Peer Review of work carried out by the Analyst / Associate 
·  Ensure that the Reports are completed with high level of accuracy and timeliness
·  Creating Business Intelligence Solutions like SSIS, SSAS, SSRS and expertise in designing and implementing Relational Database model as per business needs
·  Strong implementation of Microsoft Business Intelligence BI platforms including SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS
·  Testing the Enterprise Data Warehouses using Informatica Power Centre, Data Stage, Ab Initio, and SSIS ETL tools
·  Scripting SQL queries, Complex Stored Procedures, User Defined Functions UDF , Database Triggers, using tools like SQL Profiler and Database Tuning Advisor DTA

Additional Knowledge and Skills requirements:

·  Have sound understanding of basic organizational / accounting concepts
·  Must have an advanced knowledge of excel functions and formulas
·  Understand the People data reporting hierarchy, data privacy guidelines, objectives and basic process work flow
·  Have strong inter personal skills with the ability to train team members
·  Exposure to Service Now and Success Factors will be an added advantage
·  Good communication skills both written and oral
·  Exposure to reconciliation
·  Knowledge of the suite of MS Office tools
·  Be flexible to working in varied shifts