Business Analyst

Date: Sep 19, 2023

Location: Columbus, OH, US, 43202

Company: American Chemical Society

CAS uses intuitive technology, unparalleled scientific content, and unmatched human expertise to help companies create groundbreaking innovations that benefit the world. As the scientific information solutions division of the American Chemical Society, CAS manages the largest curated reservoir of scientific knowledge, and for 116 years, has helped innovators mine, assess and apply that information to keep businesses thriving. The CAS team is global, diverse, endlessly curious and strives to make scientific insights accessible to innovators worldwide.


CAS is currently seeking a Marketing Business Analyst. This position will be located in our headquarters in Columbus, Ohio.


Position Summary

CAS is currently seeking a Marketing Business Analyst to join the Marketing Technology Operations team. The Business Analyst will manage a suite of marketing information, with primary focus on CAS customer and prospect contacts, as well as accounts and behavioral metrics. This role will be responsible for data compilation, reporting and analysis, and will provide account targeting with associated contact information based on industry, persona, regional and behavioral segmentation, enabling execution of marketing campaigns and initiatives. In addition, the role will work closely with stakeholders across CAS to drive enhancements and process efficiencies across various CAS business applications.


This position collaborates with stakeholders to determine and fulfill data needs, performs compilation and profiling, sophisticated reporting, visualization, requirements gathering, UAT, as well as identification of data enhancement opportunities.


Job Duties

  1. Aggregate data from multiple sources and extract select characteristics to fulfill information requests, with primary focus on marketing campaign audience lists. Ensure accuracy and completeness to derive high value, targeted and on time outputs. 
  2. Acquire, maintain, and integrate data with other information sources. Perform data profiling, develop, and enforce business controls to comply with privacy and organizational policies.  Evaluate data accuracy, completeness, timeliness, and stability and establish repeatable, sustainable extraction processes.
  3. Provide reporting, visualization, and self-service dashboards to evaluate reach, performance and effective access and utilization.
  4. Assess data advancement options and recommend solutions, including external data providers.  Develop actionable plans elevate capabilities to address CAS needs now and into the future.  Achieve best in class content and reach by maximizing the scope and quality of marketing data for lead generation and revenue growth.
  5. Provide Marketing technology applications support to end users by providing support and by fulfilling maintenance responsibilities.
  6. Act as a primary business analyst for the Marketing Technology Operations team by gathering requirements, performing UAT, and partnering with stakeholders across different divisions (e.g. Technology & Sales).  


Job Qualifications

  • BA/BS degree in business data analytics, marketing or related field or equivalent combination of experience and certification in related discipline(s). Advanced degree preferred.
  • 5 or more years of experience with using a variety of the following systems, data analysis systems and tools including:  SQL, advanced Excel, Alteryx, Tableau, SAP ECC and BW, (SFDC), and/or Oracle Eloqua.
  • Data profiling, aggregation, normalization, and transformation experience. An understanding of creative visualization depicting data and insights preferred.
  • Experience with ACS or CAS business data and strong knowledge of CAS customers and related account, contact, usage and/or behavioral data. Understanding of CAS markets, solutions, and associated customer positioning a plus.
  • Demonstrated problem and solving skills. Ability to take complex challenges and break them down to create and implement actionable plans.
  • Highly developed collaboration, communication, and presentation skills. Ability to translate complex situations into understandable findings and actionable recommendations for business partners and leaders.
  • Ability to adjust to change, deal with ambiguity, surmount barriers, and demonstrate solutions focus, with a passion for innovation, discovery & continual improvement.


CAS offers a competitive salary and comprehensive benefits package, including a generous vacation plan, medical, dental, vision insurance plans, and employee savings and retirement plans. Candidates for this position must be authorized to work in the United States and not require work authorization sponsorship by our company for this position now or in the future. EEO/Minority/Female/Disabled/Veteran.

Nearest Major Market: Columbus

Job Segment: Business Analyst, Oracle, Database, SQL, SAP, Technology