Senior Business Analyst, ACS Publications Sales
Date: Jun 8, 2020
Location:Columbus, OH, US, 43202
Company: American Chemical Society
The Publications Division of the American Chemical Society (ACS) publishes a weekly topical magazine (C&EN) and more than 56 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 Senior Business Analyst will work under the direction of the Manager, Business Analytics supporting primarily the Global Sales, Operations and Marketing teams. S/he will also play a role in developing and expanding the Publications Divisions Enterprise Data needs. S/he will contribute to the comprehensive support of all activities relating to sales, revenue operations and marketing in an effort to accelerate and expand sales. 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 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. S/he will also work as a liaison to the IT department on business requirements and data needs. The position will develop and implement data delivery and visualization tools to end users. S/he will support in the gathering, documentation and design of key business definitions, measures, and standards.
Primary duties will include the following:
Participates in the development of systems and tools used for business monitoring and data analysis. This includes visualization and end user deliverability.
Responsible for the organization and validation of all data elements related to our customers, products and services.
Assimilates, validates & analyzes business data in order to help senior management make informed business decisions.
Works with data governance groups to ensure enterprise wide data consistency and compliance.
Responds to ad-hoc requests pertaining to data or informational analysis.
Responsible for compiling weekly/monthly management reports and information. This includes improving upon current processes.
Tracks and evaluates results, incorporates historical trends, and interprets results into clear and concise management reporting.
Performs continual data validation and creates process/procedural improvements to insure data integrity. Help in documenting current processes.
Required Education and Experience
Bachelor’s degree in finance, information systems or related field or equivalent experience; M.B.A. or comparable advanced degree preferred.
A minimum of 7 years of relevant professional experience including time spent in a comparable role.
Qlik Sense & Qlikview or equivalent visualization tool experience
Strong experience with relational databases (i.e. Microsoft SQL Server)
Understanding of data visualization best practices preferred
Experience in utilizing BI tools such as Business Objects.
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. Salesforce skills preferable.
Proficient in developing data visualization and analytical tools with the ability to provide self-service data analytics.
Understanding of relational databases. Ability to use and write SQL.
Ability to work collaboratively with business partners and IT to implement data solutions
Level of confidence to perform tasks with minimal supervision.
A quick learner who retains training, builds on experience, and is able to exercise good situational judgment.
A comfortable multi-tasker who is able to adjust to changing priorities and respond to time-critical scenarios in a dynamic environment.
Demonstrated ability to work effectively at various levels within an organization and in a team environment.
Continuous improvement mindset.
Nearest Major Market: Columbus
Job Segment: Information Systems, Business Analyst, Database, SQL, Technology