JD Edwards Functional Consultant

Job Title:JDE Functional Consultant (HR/Payroll/Finance)

Job Type:Full-time Permanent

Location:New Westminster, British Columbia (Hybrid)

Hours per Week: 35 hours per week.

***If applying from another province, you must be willing to relocate to BC***

Our client is seeking a highly skilled JDE Functional Consultant with strong technical expertise, particularly inSQL Server, reporting tools, and enterprise application support. This role will focus onHR, Payroll, and Finance systems, includingOracle JD Edwards EnterpriseOne, UKG Workforce Central, Vertex, and Taleo. The ideal candidate must possess hands-on technical proficiency in system integration, troubleshooting, and report development, with the ability to work independently to diagnose and resolve issues.

Responsibilities

• Develop and troubleshoot reports and applications usingJDE Design Tools, BI Publisher, Crystal Reports, and SSRS.

• Write and optimizeSQL queries to support integrations and system functionality.

• Deploy, package, and upgrade JDE ESUs and Vertex updates as needed.

• Manage and troubleshoot system integrations usingSQL Server and proprietary vendor tools.

• Investigate and resolve application errors by identifying root causes and implementing solutions.

• Manage user accounts, security, and system access, including role assignments and permissions.

• Provide technical support and system administration forHR/Payroll/Finance applications.

• Configure and enhance system functionality (e.g., payroll rules, workflows, and custom applications).

• Perform database administration tasks, including backups, data refreshes, and performance tuning.

• Monitor and maintain servers, including WebLogic configuration and periodic maintenance.

• Support cloud-based and third-party system migrations, including UKG Kronos and Momentus.

• Work closely with vendors and stakeholders to meet business and operational needs.

Qualifications

• 5+ years of experience in an IT department as an HR/Finance/Payroll technical/systems analyst.

• Bachelor’s degree from a recognized, reputable post-secondary institution in an IT Systems-related discipline.

• 5+ years of experience working with JD Edwards EnterpriseOne in a technical role ishighly preferred.

• StrongSQL Server skills, including the ability towrite and optimize queries, troubleshoot integrations, and manage databases.

• Proficiency inenterprise system upgrades and deployments, including JD EdwardsESU packaging and deployment.

• Hands-on experience inapplication design and report-building tools (e.g., BI Publisher, Crystal Reports, SSRS, SSIS, and JDE Design Tools).

• The ability totroubleshoot system errors, investigate root causes, and resolve issueswithout relying solely on external support.

• Understanding oftax calculation processes within HR/Payroll systems and the ability to diagnose related issues.

• Experience inuser account and security management, including role-based access control, printer assignments, and server configurations.

• Familiarity withserver administration tasks, includingWebLogic configuration and system monitoring.

• Knowledge of integrating with third-party systems such asUKG Kronos andMomentus Cloud migration.

• Experience with a Canadian payroll system in a technical/systems analyst-related position.

Desired Skills

• Expertise in SQL Server administration and development (Preferred Certification: Microsoft Certified: SQL Server).

• Experience with Oracle JDE EnterpriseOne technical administration (Preferred Certification: Oracle JD Edwards EnterpriseOne 9.2 System Administration Certified Implementation Specialist).

• UKG Workforce Central technical administration experience.

• Microsoft Server administration knowledge.

• Understanding of Oracle Taleo technical administration.

• Ability to independently troubleshoot and resolve system issues.

• Strong analytical and problem-solving skills to assess and improve business systems processes.

• Effective communication skills to translate technical issues into non-technical language for stakeholders.

• Ability to manage multiple priorities and work under minimal supervision.

Other Requirements

• Must be a Canadian citizen or a permanent resident.

• Must pass a Police Information Check.

This role requires atechnically adept candidate who can independently diagnose issues, troubleshoot SQL queries, manage system integrations, and optimize enterprise application functionality.