Business Analyst, ACS Publications Sales

Date: Jun 20, 2022

Location: Columbus, OH, US

Company: American Chemical Society

The Publications Division of the American Chemical Society (ACS) publishes a weekly topical magazine (C&EN) and more than 70 peer-reviewed journals focused on chemistry and chemistry-related topics. The Division has domestic facilities in Washington, D.C. and Columbus OH, as well as worldwide operations in a growing number of international locations including but not limited to the UK, Singapore, India, and China. The Division’s Publications Sales department manages regional sales representatives as well as contracted distribution relationships across the globe servicing customers in over 100 countries. With all of the challenges that come with delivering our expanding product set to a growing client base, we are in search of a Business Analyst to join our high-performing team in Columbus, OH.


The Business Analyst (BA) will work under the direction of the Assistant Director, Business Analytics supporting primarily the Global Sales, Operations and Marketing teams.  The BA will also play a role in developing and expanding the Publications Divisions Enterprise Data needs. The BA will contribute to the comprehensive support of all activities relating to sales, revenue operations and marketing in an effort to accelerate and expand sales and control expenses. This includes data analysis around pricing, customer behaviors and account performance.  The position will also work closely with the group’s management team in the area of budgets/forecasting and departmental performance management.  Additionally this position will provide analysis & modeling of business data to assist stakeholders in making informed business decisions and provide opportunity recognition.


Primary duties will include the following:


  1. Assimilates, validates & analyzes business data in order to help senior management make informed business decisions.
  2. Participates in the development of systems and tools used for business monitoring and data analysis. This includes visualization and end user deliverability.
  3. Works with data governance groups to ensure enterprise wide data consistency and compliance. 
  4. Responds to ad-hoc requests pertaining to data or informational analysis.
  5. Responsible for compiling weekly/monthly management reports and information.
  6. Tracks and evaluates results, incorporates historical trends, and interprets results into clear and concise management reporting.
  7. Performs continual data validation and creates process/procedural improvements to insure data integrity.


Position Requirements:

  1. Bachelor’s degree in accounting, finance or related field or equivalent experience; M.B.A. or comparable advanced degree preferred.
  2. A minimum of 0-3 years of relevant professional experience in a comparable role.
  3. Experience or familiarity in utilizing BI tools such as Business Objects, Qlik Sense, and/or Tableau
  4. Understanding of relational databases. Ability to use and write SQL.
  5. Excellent communications, interpersonal and project leadership skills required. Strong working knowledge of Microsoft Office; standard business systems software skills; and an aptitude to learn and effectively use new and/or proprietary systems and applications is required.
  6. Level of confidence to perform tasks with minimal supervision.
  7. A quick learner who retains training, builds on experience, and is able to exercise good situational judgment.
  8. A comfortable multi-tasker who is able to adjust to changing priorities and respond to time-critical scenarios in a dynamic environment.
  9. Demonstrated ability to work effectively at various levels within an organization.
  10. Ability to work collaboratively with business partners and IT to implement data solutions.
  11. Data driven mindset


Position Summary

Nearest Major Market: Columbus
Nearest Secondary Market: Dublin

Job Segment: Business Analyst, Database, SQL, Technology