search > North DFW jobs > North DFW computer/technical

Posted: Wednesday, April 12, 2017 9:45 AM

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 companys 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 dependently 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.BachelorA?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 AdministrationAdvanced MS Access and Excel skills.PL/SQL, Advanced SQL, Jr Oracle DBA, VBA, SQR, and Troubleshooting CInfrastructure 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:


• Location: North DFW

• Post ID: 49453733 northdfw is an interactive computer service that enables access by multiple users and should not be treated as the publisher or speaker of any information provided by another information content provider. © 2017