Business Analyst in Beachwood Campus at Tremco Incorporated

Date Posted: 9/20/2018

Job Snapshot

Job Description

Tremco's Commercial Sealants & Waterproofing (CS&W) division is currently looking for a Business Analyst. The Business Analyst provides support and leads initiatives to ensure data integrity, accuracy and sound use of business systems. This position will provide assistance with the execution of pricing, project control, and strategy decisions supporting market, customer and product objectives. This position will also assist the Senior VP/Controller and Assistant Controller with financial analysis  functions and provide reliable information necessary to control CS&W operations; provide information and analysis/insight to CS&W leadership and departments as requested; represent CS&W finance department on projects withing the division including international finance & support.

Essential Duties and Responsibilities:

  • Maintain annual updates of sales analysis templates using data from SAP and other data sources
  • Download data from multiple systems into Excel to conduct analysis based on business goals
  • Support in collecting and analyzing data that supports business decisions and may affect changes in policies as it relates to pricing
  • Provide support the data analysis of pricing strategy and tactics
  • Act as expert analyst for price segmentation software
  • Develop logical data and business models to convey impact of data driven decisions
  • Analyze business objectives and develop solutions
  • Assist in project pricing/costing as an advisor
  • Assist with PPOG projects as needed in supporting and/or leadership capacities
  • Work directly with plant management on annual Labor & Overhead (L&O) budgets including spending assumptions, data validation, variance analysis, and exhibits (joint effort Cost Analyst between US and CAN locations)
  • Act as a liaison between CS&W departments regarding reporting requirements; create and improve various management reports and variance analyses as business needs arise; recommend techniques to improve efficiency, cost containment, and productivity; conduct training sessions for other departments as necessary
  • Provide data, input, and financial direction on various special project including but not limited to customer profitability, price increases, compensation changes, and budgetary decisions
  • Assist with internal rate of return calculations for capital requests; understand and communicate the impact of capital expenditures of manufacturing and finance
  • Serve as primary backup to the CS&W Cost Analyst
    • Perform daily cost runs and validate accuracy of costs
    • Review financial accounting information on a regular basis, certify correctness and completeness, and propose changes as necessary
    • Identify and prepare monthly accruals and journal entries to properly account for charges to division cost centers
    • Report on inventory accuracy; review plants cycle count and physical inventory adjustments
    • Track and review manufacturing spending; propose reclassification entries or accruals as necessary
    • Review purchase price variance accounts and work with plants/purchasing to correct any erroes
    • Ensure confidentiality and integrity of financial data in compliance with GAAP, Tremco policies, and SOX; ensure required documentation exists and is maintained in accordance with SOX
    • Serve in a supporting role for internal and external auditors as necessary

Education

  • Bachelor's degree in Marketing, Finance, Accounting, Business Analytics, Pricing, or related field

Experience

  • One to two years' related experience and/or training such as internships

Other Skills and Abilities

  • Motivated, assertive, with excellent follow-up skills
  • High degree of flexibility and organization and the ability to effectively handle multiple concurrent projects, a fluctuating workload, and rapid changes in priorities
  • High-level analytical and problem-solving abilities
  • Ability to organize data and draw relevant conclusions
  • Detail, process, and procedure oriented
  • Ability to recognize errors and/or inconsistencies and take action
  • Ability to recognize and interpret trends
  • Excellent written and verbal communication skills with the ability to speak with all levels of the organanization
  • Technical skills in account reconciliation, cost analysis, month-end close, financial reporting, etc.
  • Strong PC aptitude with excellent Excel skills required
  • Familiarity with accounting/financial reporting software (Hyperion Planning/Essbase, HFM, and SAP experience preferred)

Qualified applicants will receive consideration for employment without regard to their race, color, religion, national origin, sex, protected veteran status or disability.