Operations Research Analyst II – Multiple Openings


Atlanta, GA

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, Georgia 30339

Hours: Monday – Friday, 8:30am to 5:00pm

Summary of Duties: Under the Director, MRO Programs and Implementation Direction

  • Analyzes 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.

Education Requirements: Bachelors degree in Engineering or related field of study.

Travel requirements: 30% domestic travel to unanticipated location within USA