Operations Research Analyst II (Multiple Openings) at Procure Analytics

Atlanta, Georgia, United States -

Full Time

Start Date

Immediate

Expiry Date

15 Jun, 26

Salary

0.0

Posted On

17 Mar, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

MS Excel, VBA, SQL, Python, ETL, Data Visualization, Mathematical Modelling, SKU Benchmarking, Pricing Negotiation, Forecasting Models, Optimization Techniques, CRM Platform, Salesforce, Data Warehousing, Data Quality Assurance

Industry

Business Consulting and Services

Description

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

Responsibilities

The analyst will analyze large datasets to identify indirect spend, assess cost reduction opportunities using tools like MS Excel and BI tools, and perform detailed data analysis to benchmark pricing models against supplier contracts. Responsibilities also include developing analytical tools, providing insights through mathematical modeling, and coordinating supplier relationships for pricing negotiations.