Live Chat

Data Modeler Job in Columbus, Ohio US

Data Modeler

American Chemical Society - Columbus, OH

Posted: 10/22/2021 - Expires: 1/20/2022

Job ID: 233245936


Job Description

Data Modeler

Date: Oct 22, 2021

Columbus, OH, US, 43202

  American Chemical Society

CAS uses unparalleled scientific content, specialized technology and unmatched human expertise to help R&D organizations across Commercial, Government and Academic sectors 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 112 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 actionable scientific insights accessible to innovators worldwide.

CAS is currently seeking aData Modeler. This position will be located in our headquarters in Columbus, Ohio.

DataModelers are responsible for creating and maintaining high quality physical and conceptual data models and schemas. They also work to identify and define common information requirements and design conceptual structures and plans to meet the current and long-term data requirements of the assigned data domains.


Create, manage, and modify logical and physical data models using a variety of data modeling philosophies and techniques

Closely partner with Data Stewards to understand the needs of the business and what data relationships the models represent along with helping to identify what relationships and dependencies also need to be reflected.

Establish and maintain comprehensive data model documentation

Profile source data and meet regularly with IT partners to develop complete source to target data mappings

Develop requirements and perform data collection, cleansing, transformation, and loading to populate facts and dimensions for data warehouse

Interact with application development, enterprise architecture, business intelligence, and technology services on a regular basis

Model Entities, Attributes, Relationships and Keys that logically matrix to the conceptual models

Coordinate with the database administration group to ensure day-to-day activities (statistics collection and reporting) are performing in the most efficient manner (data warehouse and big data environments)

Investigate data quality issues to determine root cause, resolve any data issues and recommended process change to prevent reoccurrence

Perform other duties as assigned


4 Year BA/BS degree in Computer Science, MIS, or Business Administration

5-8 years working experience in a data modeling role

Understanding of various data modeling techniques (for example Inmon and Kimball)

1-2 years working experience with ER Studio or comparable data modeling tool experience

Strong understanding of relational databases, querying and building

Experience with data in a large scale service architecture

SQL knowledge

Experience analyzing data profiling, data mining, data cleansing, data content, scrubbing data, and translating data via rules from one database to another

Strong Data Modeling skills to include data quality, source systems analysis (DB2, Oracle, VSAM, etc.) business rules validation, source to target mapping design, and preparation of sample data examples

Effective interview and meeting facilitation skills are required

Strong analytical ability and problem solving skills

Strong organizational skills

Ability to work effectively both in a team environment and independently.

Strong written and verbal communication skills.

Ability to travel as required

Desired, but not required:

Knowledge and experience in chemistry, drug discovery/development, or medical related industry

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.

Nearest Major Market: Columbus
Job Segment:
  Database, Oracle, Information Technology, IT Architecture, Computer Science, Technology



Job Summary

Employment Type:
Full Time Employee
Job type:
Federal Contractor
Skill Based Partner:
Education Level:
Bachelor's degree
Work Days:
Mon, Tue, Wed, Thu, Fri
Job Reference Code
Licenses / Certifications:
Display Recommended WorkKeys®Recommended WorkKeys®: