What are the responsibilities and job description for the Operations Research Analyst II (Multiple Openings) position at Procure Analytics?
Description
Name of Employer: Procurement Advisors LLC DBA Procure Analytics, LLC
Position Title: Operations Research Analyst II (Multiple Openings)
Position Location: 3625 Cumberland Blvd., SE, Suite 720, Atlanta, GA 30339
Hours: Monday – Friday, 8:00 am to 5:00 pm
Summary of Duties:
Under the Director - MRO Programs and Implementation direction, analyses large data sets from members to identify and categorize indirect spend and provide a preliminary assessment of cost reduction opportunities using MS Excel (VBA/macros) and other business intelligence tools. Performs detailed data analysis to assess current pricing models & studies technical specifications of products, annual volumes to benchmark SKUs with identified supplier partners/ category contracts. Updates and inputs data into the organization's data warehouse using SQL & ensures data quality and integrity by performing data validation/QA processes. Analyses account payable data/supplier data using extract, transform and load (ETL) processes for spend cube analysis and compliance tracking. Develops analytical and data visualization tools, such as spreadsheets, dashboards, and applications using advanced MS Excel/SQL/Python/VBA to enable critical stakeholders' managerial decision-making. Provides analytical insights using mathematical modelling, and technical expertise to make product recommendations/substitutions and inventory optimization to drive cost savings. Co-ordinate's supplier relationships throughout benchmarking process negotiates SKU level pricing to maintain price competitiveness. Supports internal stakeholders by building forecasting models for revenue planning. Analyses purchasing patterns to rationalize SKUs to drive cost savings using optimization techniques. Engages with the member to map procurement process throughout onboarding and facilitates information flow on CRM platform (Salesforce). Audit supplier pricing files to ensure accuracy and to monitor price discrepancies and contract benefits. Participates in business development initiatives with executive leadership to create proposals & provide the necessary documentation, including by-laws, to move forward with Benchmarking & the onboarding process. Works with national and regional suppliers on special pricing arrangements, pricing challenges, and purchasing actions for special projects and programs. Works with crucial contract suppliers to identify and resolve customer issues across the portfolio. Other duties as assigned. Must be willing to travel up to 30% of the time.
Requirements
Education requirements: Bachelor’s degree in Engineering or related field of Study.
Travel requirements: 30% Domestic travel to unanticipated location within USA