Time Applications Lead

**Description**:
**Terms of employment**:Permanent, full-time

**Work location**:Richmond Hill, Ontario

**Language of work**:English

**Salary range**:CAD$104,000 to $125,000

**Start date**:As soon as possible

**Benefits**:Health, dental, sick and accident benefits, vacation, Employee Assistance Plan, and Retirement Savings Plan options.

**Duties and responsibilities**:

- Log and manage support requests in the appropriate systems and ensure that the appropriate internal and customer follow-up is performed within the published or agreed timelines.
- Understand various rules for determining prevailing wage for the workers for various states/provinces and implement and manage solutions to support the prevailing wage and compliance requirements.
- Develop and support interfaces that process timesheets into payroll systems such as Workday.
- Monitor weekly payroll activities and special payroll schedules.
- Proactive monitoring of jobs and data that might impact payroll.
- Design, develop and support various inbound and outbound batch jobs in Informatica.
- Manage connections with various ERP systems in the organization.
- Analyze, troubleshoot, and resolve customer issues, working towards the resolution at first level within a timely manner or work with your manager or team members to reassign to the appropriate resource or group.
- May reproduce technical issues that customers report in a test environment to troubleshoot and resolve.
- Extensive knowledge of program development and analysis of capabilities designed to resolve business requirements utilizing Oracle products and tools.
- Ability to influence and set technical direction.
- Recognize upstream and downstream impacts; and communicate effectively (verbally and in writing).
- Work on the Oracle SQL queries and PL/SQL objects like functions, procedures, packages, triggers, views, cursors.
- Develop and optimize database structures, complex PL/SQL store procedures, functions, dynamic management views, DDL triggers and user define functions.
- Develop/update Unix shell scripts.
- Analyze performance bottlenecks and perform tuning on code.
- Develop and enhance software programs and data structures that meet business objectives.
- Produce technical design documentation as required and ensure work complies with the architectural roadmap, and identify and update existing design documents impacted due to changes.
- Ensure individual and team tasks are performed on-time by communicating and working closely with other members of the team.
- Retain a focus on completion, identifying and resolving issues.
- Should be able to do 80% Oracle and 20% non-Oracle.
- Carry out other duties as reasonably requested by your line manager.

**Qualifications**:

- Master’s degree in computer science, computer systems engineering, software engineering, mathematics or related discipline
- 8+ years of technical experience developing or supporting Oracle Database solutions using Oracle PL/SQL and SQL.
- 5+ years of user interface and presentation design and development skills.
- 5+ years analysis, design, and ability to deliver a quality product on time.
- Strong experience in SQL and Oracle PL/SQL.
- Experience in Advanced PL/SQL programming such as bulk handling, pipelined functions, analytical queries, collections, objects etc.
- Experience in the rules of generating certified payroll report.
- Experience in time keeping systems such as Kronos.
- Experience in ERP systems including GL and PA modules.
- Ability to effectively prioritize and execute tasks in a fast-moving environment.
- Able to interact professionally with customers and colleagues.
- Excellent listening, interpersonal, written, and oral communication skills.
- Strong knowledge on Incident management, Change management and Release management.
- Must be a strong team player