Business Analyst

Calgon Carbon | A Kuraray Company currently has an opportunity where you can be a part of our growing team as we provide our customers outstanding products that make the air we breathe and the water we use safe for generations to come.

Position: Business Analyst
Location: Headquarters - Moon Township, PA

The Business Analyst is a critical position involved with making sure that all sales (historical, current actual, forecasted, and plan) with associated characteristics, properly flow into and out of Calgon Carbon's business management systems. This is extremely important to make sure sales data, including COGS and quantities can be recognized in our data systems and extracted for accurate detailed business analysis and corporate decision making. The complex nature of our company and our business systems makes this job very challenging. Further complexity occurs with the frequent reorganizations and territory sales re-assignments that our business often undertakes to match the needs of the markets we serve. The incumbent develops, runs, and modifies both routine and "as necessary" reports used by business line leaders to manage business.

Duties and Responsibilities (not limited to)

• Financial Reporting
  • Corporate Reporting Kuraray Required Reports & Current Month vs Same Month last year sales comparison
  • Executive Management Daily Sales Report (modify as needed to meet needs of organization) - This report serves as the primary dashboard monitor to determine how the current month's sales are progressing compared to original plan and various updated plans/forecasts
  • External Auditor Quarterly Auditor Sales Analysis (Q current year vs Q previous year, Q current year YTD vs Q previous year YTD, Q current year vs Q-1)
• IT Data Management
  • IT Coordination SAP Master data steward (HR Mini Master module) Personnel number assignments
  • IT Coordination Assist in troubleshooting SAP records (customer master data, orders, line items, various queries)
• Sales - Outside/Inside
  • Sales Support Pending Order reports extracted from BW and issued to BU's and Customer Service showing current month's pending orders to monitor if order will invoice that month
  • Sales Support Various sales/margin/quantity reports (Industrial and Diversified BU's sales tapes, various ad-hoc reports). Requires detailed understanding of BW, MiniMega extract file, various Lotus Notes Databases, and basic SAP queries
  • Sales Support Re-Organizations /Territory Re-Assignments - requires extensive organization knowledge, multi-disciplinary teams' participation, relevant data characteristics available to assist re-organization, editing potentially massive data tables. Data for reorganizations must be reflected in multiple systems (SAP, BW, and LotusNotes).
  • Sales Support Sales Plan development - Lotus Notes Data, BW Evaluation, Sales Assistance and maintenance of system load file as territory reassignments or reorganizations occur
  • Sales Support BW Training - requires high level BW expertise and understanding of BW data limitations - what can be found in BW and what is not included
  • Sales Support Troubleshooting data problems by working with sales/marketing, finance, and business management

Qualifications

• Associates degree (A.A.) or equivalent from two-year college or technical school is required (Business school or college education, or applicable work experience)
• 3-5 years of General Business/Administrative experience; must be knowledgeable with business systems and data flow and have sales support experience
• 5 years' experience minimum at Calgon to be familiar with general business lines is preferred
• Advanced Excel Skills BW Excel Add-In Skills SAP Knowledge Lotus Notes Databases Microsoft Word / PowerPoint Familiarity Strong interpersonal skills required to deal with all levels in organization around the world and varied personalities. Multi-task capabilities Flexibility Self Starter

Hours of work: Full-time position with hours generally Monday through Friday (30 - 40 hours per week with flexibility of start and finish times)
Benefits: Medical, dental, prescription, vision, and retirement savings (401k)

More about Calgon Carbon, A Kuraray Company

We are a company of scientific innovators with over 205 patents. For over 75 years, we've been innovating solutions to the world's emerging challenges. Since creating the first activated carbon products from bituminous coal in the 1940s, Calgon Carbon has been a pioneer in developing advanced products, systems and services for air and water purification. Calgon Carbon's product portfolio now encompasses more than 700 direct market applications.

Headquartered in Pittsburgh, Pennsylvania, Calgon Carbon employs approximately 1,350 people and operates 20 manufacturing, reactivation, innovation and equipment fabrication facilities in the U.S., Asia, and in Europe, where Calgon Carbon is known as Chemviron.

Calgon Carbon was acquired by Kuraray in March of 2018. With complementary products and services, the combined organization will continue to focus on providing the highest quality and most innovative activated carbon and filtration media products, equipment, and services to meet customer needs anywhere in the world.

Calgon Carbon is an Equal Employment Opportunity/Affirmative Action Employer.
Minorities/Females/Individuals with Disabilities/Protected Veterans
VEVRRA Federal Contractor