What are the responsibilities and job description for the Operations Research Analyst II position at Procure Analytics?
Description
- 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.
- Coordinate'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
Bachelor’s Degree in Engineering or related field of Study.
Please mail resume to Procure Analytics at 3625 Cumberland Blvd SE Suite 720 Atlanta, GA 30339.
