# Data Analyst

**Company:** [Clay](https://hotfix.jobs/companies/clay)
**Location:** New York, NY
**Role:** Data Analytics
**Salary:** $130k – $170k/yr
**Experience:** 2+ years
**Skills:** SQL, Snowflake, dbt, Sigma, Python, R, Hex, census, Looker, Tableau, mode, reverse etl
**Posted:** 2026-02-20

> The Data Analyst will build analytics models, metrics, dashboards, and analyses that help Product and Go-to-Market teams understand usage and business performance. The role requires strong SQL, experience with dbt or similar workflows, BI proficiency, and at least two years of related experience.

## Job Description

## Responsibilities
- Build and own analytics data models.
- Write clean, maintainable SQL against Snowflake to power core metrics, dashboards, and analytical workflows.
- Build and iterate on analytics metrics and tables in dbt, and surface them through Sigma dashboards to help teams understand product usage, performance, and change over time.
- Use SQL as the primary tool, with Python or R in a notebook environment such as Hex when helpful, to investigate trends, anomalies, and product behavior and connect analyses to business questions.
- Support reverse ETL workflows using Census to make modeled data actionable in the tools teams use daily.
- Partner with cross-functional teams to turn ambiguous questions into clear, useful analytical outputs.

## Requirements
- Strong SQL fundamentals, including joins, CTEs, window functions, and clear query structure.
- Experience building analytical data models or metrics tables using dbt or similar analytics-engineering workflows.
- Comfort working with BI tools such as Sigma, Looker, Tableau, or Mode.
- Strong analytical intuition and the ability to ask effective questions, explore data thoughtfully, and synthesize clear conclusions.
- Clear communication with technical and non-technical partners.
- Curiosity about product usage and business performance, with a focus on understanding why things happen.
- 2+ years of full-time experience in a related role.

## Nice to Have
- Experience with Snowflake or similar cloud data warehousing tools.
- Ability to use Python or R for deeper or more efficient analysis.
- Familiarity with Hex or other notebook-based analysis tools.
- Familiarity with Census or other reverse ETL tools.
- Experience in a product-led or B2B SaaS environment.

## Similar roles

- [Merchant Analytics Manager](https://hotfix.jobs/jobs/ca564c5f-a098-40f2-a2c2-0ebc2fdd0fbe) - Upside - Austin, TX - $123k – $155k/yr
- [Insights Analyst](https://hotfix.jobs/jobs/98cd3d83-c6d1-4859-998a-1df07b75ef7a) - Pave - San Francisco, CA - $115k – $174k/yr
- [AI Search Analyst](https://hotfix.jobs/jobs/2bb21e54-ff36-4ea7-b456-29151be16dc7) - Scrunch - New York, NY - $115k – $145k/yr
- [Strategy & Analytics Associate](https://hotfix.jobs/jobs/ffba9cc5-048a-44cf-ac6f-1c1b0406e676) - SentiLink - Remote - $160k – $190k/yr
- [Data Analyst, Product](https://hotfix.jobs/jobs/70ad680b-26ca-4b15-9643-dab5b7679cb5) - 1Password - Remote - $95k – $133k/yr

**Apply:** https://hotfix.jobs/jobs/7e0bec42-e11a-45cd-9e2a-c02fbeefc103
**Canonical:** https://hotfix.jobs/jobs/7e0bec42-e11a-45cd-9e2a-c02fbeefc103