Operations Research Analyst (Multiple Openings)

Procure Analytics; Atlanta, Northern (GA, KY); Hybrid; USD 75,000 - 110,000; Full time

Job summary

Procurement Advisors LLC DBA Procure Analytics, LLC is seeking an Operations Research Analyst II in Atlanta, GA. The role involves analyzing large member data sets to identify indirect spend reduction opportunities, and developing dashboards using Excel, SQL, Python, and VBA for decision-making.

Responsibilities include benchmarking SKUs, managing data quality in the data warehouse, and supporting forecasting, supplier pricing analyses, and onboarding processes. Travel up to 30% is required.

Qualifications

• Bachelor’s degree in Engineering or related field.
• Strong data analysis using Excel, SQL, and Python.
• Experience with data warehouses, ETL, and BI tools.

Responsibilities

• Analyzes large data sets to identify indirect spend and cost reduction opportunities using Excel (VBA/macros) and BI tools.
• Performs detailed data analysis to benchmark SKUs and supplier contracts.
• Updates data warehouse inputs and performs data validation/QA.

Skills

Analytical thinking

Data visualization

Problem solving

Education

Bachelor's degree in Engineering or related field

Tools

SQL

Python

Microsoft Excel

Job description

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