Operations Research Analyst

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