Acosta Sales & Marketing HRIS Analyst III in Jacksonville, Florida
The HRIS Analyst III is responsible for providing complex, non-routine analytical, technical, and operational support for the HRIS team. Design, implement, evaluate and analyze data and reporting mechanisms to bring clarity to HR-related issues and overall trends in the organization. Develop and maintain PL/SQL, SQL and SQR reporting environment integrating multiple HR systems. Responsible for developing and maintaining complex SQL queries and stored procedures to connect data from multiple sources. Responsible for designing and developing materialized views, reports, report templates and dashboards by leveraging SQL. The HRIS Analyst III will work closely with HR and Payroll staff, IT and HR business leaders.
Design, development, and maintenance of HR and Payroll systems, programs, integrations and systems software to meet management and company's information needs.
Create technical/design specifications based on business requirements.
Develop HRIS databases (Oracle and SQL Servers) using database links, materialized views, views, procedures, functions, and packages.
Work with HR users to analyze, design, develop, test and implement programs to meet special and on-going needs of HR customers.
Assist users to develop, maintain, produce and distribute standard and custom reports, queries and interfaces.
Revises existing programs to increase operating efficiency or adapt to new business requirements.
Analyze and test HRIS applications, responsible for system upgrade, enhancements and customizations to ensure efficiency and accuracy of process and data.
Acts as a liaison with managerial and systems analysis personnel to clarify program intent, identify problems, recommend changes and determine extent of programming involved.
Participate in the development of, and advise management on, information technology strategy and technology deployment.
Responsible for overall program delivery for identified solutions, utilizing industry best practices to ensure business value is delivered.
Resolve complex technical problems by troubleshooting, analyzing, detecting, identifying and correcting system deficiencies.
Ensures HRIS governance establishing standard processes, practices and security measures to ensure effective and consistent information processing operations and to safeguard information resources.
Reverse engineer to troubleshoot undocumented HR system issues and external connection points.
Translates complex business requirements into feeds and reports.
Independently analyze results, creating valuable business analytics and impactful metrics.
Analyze tables to establish knowledge of data for accurate retrieval and use in report writing (data profiling).
Maintain, monitor, and automate current query set and report scheduler.
Leverage vendor and third party resources to optimize system functionality and end user/partner experience (DATAVAIL, ADP).
Manage vendor solutions for fit, quality and schedule. Configure and test software solutions (ADP and V5Prd).
Conduct general system administration, including but not limited to: managing user accounts, system security and permissions, new store setup, form templates, competencies, system notifications, system properties and reporting (ADP, SumTotal, HRSS, Enterprise V5Prd).
May direct the work of others.
Bachelor’s degree in computer science or related field or equivalent work experience is required.
7+ years functional knowledge of ADP or PeopleSoft HCM applications and third party integrations.
Extensive experience with Oracle (4+ years tables, triggers, unions, joins, complex queries, stored procedures and web services).
ADP Enterprise V5 System Administration
Advanced MS Access and Excel skills.
PL/SQL, Advanced SQL, Jr Oracle DBA, VBA, SQR, and Troubleshooting C#
Infrastructure experience managing Application/Webservers and Weblogic.
Exceptional analytical skills with ability to interpret data, detect trends, draw conclusions, and formulate recommendations.
Analytical Skills: Ability to work with large amounts of data: facts, figures, and number crunching. Understand the data and analyze it to find conclusions.
Communication Skills: Ability to document and communication functional/technical business requirements. Ability to write and speak clearly, easily communicating complex ideas.
Critical Thinking: Ability to look at the numbers, trends, and data and come to new conclusions based on the findings.
Attention to Detail: Data is precise. Vigilance in analysis of data to come to correct conclusions is a must.
Math Skills: estimate numerical data.
Acosta Sales & Marketing is an Equal Opportunity Employer
Job ID 2016-113786
Work City Irving
Work State US - TX - Irving
US - FL - Jacksonville
Position Type Regular Full-Time
Work Zip 75039
Starting average hours per week 37.5 +