Analytics Engineer

New York · Remotefull timeRemote

Apply on Employer Site

Analytics Engineer at Clair · LumiJobs

mid

$140k–$150k

H1B: no

Clair The Analytics Engineer at Clair builds and maintains data pipelines, models data for analytics, and collaborates with stakeholders to improve data quality and architecture. The role supports analytics, data science, and business decision-making through data engineering.

Responsibilities

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
Help maintain and extend data pipelines that move data from source systems into Snowflake (e.g., CDC streams, batch ingestion)
Build and maintain scheduled Python jobs for data processing and automation
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)
Contribute to Clair's ELT pipeline and help apply best practices in modeling, testing, documentation, and observability
Support and improve data ingestion pipelines, including CDC replication from Postgres via Kafka and batch loading through Airbyte
Develop and maintain Python-based data jobs that run on a scheduled basis in Snowflake

Qualification

Strong SQL proficiencyExposure to CDC pipelinesStrong communication skillsAdditional DetailsLocation

Required

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 data ingestion and orchestration tools (e.g., Airbyte, Kafka, Airflow)
Understanding of data modeling concepts (dimensional modeling, Kimball, etc.)
Experience with a scripting language like Python or R
Exposure to CDC pipelines, event streaming, or real-time data ingestion is a plus
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.

Benefits

Dental
Vision
401(k)
PTO
Equity/RSU
Parental Leave
Life Insurance

Company

Clair

View company page

Source: ashby

Active within the past hour

Remote-friendly

More roles at Clair

Business Analytics Intern

Dallas, TX

Contract Associate Engineer - Software Development

Seattle, WA

Contract Associate Development Engineer

Baltimore, MD

Product Manager, Connect

New York · Remote

Boost Your Interview Chances

Improve Resume Match Score

Free

Your Score

9.0

Strong Applicant

Must-Have Skills for This Role

SQLPythonSnowflakedbtCDC replicationPostgres

Optimize my Resume

Apply Faster with Autofill

Free

Save your profile once. LumiJobs pre-fills the employer's application form so you stop re-typing the same answers on every site.

Apply With Autofill

Or skip LumiJobs's tools and submit directly on the employer's career site.

Apply on Employer Site