Data Modeler

Manifest Solutions is currently seeking a Data Modeler for a position in Columbus, OH.Create, manage, and modify logical and physical data models using a variety of data modeling philosophies and techniquesClosely 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 documentationProfile source data and meet regularly with IT partners to develop complete source to target data mappingsDevelop requirements and perform data collection, cleansing, transformation, and loading to populate facts and dimensions for data warehouseInteract with application development, enterprise architecture, business intelligence, and technology services on a regular basisModel Entities, Attributes, Relationships and Keys that logically matrix to the conceptual modelsCoordinate 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 reoccurrencePerform other duties as assignedQualifications:4 Year BA/BS degree in Computer Science, MIS, or Business Administration2-3 years working experience in a data modeling roleUnderstanding of various data modeling techniques (for example Inmon and Kimball)1-2 years working experience with ER Studio or comparable data modeling tool experienceWorking experience with SnowflakeStrong understanding of relational databases, querying and buildingExperience with data in a large scale service architectureSQL knowledgeExperience analyzing data profiling, data mining, data cleansing, data content, scrubbing data, and translating data via rules from one database to anotherStrong 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 examplesEffective interview and meeting facilitation skills are requiredStrong analytical ability and problem solving skillsStrong organizational skillsAbility to work effectively both in a team environment and independently.Strong written and verbal communication skills.Ability to travel as requiredDesired, But Not RequiredKnowledge and experience in chemistry, drug discovery/development, or medical related industry - provided by Dice

Created: 2025-11-15