Procurement Systems Analyst (SQL Support) - Hiring Immediately

Job Summary

Support spend management software product, working with complete end-to-end source-to-pay process. This includes the upstream Source-to-Contract (Sourcing and Contract management), downstream Procure-to-Pay processes (Procurement and Invoicing) as well as Vendor Management (Supplier performance and risk management and Vendor master data update)

General Responsibilities

• Support and deliver project together with external implementation partner by driving requirements 
• Support functional manager and team in managing day-to-day operating expenditure against operating and project and operations budget to ensure efficient usage of recourses.
• Research and analyze spend management processes against DKSH non-trade processes and define user requirements.
• Support incident, service requests raised for spend management platform post implementation in the areas of supplier relationship management, Supply Chain, Procurement and Finance within Source to Pay processes.
• Accountable in providing sound and well documented requirements within the project scope related to non-trade procurement processes.
• Accountable to drive and complete mandatory project requirements such as use cases, change requests, functional specifications, development and testing for both project and subsequent operations.
• Administration & maintenance of solution, user management, access rights/authorization management, adjust/update master data configuration / enhancements, create and adjust validation workflow, define approvers, escalations paths.
• Design mode - new forms and fields, update/changes on existing field properties, etc Template management (supplier, RFx, contracts, supplier performance, etc), configuration of notification, reminders, alerts and logs and SQL based custom reports development.
• Configure integration and callback with 3rd party (e.g., 3rd party vendor integration) and internal systems integration.
• Utilize configuration tables and system parameters to customize purchasing, sourcing, and contracting process.
• Create advanced queries for integration including generation of XML and SOAP
• Import (ETLs), export and automate simple business processes.
• Provide periodic and timely status progress update of project and operations status.
• Able to work with senior stakeholders and within expectations.
• Ensure highest Governance & Practices standards in solution development and operations.
• Work closely with team members and vendor partner (if applicable) to drive and complete project and operations deliverables.
• Manage issues, risks and expectation and ensure they are escalated or addressed on a timely manner.

Leadership Responsibilities

Drive self-learning and improvement in the area of IT non-trade procurement and DKSH behaviors as part of continuous learning.

Functional Skills and Knowledge

• Demonstrate strong knowledge in ETL functionality (flat file import, transformation, and loading). REST based and secure web services, JSON and XML data support.
• Query functionality (flat file output, scheduling, multiple formats), EAI engine to manage complex sequential integration actions associated with WebServices, REST, scheduled push and pull of data, AS2 pipes, SFTP, HTTPs and SSO integrations.
• Knowledge on Integration Protocols (AS2, SFTP, HTTPS), SSO framework (SAMLv2, Active Directory or other SSO protocols), API Console to expose web services to pull and push data.
• Solid SQL experience is required, familiar with SQL Profiler, read SPP (Stored procedures), views , functions and jobs scheduler
• Proficient in configuring workflows, Alerts, Callbacks and SQL based reports.
• Experience in software development, primarily in C#, VB.NET, JAVA and SQL.
• Basic Knowledge of Messaging and Web Services.
• Functional knowledge in the areas of supplier relationship management, Supply Chain, Procurement and Finance within the Source to Pay processes.
• Fluent in both written and spoken English.

Education

Bachelor’s degree in computer engineering, Computer Science, Information Technology, Business Computer, or equivalent

Work Experience

Minimum 3 years’ experience in a similar role