Analytics Engineer

Clair; New York (NY); Hybrid; USD 140,000 - 150,000; Full time

Benefits offered by this job

Medical, Dental, & Vision

Parental leave

401k, HSA, and FSA

Unlimited vacation

WFH setup allowance

Access to earnings

Disability insurance

Job summary

Clair is seeking an Analytics Engineer in New York City to join the analytics team and help build our data pipelines and trusted data models. You will work with product, operations, and finance to design, develop, and maintain ETL/ELT processes using dbt and cloud data warehouses.

You will model data from our products, optimize data quality, and contribute to cost-efficient data architecture in a high-growth startup environment. Hybrid work in NYC with competitive compensation.

Qualifications

• 3–4 years experience in data analytics
• Strong SQL proficiency
• 1–2 years hands-on dbt modeling in production
• Familiarity with Snowflake, BigQuery, or Redshift
• Experience with cloud data loading tools (Fivetran, Airbyte, Airflow)
• Understanding of dimensional modeling (Kimball)
• Python or R scripting experience

Responsibilities

• Model data from products into analytic tables
• Support data science by building model feature pipelines
• Ingest and model data from new sources to the data warehouse
• Define metrics, data definitions, and governance standards
• Maintain data quality and observability across the stack
• Collaborate with analysts, engineers, and stakeholders on data issues

Skills

SQL

dbt

Python or R

Data modeling

Communication

Tools

dbt

Snowflake

BigQuery

Redshift

Fivetran

Airbyte

Airflow

Job description

About ClairIf you can send your friends money in seconds, why does it still take your employer two weeks to send your paycheck?At Clair, we are on a mission to create financial freedom for America's workers by giving them a digital banking platform that allows them to get paid as soon as they clock out of work. But we're not just another digital bank or on-demand pay provider. We meet Americans at their place of work by embedding our products within the scheduling, workforce management, and payroll apps they already use every day.Learn more about us at getclair.com/about

About the Role

As an Analytics Engineer, you'll sit at the intersection of engineering and analytics, helping build Clair's data pipelines, modeling clean and trustworthy data sets, and collaborating with stakeholders across the organization (Product, Operations, and Finance, to name a few). You'll play a key role in improving our data quality and contributing to our data architecture as it evolves.

Your primary stakeholder will be the analytics team. Partnering with data analysts and data scientists, you'll help design, develop, and deliver well-modeled, cost-efficient data models that power the analyses driving decision-making at Clair.

Some examples of what you'll do…

• Model data from our products into flexible, trusted analytic reporting tables
• Support the data science team by building model feature pipelines
• Help build new data management processes to maintain the integrity of production reporting environments
• Help identify and optimize Snowflake computing cost bottlenecks
• Contribute to and help maintain a code style guide across our dbt project(s)

Key Responsibilities

• Contribute to Clair's ELT pipeline and help apply best practices in modeling, testing, documentation, and observability
• Build and maintain data models using dbt that power analytics and business decisions
• Ingest and model data from new source systems to incorporate them into the data warehouse
• Partner with analysts, engineers, and business stakeholders to help define metrics, data definitions, and governance standards
• Support data governance, access control, and monitoring efforts across the data stack
• Identify data quality issues and help resolve root causes
• Contribute ideas and input as we scale the data function
• Occasionally support the analytics team with ad-hoc or high-priority analysis

Qualifications

• 3-4 years of professional experience in the data analytics field
• Strong SQL proficiency
• 1-2 years hands-on experience modeling data with dbt in a production environment
• Familiarity with cloud data warehouses (e.g., Snowflake, BigQuery, Redshift)
• Familiarity with cloud data loading tools (e.g., Fivetran, Airbyte, Airflow)
• Understanding of data modeling concepts (dimensional modeling, Kimball, etc.)
• Experience with a scripting language like Python or R
• Comfortable working in — or excited to work in — a high-growth start-up environment
• Strong communication skills, with the ability to translate technical work into clear business value

Additional Details

Location: This is a hybrid position based in New York City; you will be expected to come into the office at least three days a week (Tuesdays, Wednesdays, & Thursdays) with additional days on occasion for client meetings.

Compensation: The annual base salary for this role is $140,000 - $150,000. The base pay for this role is determined using many factors, such as education, skills, and experience, and is reflective of Clair Series stage and size. Base pay is only one part of Clair’s competitive total compensation package, which includes equity, benefits, and additional perks. The base pay range is subject to change and may be modified in the future.

Need more convincing?

• Medical, Dental, & Vision Coverage, with option to extend to your family
• Fully-paid parental leave
• Company-sponsored 401k, HSA, and FSA
• Unlimited vacation for salaried roles, generous PTO for hourly roles
• Work from home setup allowance
• Access to your earnings every day on Clair
• Company-sponsored short-term and long-term disability insurance

Clair is an equal opportunity employer and we value diversity at our company. We actively seek a diverse applicant pool and do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.