Data Engineer

Chicago / Engineering / Full-time

Arrive is looking to add a Data Engineer to build and maintain cutting-edge, scalable, flexible data pipelines that allow us to run a modern, data-driven business and uncover real-time insights. Reporting to the Lead Data Engineer, this person will take ownership of the reliability and availability of data in our data warehouse in order to support data analysis and storytelling efforts.

What you'll tackle:

  • Design new enterprise data models and ETL processes to populate them
  • Assess and optimize current data environment
  • 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
  • Extract and transform data from product databases and 3rd party services to provide consumable data and support functions across the organization
  • Detect quality issues, track them to their root source, and implement fixes and preventative audits
  • Manage and optimize Redshift clusters/data lake to ensure current health and performance and future scaling needs
  • Help maintain the process we use to develop, test, and deploy good code
  • What you brIng to the table:

  • Experience with AWS; expertise in Redshift, Postgres or other RDBSs (preferably column-oriented)
  • Expertise in SQL and ability to write and optimize complex queries
  • Experience with Docker, Elastic Container Service, Lambda a plus
  • 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
  • More about the team:

    We are a tight knit team that is fun, inclusive, and hard working. We have a firm, non-negotiable no jerk policy. We accept you for who you are and consider everyone on an equal opportunity basis without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

    APPLY