Data Engineer

Summary

Join Olo, a leading SaaS platform in the restaurant industry, as a Data Engineer. You will play a pivotal role in building and maintaining data pipelines, developing dashboards, and integrating data from various sources to provide actionable insights. Collaborate with cross-functional teams, including analytics, product, and external stakeholders. Design, implement, and optimize robust data workflows to empower data-driven decisions. This role offers the opportunity to shape the future of business-consumer interaction and contribute to innovative solutions. Work remotely from anywhere in the U.S. or at Olo's NYC headquarters. The compensation range is $88k-120k annually for a Data Engineer I and $105k-140k annually for a Data Engineer II.

Requirements

• 2+ years of experience in the development of one or more of these technologies: Database solutions, data pipelines, advanced analytics applications
• 2+ years of experience with one or more of these datastores: Snowflake, Redshift, Teradata, Azure Synapse (SQL Data Warehouse), BigQuery, Hadoop, Microsoft SQL Server, PostgreSQL, other leading RDBMS
• Advanced proficiency in SQL (any dialect)
• Adequate knowledge of at least one programming language, ideally one widely used in the data industry, such as: Python, Spark, Scala
• Thorough understanding and application of data modeling principles

Responsibilities

• Design and implement ELT processes and data models using dbt
• Design and maintain data orchestration workflows using Dagster or Airflow
• Build data pipelines to support machine learning use cases, enabling predictive and prescriptive customer facing inference
• Build and optimize processes for sourcing, processing, contextualizing, and modeling data
• Create and maintain near-real-time streaming data pipelines
• Deliver automated solutions to address complex data processing challenges
• Enforce data retention policies to balance liability, cost efficiency, and data lifecycle optimization
• Develop and maintain a comprehensive data catalog, dictionary, and technical documentation derived from data assets and software solutions

Benefits

• 20 days of paid time off
• 10 separate sick days
• 11 holidays, plus year-end closure
• Health, dental, and vision coverage for yourself and your family
• A 401k match
• Remote-office stipend
• Company equity
• A generous parental leave plan
• Volunteer time off
• Gift matching policy
• Remote work