Data Modeler

A Data Modeler is needed to analyze data sources and provide detailed data models for the engineering team. This role requires proficiency in SQL for business analytics and an understanding of the company's data usage. The Data Modeler will translate business needs into data models that support long-term solutions, maintaining conceptual, logical, and physical data models while ensuring data integrity by addressing redundancy and unnecessary replication.

Pre-screen consists of video questions and a games section

Candidates can be remote. No location requirements but the Eastern time zone is preferred

This is a contract role supporting the Associate Technology pillar, specifically Supply Chain RMS - Planning, Buying, and Forecasting Data

Requirements

• Advanced proficiency in SQL for data analysis and manipulation

• Strong analytical skills to translate business needs into data models

• In-depth knowledge of XML and XSD for data architecture

• Experience with retail POS databases

• Commitment to staying current with data management trends

Typical Duties

• Develop data models tailored to the organization's information systems

• Create and maintain logical and physical data models using best practices to ensure high data quality and minimize redundancy

• Adhere to Kroger’s best practices for physical naming conventions and database coding

• Evaluate and resolve discrepancies in data models and physical databases

• Work with XML and XSD files, validate data objects, and apply appropriate design principles

• Identify and recommend opportunities for reusing data models in new contexts

• Maintain a model repository with ERWin’s Model Mart and generate accurate DDL from ERWin physical models

• Ensure synchronization of physical models with instantiated databases and test all DDL before deployment, including relational databases, NoSQL databases, JSON files, and XML files