Systems Analyst [**]

  • Vernon Hills
  • Millenniumsoft
Position: Systems Analyst
Location: Franklin Lakes, NJ or Vernon Hills, IL
Duration: 5+ Months Contract
Total Hours/weeks: 40.00
Temp to Perm
Location either Franklin Lakes or Vernon Hills
Description:
We are looking for a technical skillset, to perform work with MS Access DB and similar work related to Customer and Contract data

Reporting to the Associate Director, Distributor Chargeback Operations, this position is accountable to develop and execute analytic and reporting solutions to improve automation and rate of resolution for end customer related sales tracing errors in collaboration with IT, Commercial Analytics, Customer Master Data Management (CMDM), and Contract Operations leaders and team members. Developing, implementing, and executing systems to cleanse, standardize, enrich, and harmonize customer data to maintain cross references to distributor customers submitted to BD on sales tracings. Effectively utilizing industry customer identifiers including HIN, DEA, and GLN, in addition to trusted 3rd party data providers of customer information for efficient and accurate processing of sales tracings.

The Systems Analyst will be responsible for developing, testing, implementing, and supporting technical enhancements to further automate sales trace customer account matching, cross referencing, new account creation, and sales tracing denials. This position will design and implement technical solutions to drive team efficiency and performance improvements and a significant reduction in outstanding sales tracing customer related errors. The Systems Analyst will understand Commercial Contract Operations and associated policies, ensuring that the US Commercial Operations strategy is implemented

This position is a hands-on technical SME to develop and enhance systems in coordination with IT, Analytics, CMDM, and Contract Ops. To lead technical development, implementation, and execution of solutions to sales trace customer errors. To apply the right technology to the business need for efficiency, cost, and business impact. Technical enhancements will improve automation in areas like: data cleansing and standardization; deriving class of trade definitions, incorporating membership lists in matching, iterative matching rule build-out, and database updates.

• This position has no direct reports

Essential Responsibilities
• Develop and implement technical solutions that drive automation, operational best practices, standardization, and a significantly improved rate of resolution for sales tracings end customer related errors
• Accurately analyze and maintain sales trace customer data, customer cross references, and tracking of customer related sales tracing errors
• Coordinate with IT, Commercial Analytics, CMDM, and other Commercial Operations teams to develop and deploy technical solutions that support Contract Operations strategies and policies
• Hands-on SME for MS Access, SQL Server, Python, and Qlikview technical enhancements to drive faster resolution of sales trace customer errors and drive process automation
• Provide regular reporting of sales tracing end customer related errors, and plans and results for process improvements
• Exercise appropriate controls to minimize disputed chargeback financial exposure and chargeback reserves across all businesses
• Provide guidance and coaching to team members to realize benefits with solution deployments and process improvements
• Lead solutions that drive operational best practices, standardization, and performance improvements.
• Maintain application training material and updated desktop procedures in order to ensure standard team practices that adhere to best practice efficiency and accuracy
• Identify and understand key areas of change management with the ability to recognize and communicate the impact of change to Chargeback Operations functional teams
• Inspire and empower the team to act with speed, agility and accountability enabling them to achieve excellence

Qualifications
• BA/BS required
• 3+ years’ experience designing and implementing technical solutions for business needs
• Demonstrated successful business results from technical implementations
• Strong technical skills with MS Access, SQL Server, Python, Qlik, Data Management Software, or equivalent
• Experience with data cleansing, standardizing, enriching, matching, cross referencing
• Proven high quality results in technical implementations, with experience testing
• General understanding of commercial operations management and customer master data
• Proven ability to quickly establish credibility, trust, and support within all levels of organization.
• Ability to collaborate with IT, Commercial Analytics, and CMDM to drive analytic and reporting solutions for customer data process efficiency, timeliness and accuracy
• Analytical problem solver with business acumen. Able to evaluate key business drivers and develop clear solution recommendations
• Ability to stimulate and enable innovative thinking to drive change and effectiveness through high automation and process excellence
• Ability to understand, organize and deliver on critical business requirements to drive solutions that advance our Contract Operations capabilities and achieve operational goals
• Strong communications and change management experience.