Who We Are

: Spot & Tango is an innovative pet health & wellness brand that delivers personalized meal plans on a subscription basis. Our recipes are developed by leading animal nutritionists and are made with only real, human-grade ingredients... and nothing artificial!

) and we are looking for the right people to help us get there. This is an exciting opportunity to join a VC-backed, high-growth, e-commerce startup and have an outsized impact in an extremely fast-paced environment. Plus, you get to think about dogs all day!

Who You Are

: We are seeking an experienced and highly skilled Analytics Engineer to join our data team. As an Analytics Engineer, you will play a crucial role in driving data-driven decision making across the organization by creating and maintaining dbt models, pipelines, and other tools. Since we are a small data team, you will have the chance to work across our entire business — with members of our Operations, Strategy, Marketing, Product, Engineering, and Finance teams.

You are passionate about using data to uncover insights that drive a business forward — working with teams across that business to understand where data products can be deployed with the greatest effect. You are a confident analyst and highly-proficient in data modeling; you are excited to explore multiple aspects of our business and build foundational datasets in a fast-paced startup environment. You are excited to wear many hats and collaborate cross-functionally to answer a variety of business questions.

You are comfortable using a variety of data technologies, especially dbt, SQL, python, Google BigQuery, and BI tools (we use Omni), and are excited about learning new skills. You are comfortable with shifting priorities and can adapt to new + emerging business objectives.

Responsibilities

: Data Modeling and Transformation : Collaborate with stakeholders to understand their analytical needs and translate these

Requirements

into well-structured data models using dbt. Create tests for dbt models to ensure data quality and manage our daily dbt runs (via dbt Cloud). Pipeline and Model Maintenance : Monitor our pipeline and data model refresh jobs and triage issues if jobs fail.

Help establish new pipelines (via a variety of tools including Portable, Fivetran, and airflow) when we need to ingest new sources of data. BI Development : Develop Omni views and topics, allowing stakeholders to build dashboards, reports, and data visualizations. Create a BI environment that empowers stakeholders to access and interpret data easily.

Implement best practices for Omni development to ensure consistency and standardization across the platform.

into technical solutions, provide timeline expectations, and deliver actionable insights. Documentation : Document dbt models, pipelines, and analytics queries to facilitate knowledge sharing and maintain an organized and accessible data ecosystem.

: Education : Bachelor's degree in Computer Science, Data Science, Statistics, Mathematics, or a related field strongly preferred. Experience : Proven experience as an Analytics Engineer with at least 3-4 years of experience in data modeling, business intelligence, and/or database management. Experience with E-Commerce is highly preferred.

Technical Skills : Strong proficiency in SQL Proficiency in using dbt for data modeling and transformation. g. Tableau, PowerBI, Looker, Sigma, Omni).

Experience with Looker and Omni preferred. Experience with data warehousing and pipelines and familiarity with cloud-based data platforms, esp. Google BigQuery and Fivetran.

Knowledge of Python and experience with Airflow is a plus.