Data Engineering is the foundational layer of our Data & Analytics stack at Arrive. Data Engineers build, maintain and optimize the entire infrastructure of the data team that powers decision making across the organization. They empower our Business Analysts with raw data, tools and expertise to serve the business in an efficient and scalable manner.

We’re looking for a Data Engineer to help us grow and maintain our data infrastructure and platform. If you're seeking a role that is high impact and full of ownership....please read on.

Please note...we are fully open to remote candidates for this position! Being in Chicago would be great, but isn't necessary.

What you'll tackle

• Accountable for daily completion, accuracy and performance monitoring of all ETL and data warehousing tasks
• Develop new ETL processes to ingest source data from our on-line transactional systems as well was 3rd party services
• Maintain our CI/CD pipeline to ensure Business Analysts can build, test, deploy and iterate quickly
• Maintain infrastructure in AWS and other 3rd party service to support all data team operations and company business intelligence as a whole
• Manage and optimize Redshift clusters/data lake to ensure current health and performance and future scaling needs
• Detect quality issues, track them to their root source, implement fixes and preventative audits
• Become the “go to” expert of our data. Work closely with staff to understand all data from our core systems, partner services, and any other platforms we rely on

What you bring to the table

• Experience with AWS; expertise in Redshift, Postgres or other RDBSs (preferably column-oriented)
• Proficiency in SQL and ability to write and optimize complex queries
• Experience with Docker, Elastic Container Service, Lambda a plus
• DevOps and Linux systems administration fundamentals
• Ability to write customized software in Python, Bash, Go or other common open source languages.
• Experience with Airflow or similar scheduling service a plus
• Experience with CI/CD tools like Jenkins or Drone
• Creativity in approaching data organization challenges with an understanding of the end goal
• A collaborative nature and entrepreneurial spirit. Prior startup experience a huge plus
• A sense of ownership and accountability for your work and the success of the team