Open Access (OA) Data Analyst

Date: Jun 18, 2022

Location: Columbus, OH, US, 43202

Company: American Chemical Society

The American Chemical Society (ACS) provides access to our premier scientific journals to the academic, corporate, and government research communities. Already established as the most-trusted, most-cited, and most-read journals in chemistry-related sciences, ACS products are well-known to and deeply respected by current and potential customers alike.


We are in the process of expanding our Open Access (OA) Operations Team to handle the increased volume of open access activities within the Sales Analysis and Support (SAS) team within ACS Publications.


This position will be based in Columbus, OH and will work with Publications’ Sales and Sales Support staff as well as with domestic and international clients. While the home organization for this position is Sales Analysis and Support (SAS), the incumbent will coordinate and collaborate extensively with staff in other parts of the Publications Division, as well as in Membership & Scientific Advancement (M&SA) and Treasury and Chief Financial Officer (T&CFO).


The primary role of the OA Financial Data Analyst is to compile, research, analyze and reconcile complex sets of data relating to OA agreement customer accounts as well as independent author OA transactions for ACS Publications Division products, including the following tasks:

  • Performs monthly financial reporting including generation of revenue and accounts receivable data for finance teams.
  • Has responsibility for reconciliation and auditing of OA data to ensure operational transactions tie to financial data.
  • Interacts regularly with business partners to provide data and analytics to answer OA trending and support questions to assist in tactical and strategic decision making. This includes analyzing customer trends
  • Through data and reporting, helps sales staff preempt customer issues; identifies customer utilization patterns to assist sales in account strategies; and identifies possible up-sell opportunities when appropriate.
  • Supports ongoing information technology efforts within open access and data analytics systems and applications through business functionality recommendations, business requirement inputs and business unit testing.


Required Experience and Skills:

  • Bachelor’s Degree preferred; equivalent experience may be considered in lieu of.
  • 3+ years of relevant experience
  • Proven proficiency in Microsoft Office products with an emphasis on Excel and an aptitude to learn and use other web-based applications with comfort and efficiency. Experience with Salesforce and other CRM tools a plus.
  • Excellent verbal and written communication skills to interact effectively with team members and staff at all levels both domestically and internationally.
  • Unwavering commitment to accuracy in and resolution of all tasks – whatever it takes.
  • Demonstrated ability to work independently as well as part of a team.
  • Working knowledge of the publishing industry preferred but not required.
  • Experience working with financial data.
  • Experience working with SQL queries and Qlik.


Nearest Major Market: Columbus

Job Segment: Developer, CRM, Database, SQL, Technology, Research