Canon USA & Affiliates Jobs

Overview

The HR Database Administrator will be responsible for development, implementation, and maintenance of the human resources information systems (HRIS), human capital management (HCM) solution, and SQL databases for the HR department. This role will ensure internal processes are well-documented, data is stored according to best practices, and database performance is regularly updated and maintained. The Database Administrator will develop regular and ad-hoc reports and procedures to ensure data reporting meets the needs of the HR department and stakeholders. This role will manage the HR database, data reporting, and workflows, and maintain comprehensive process documentation. The Database Administrator will develop effective solutions after evaluating database design and requirements and collaborate with IT as needed to troubleshoot issues.

Responsibilities

• Evaluates,analyzes,designs, and maintains the Human Resources Information Systems (HRIS).

• Generatesadhocmanagement reports through various databases and reports which may involve downloading information into Microsoft Access for detailed

• Responsible for system administration of our HCM solution, SuccessFactors (SF), working closely with SF technical staff to make system enhancements and modifications. Includes maintenance, testing, and execution of Compensation-related processes (Merit, Off-Cycle and Annual Performance templates), and queries to upload Off-Cycle transactions to AS400/Infinium.

• Responsiblefor the ongoing development, upgrade, and data integrity of the HRIS and HCM

• Manages SQL databases for HR department, writes and maintains SQL queries and functions.

• Installs updates, manages database releases, and conducts performance testing of the HRIS and SQL database system.

• Ensures that databases follow standard operating procedures and industry best practices.

• Ensures that database procedures are fully documented along with all definitions and processes.

• Creates and configures users and permissions to SQL databases.

• Collaborates with IT team members to troubleshoot database issues and provide maintenance.

• Responds to team member queries and data requirements to create and improve databases and develop custom reporting.

• Research and tests improvements to database functionality and efficiency.

• Works closely with HRIS team to establish new systems and identify new software products to support future corporate objectives and strategies as well as current

• Developsand conducts in-house HRIS training programs for end-users.

• Works on special projects and ad-hoc assignments as needed.

Qualifications

• Bachelor’s degree, Computer Science or similar field preferred

• At least 1+ year experience of programming/data visualization

• At least 1+ year experience using SQL to write queries

• At least 1+ year experience of Database Management

• Minimum of 2 years’ experience with HRIS Software Applications

• Knowledge of Programming & Data Visualization including SQL, PL/SQL databases

• Additional programming knowledge preferred (Oracle, Python, R, Tableau)

• Knowledge of Cloud Computing & Statistical Analysis Tools (eg, SAP, SPSS, STATA, SAS)

• Knowledge of Machine Learning & Statistical Modeling processes including Linear Regressions, Logistic Regressions, and Decision Trees

• Additional technical knowledge such as Search Engine Optimization (SEO) a plus

• Strong technical computer skills in SQL database management and data visualization

• Strong knowledge of Microsoft Office Suite (Excel, Word, PowerPoint, Outlook)

• Strong written and oral communication skills

• Ability to manage multiple priorities at once

• Ability to collaborate with multiple stakeholders across an organization

Job Locations US-NY-NEW YORK

Posted Date 2 weeks ago (5/7/2024 7:00 PM)

Requisition ID 2024-17874 # of Openings 1 Category (Portal Searching) Human Resources Position Type (Portal Searching) Regular Full-Time Minimum Salary USD $75,000.00/Yr. Maximum Salary USD $85,000.00/Yr.