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
Any Graduate