Analytics Engineer
Envoy
We are a top-notch data organization with a great culture and have the same high standards with our code, systems, practices, and people. We value learning and growth and hire diverse, well-rounded, communicative people.
- Pipeline Management: You’ll build and maintain robust and scalable data pipelines, monitoring and optimizing data pipeline performance
- Data Modeling: Be responsible for designing, implementing and maintaining scalable and efficient models for both structured and unstructured data
- Collaboration: Partner with product, engineering, and Go-to-Market stakeholders to ensure we’re collecting and processing the right data to drive decision making
- ETL Development: Develop and optimize ETL processes to load data into our data stores, then implement efficient testing and validation to ensure the accuracy and integrity of the data
- Dataset Evaluation: You’ll be the decision maker on how the data is consumed for our internal and external stakeholders
Our main technology stack currently includes Redshift, Spark, AWS Glue, Databricks, dbt, Airflow, Looker, Segment and Jupyter Notebooks. If you’re looking to challenge the status quo and build the Office OS, come join us.
You will
- Expand our data warehouse with clean data ready for analysis
- Help to define and improve our internal standards for style, maintainability, and best practices for high-scale data infrastructure
- Apply software engineering best practices like version control, naming conventions, and continuous integration to the analytics code base
- Maintain our orchestration infrastructure (we use Airflow) as well as build high quality data models (we use dbt) to answer key business questions
- Push the boundaries of our data stack by implementing new tools and technologies that increase the efficiency and productivity of our team
- Lead efforts to design data models and build curated data sets that are the foundation of reporting and analytics at Envoy
- Mentor junior members of the team
You have
- 5+ years in data engineering or analytics engineering, with experience at a high-growth startup preferred
- Advanced SQL skills with experience standardizing queries and building data infrastructure involving large-scale relational datasets
- Experience using Python to parse, structure, and transform data
- Significant hands-on experience with modern data stack tooling. Our stack includes Redshift, Spark, AWS Glue, Databricks, dbt, Airflow, Looker, and Segment
- Experience working with databases that power APIs for front-end applications
- Hands-on experience with maintaining and scaling dbt
- Experience working with CI/CD pipelines
You are
- Someone with extremely high standards that obsesses over data accuracy. You’re practical and know perfect is the enemy of good, but you aspire for us to be great. You care deeply about the quality of your work and our data. You are passionate about finding the insights and “truth” that data can give.
- A big picture, systems thinker. You think about how the whole is a sum of many parts and how we can properly measure them end to end such that we have the per context for insights.
- An owner. You feel personally accountable and responsible and know seeing the problem is less than half of it. You look for problems and inefficiencies and find elegant solutions to them before they become major issues.
- Fast-paced. You love the speed of and impact you have in startups. Conversely you never, ever want to be a tiny cog in a gigantic machine.
- An open-minded learner. You live to learn new things, like staying up to date on new technologies, tools, and techniques. You are inspired by what people inside and outside Envoy know and are eager to incorporate the world's knowledge into your work.
- Emotionally mature & humble. You care about being effective over being right. Ideally you’ve made major changes & decisions in your life and learned from the results.
- Communicative & empathetic. You are happy when helping others succeed, particularly your team and partners across the company.
You'll get
- A high degree of trust in your ideas and execution
- An opportunity to partner and collaborate with other talented people
- An inclusive community where you feel welcomed and cared for as a person
- The ability to make an immediate impact helping customers create a great workplace experience
- Support for your personal and professional growth
If you are located in San Francisco Bay Area, our expected cash compensation for this role is $152,000 - $179,000 (Annually). This is a hybrid position that requires at least 3 days a week (Tuesday - Thursday) in our San Francisco HQ office.