Business Analyst
Location: Parsippany NJ, United States (US)
Job Function: Sales
Career Level: Professionals
Company: Roehm America LLC
WHO WE ARE
We are a leading supplier of methacrylate chemistry. As a global company with around 2,800 employees, we are represented on three continents. We serve a global market with our MERACRYL® methacrylates and PMMA molding compounds under the PLEXIGLAS® brand (in the Americas registered under the trademark ACRYLITE®), which we manufacture in our worldwide production network. Our products supply growth markets including the automotive, construction, and medical technology industries.
Röhm is committed to operating with social responsibility, and sustainability forms an integral part of our business strategy. We view our employees as our strength, and we value diversity and inclusion. If you thrive in an environment where individual contributions are both visible and recognized, Röhm may be right for you.
WHAT THE ROLE DELIVERS
The purpose of the Business Analyst role is to support both the strategic and operational aspects of the Bulk Monomers business unit through effective data management. On an operational level, the Business Analyst will be expected to ensure the data accuracy of pricing, forecasting, and reporting. On a strategic level, the Business Analyst will be expected to support projects such as the maintenance of the market database and the implementation of special projects. The ideal candidate will be able to make improvements to these processes. Expert experience with Excel and associated applications such as Power Query Editor and Power BI will be important to success in this role.
WHAT YOU WILL DO
- Data collection for formula prices and the update of formula prices monthly.
- Accurate monthly update of all prices in SAP.
- Prepare the required data for an effective forecast review with Sales and provide a monthly forecast for BM.
- Generate sales reports when necessary to support Sales and business decisions.
- Collect, scrub, and summarize import data to provide an accurate picture of BM trade in RAM.
- Analyze pricing on a quarterly basis and conduct a review with Sales to ensure pricing consistency.
- Manage the sample process and relationship with our sample shipping service.
- Manage and maintain the yearly review of market data.
- Identify opportunities for process improvements in pricing, forecasting, and other tasks.
- Participate in special projects to improve business performance such as the launch of a customer portal,
- improved shipment tracking, and the development and analysis of customer surveys.
WHAT WE ARE SEEKING
- 5+ years of experience in data analytics and business analysis, chemical industry experience perferred
- In-depth knowledge of Excel and SAP functions including Power Query Editor and Power BI
- Experience analyzing data from a CRM platform
- Bachelor’s degree, preferably in a technical field