ETL Engineer
Anyone can sell and deliver groceries. We'll ask you to deliver a great job.
Effectively administering an online grocery-shopping and delivery service might look easy. Which is precisely what we want our customers to think at Peapod a pioneering, expanding industry leader and a legacy of success spanning more than two decades.
Other companies may try to mimic the unique online grocery-shopping and delivery services offered by industry pioneer Peapod. But few can match our commitment to continually delivering the best possible overall customer experience. We are currently seeking an ETL Engineer to join the corporate DBA Team - location for this role is in our downtown Chicago office.
Description of the role
You will work with our small but efficient BI Team, which is part of Peapod’s DBA Team. 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, 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 Responsibilities
- Build and maintain ETL/ELT to move data between our disparate production systems, including Informix, Oracle, MySQL, MS-SQL and external sources
- Become a data steward at Peapod, learning about and assisting others with data expertise from many areas of our business
- Understand the business needs behind the data we pull, and create real solutions to business challenges
- Help support our Data Warehouse and Analytics reporting systems
- Assist analysts and developers with their data needs
Job Requirements
- Bachelor’s or higher degree, and 1-3 years of experience
- Competency in Pentaho Kettle required
- Experience with SSIS or other ETL tools
- Strong knowledge of SQL
- Working experience with Relational Database Systems
- Solid understanding of Database Design
- Experience with BI Reporting Tools is a plus
Peapod 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.