Apex Systems Data Warehouse Engineer (948451) in CHICAGO, Illinois

This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/ada/r/jobs/6419514 DescriptionTitle: Data Warehouse EngineerDescription of the roleYou will work with our small but efficient Data Team which supports Peapod Digital Labs - the Retail Business Systems Digital E-Commerce Engine of Ahold Delhaize USA. We work in an Agile-Scrum environment, working closely with end users to understand their requirements, and knowing how to transform those needs into real data benefits. Our team is focused on performance - both in our system efficiencies and in our giving back to our end users. Being with a small team within a large organization, you will have great exposure to many areas of our business, and will have the direct ability to influence how we get our orders delivered every day!Your Job ResponsibilitiesBuild and maintain ETL/ELT to move data between from our disparate production systems into our Data Warehouse(s) of Informix (legacy) and Azure (future)Work with various databases including Informix, MS-SQL, Oracle, MySQL, Postgres and external sourcesBe willing and interested in working with shell scripts and 4GL coding, helping convert those from legacy to future stateBecome a data steward at Peapod Digital Labs, learning about and assisting others with data expertise from many areas of our businessUnderstand the business needs behind the data we pull, and create real solutions to business challengesHelp support our Analytics reporting systemsAssist analysts and developers with their data needsJob RequirementsBachelor's or higher degree, and 1-3+ years of experienceExperience with shell scripting and 4GL codingExperience in Pentaho Kettle or SSIS/Azure Data Factory preferredExperience with SSIS or other ETL tools is a plusStrong knowledge of SQLWorking experience with Relational Database SystemsSolid understanding of Database DesignExperience with BI Reporting Tools, preferably PowerBI, is a plusRetail Business Systems offers a competitive starting salary, with excellent benefits including health, dental, vision, life insurance, 401K with great match, paid time off and flexible spending accounts...and a discount on your groceries! You must be authorized to work in the United States to be eligible for consideration for employment. Peapod is an Equal Opportunity Employer M/F/D/V.EEO EmployerApex is an Equal Employment Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at employeeservices@apexsystemsinc.com or 844-463-6178.VEVRAA Federal ContractorWe request Priority Protected Veteran & Disabled Referrals for all of our locations within the state.We are an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected characteristic. The EEO is the Law poster is available here.https://www1.eeoc.gov/employers/upload/eeoc_self_print_poster.pdf