Analytics Engineer

Spot & Tango; New York (NY); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Spot & Tango in New York is searching for an experienced Analytics Engineer to join their data team. This role plays a critical part in driving data-driven decision-making through model creation and maintenance using dbt and various tools. As part of a collaborative team, you will have the opportunity to work across multiple business functions to answer essential analytical questions.

The ideal candidate has a strong background in SQL, data modeling, and experience with business intelligence tools. This hybrid position requires commuting to the Manhattan office on select days.

Qualifications

• At least 3–4 years of experience as an Analytics Engineer.
• Experience with e-commerce is highly preferred.
• Competency in using BI tools like Looker and Omni.

Responsibilities

• Collaborate with stakeholders to develop data models using dbt.
• Monitor pipeline refresh jobs and establish new data sources.
• Develop BI views and facilitate data visualizations.
• Work with teams to identify and fulfill data needs.
• Document models, pipelines, and analytics queries.

Skills

SQL

dbt

Business Intelligence tools

Data modeling

Python

Education

Bachelor's degree in Computer Science, Data Science, or related

Tools

Google BigQuery

Fivetran

Airflow

Job description

Company

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—nothing artificial. We have lofty goals to make every dog in the country healthier and every pet parent happier, 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.

We’re passionate about dogs all day!

Role

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 you 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.
• Cross‑Functional Collaboration: Partner with business and tech teams to identify data needs, translate business requirements 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.

Requirements

• 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
  • Experience with modern BI tools (e.g. Tableau, Power BI, Looker, Sigma, Omni). Experience with Looker and Omni preferred.
  • Experience with data warehousing and pipelines and familiarity with cloud‑based data platforms, especially Google BigQuery and Fivetran.
  • Knowledge of Python and experience with Airflow is a plus.
• Analytical Mindset: Demonstrated ability to analyze complex data sets, draw insights, and communicate findings effectively to both technical and non‑technical audiences.
• Problem‑Solving Skills: Strong problem‑solving and critical‑thinking abilities with a passion for addressing business challenges using data‑driven approaches.
• Communication and Collaboration: Excellent communication skills with the ability to work collaboratively in a cross‑functional team environment.
• Continuous Learning: A self‑motivated individual with a curiosity to stay updated with the latest trends, technologies, and best practices in data and analytics engineering.

Location

This is a hybrid position. You must be able to commute into our office in Midtown Manhattan Monday, Wednesday, and Thursday.

Equal Opportunity Statement

Spot & Tango is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.