Job Description
CAS is currently seeking a Data Modeler. This position will be located in our headquarters in Columbus, Ohio.
Qualifications:
2-3 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 ERwin Enterprise Data Modeler Suite or comparable data modeling tool experience
Strong understanding of relational databases, querying and building
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 prepare sample data examples
Effective interview and meeting facilitation skills are required
Strong writing and verbal communication skills
Strong analytical ability and problem solving skills
Strong organizational skills
Ability to work effectively both in a team environment and independently.
4 Year BA/BS degree in Computer Science, MIS, or Business Administration

Duties:
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; 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
Modeling of the Entities, Attributes, Relationships and Keys that logically matrix to the conceptual models
Experience with data in a large scale service architecture
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

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

Company Description
At CAS, a division of the American Chemical Society, we are scientists, technologists and business leaders who continuously and passionately pursue new knowledge in our quest to fuel scientific discovery and empower innovation.

Dedicated to the ACS vision of improving peoples lives through the transforming power of chemistry, the CAS team of highly trained scientists finds, collects and organizes all publicly disclosed substance information, creating the worlds most reliable collection of content that is vital to innovation worldwide. CAS provides a suite of solutions relied on by researchers, patent professionals and decision-makers around the world that advance the scientific enterprise by enabling discovery and facilitating workflows.

* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

Launch your career - Upload your resume now!

Upload your resume

Loading some great jobs for you...