HRIT Reporting and Data Analyst

Responsibilities

• Acquire and maintain knowledge of employee and company related data including how and when it should be utilized.
• Identify the appropriate sources of data (Enterprise Data Warehouse, individual HRIS systems, etc.) to support report requirements.
• Design, develop and test reports utilizing ADP Enterprise Reporting Systems (ADPR-Reporting), People Soft Query, Taleo, Oracle, Cornerstone and LMS Reporting systems using Alteryx, SQL, Tableau, and other tools. Aggregate data from multiple systems as needed.
• Execute audit checks and annual validations; make recommendations for process improvements based on audit results to ensure data integrity and adherence to all Data Governance policies and procedures.
• Use statistical and research methods to perform studies of key relationships and patterns in the data.
• Analyze and troubleshoot reports and reporting systems. Research and resolve all data quality issues for responsible data objects.
• Create and maintain reporting & analytics documentation including end-user, system administration guides and data dictionary.
• Work on HR Analytics projects including data visualization / dashboards, data integrity testing and systems customizations/optimization.
• Respond to time-sensitive requests requiring data analysis while adhering to security access constraints.
• Prototype design options to end-users.

• Minimum 2 years HR report writing required (skills should include combining tables, inner and outer joins, etc.).
• 2 years of HRIS/HRIT or database system administration experience required.

• Familiarity with Alteryx.
• Intermediate proficiency with Microsoft Excel required (lookups, pivot tables, etc.).
• Familiarity with other Microsoft Office software.
• People Soft Query and ADP-Reporting experience a strong plus.
• Tableau or other data visualization tool experience a plus.
• Human Resources or payroll functional knowledge a plus.
• Basic to advanced statistical and research skill preferred.
• Experience using Alteryx highly preferred.
• 1 year of testing experience preferred.