Data Engineer

Employer
SpartanNash
Location
Dulles, VA
Posted
Aug 18, 2022
Closes
Aug 20, 2022
Ref
629124337
Function
Engineer, IT, QA Engineer
Hours
Full Time
At SpartanNash, we deliver the ingredients for a better life through customer-focused innovation. We do this for our supply chain customers and US military commissaries, retail store guests and, most importantly, our Associates. In fact, we see a day when each will say, "I can't live without them." Our SpartanNash family of Associates is 17,500 strong, ranging from bakery managers to order selectors; from IT developers to vice presidents of finance; from HR Business Partners to export specialists. Each of them plays an integral role in SpartanNash's People First culture, Operational Excellence and Insights that Drive Solutions. Ready to contribute to the success of our food solutions company? Apply now! Location: Remote Address - Remote City, Minnesota 55124 Job Description: Position Summary: In this role, you will have experience in understanding retail and/or wholesale business processes in order to design, develop, and deploy dimensional data models for reporting and analytics. These qualifications will ensure reliability, scalability, and performance for our growing enterprise Data Warehouse. Here's what you'll do: Create and maintain various database versions to model data to optimize database design and share relational data across various applications. Document data model standards and database diagrams. Work with cross-functional departments to coordinate the database changes in a timely and accurate manner. Utilize modeling tools to build and analyze databases and to develop logical and physical models to include relationships, constraints, attributes, and other modeling information to understand impact for proposed systems, and setup approved systems. Identify, troubleshoot and resolve data integrity and performance issues. Design data model structures that enhance the application performance through the development of aggregation and summarization structures. Document model structures (ie, keys, indexes, constraints) and partner with cross-functional IT (ie, Data Warehouse/Database Administration) for the process of data normalization and physical data base design. Gather and document business requirements and convert requirements into testable designs; and work with the business and application teams to refine design requirements on assigned projects. Maintain data reliability and integrity to eliminate data redundancy and to streamline the reporting platform. Maintain current knowledge of organization data uses to recommend improvements and maintain data integrity. Establish and maintain common data definitions (ie, naming guidelines, standard abbreviations, naming conventions) for database users to eliminate data redundancy and improve data integrity. Document data definitions and coordinate data models, dictionaries, and other database documentation across multiple applications. Provide technical guidance to the applications development team regarding database design to reduce risk of design issues. Interface with appropriate IT sub-departments and/or cross functional business areas to address concerns and resolve issues in a timely manner. Participate in the development of project scope and milestones to meet assigned project requirements. Partner cross-functionally to meet deadlines and audit databases/reports, and work with management on critical issues. Here's what you'll need: Bachelor's Degree (Required) Computer Science Information Technology, Business Administration or related field or equivalent combination of education and/or experience Five (5) years of Information Technology experience in database modeling/relational database administration. Experience with and knowledge of creating Data Warehouse dimensional models, data modeling tools, principles and practices and related configuration management concepts. Programming PL/SQL and ETL development experience is necessary, Microsoft Azure (preferred) Experience creating logical and physical data models to optimize database design - experience in Erwin a plus. Experience profiling and retrieving data from business applications using a wide variety of database platforms. Experience with modern ETL/ELT tools (Talend/Matillion/DataStage) preferably in a cloud environment. Experience with version control systems (Git/SCCS) Ability to identify, troubleshoot, and resolve data integrity and performance issues Background supporting retail or wholesale distribution would be advantageous CORPORATE1 SpartanNash is a certified Veteran-Friendly Employer. We value the perspectives, backgrounds, skills, work ethic and leadership that those who are military connected bring to the workforce. As part of our People First culture, SpartanNash is proud to offer a robust and competitive Total Rewards benefits package . SpartanNash is an Equal Opportunity Employer that celebrates diversity and believes employing a diverse workforce is key to our success. We are committed to providing equal employment opportunities to all individuals. We are not able to sponsor work visas for this position.

Similar jobs