Location: Columbus, OH

Position Type: Contract

Position Term: 12+ Months

Qualifications:

• 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

Skills:

• 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