Analytics Engineer
3d Design Tools
Apache Airflow
Automation
Bigquery
Cloud
Cloud Data Warehouse
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Architecture
Data Build Tool
Data Engineer
Data Engineering
Data Integration
Data Management
Data Modeling
Data Operations
Data Pipeline
Data Pipelines
Data Platform
Data Processing
Data Warehouse
Data Warehousing
Database
Databases
Dbt
Engineer
ETL
Informatica
Information Technology (IT)
Programming
Rendering Engines
Reporting and Analytics
Snowflake
SQL
Job Description
Clair is looking for an Analytics Engineer to help shape how data moves, models, and is trusted inside the organization. In this hybrid role based in New York City, you will build and maintain data pipelines and dbt models that support reliable analytics and decision-making across teams.
What you’ll do
- Support Clair’s ELT pipeline by applying best practices across modeling, testing, documentation, and observability
- Develop and maintain dbt data models used for analytics and business decisions
- Ingest and model data from new source systems and incorporate it into the data warehouse
- Work with analysts, engineers, and business stakeholders to define metrics, data definitions, and governance standards
- Contribute to data governance, access control, and monitoring across the data stack
- Detect data quality issues and help drive root-cause resolution
- Share ideas as Clair scales its data function
- Occasionally assist the analytics team with ad-hoc or high-priority analysis
How the role connects
As an Analytics Engineer, you’ll work at the intersection of engineering and analytics. Your primary stakeholder is the analytics team, and you will partner with data analysts and data scientists to design, develop, and deliver well-modeled, cost-efficient data models for the analyses used to guide decisions at Clair.
Required experience and skills
- 3-4 years of professional experience in the data analytics field
- Strong proficiency in SQL
- 1-2 years hands-on experience modeling data with dbt in a production environment
- Familiarity with cloud data warehouses such as Snowflake, BigQuery, or Redshift
- Familiarity with cloud data loading tools including Fivetran, Airbyte, or Airflow
- Understanding of data modeling concepts such as dimensional modeling and Kimball
- Experience with a scripting language like Python or R
- Comfort working in, or enthusiasm for, a high-growth start-up environment
- Strong communication skills, including the ability to translate technical work into clear business value
Examples of work
- Model product data into trusted analytic reporting tables
- Support the data science team with feature pipelines
- Contribute to new data management processes that maintain the integrity of production reporting
- Help identify and optimize Snowflake computing cost bottlenecks
- Contribute to and help maintain a code style guide across dbt projects
Tools and technologies
- SQL, dbt
- Snowflake, BigQuery, Redshift
- Fivetran, Airbyte, Airflow
- Python, R
Compensation and location
- Location: New York, NY (hybrid); expected in the office at least three days a week (Tuesdays, Wednesdays, and Thursdays) with additional days occasionally for client meetings
- Salary: USD 140,000 - 150,000 per year
Benefits
- Medical, Dental, & Vision Coverage, with an 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
Additional hiring notes
- Clair will only contact candidates from @getclair.com email addresses
- Clair will never ask for payments or sensitive personal information during the hiring process
- Clair is an equal opportunity employer and values diversity
- For questions: [email protected]
Similar Jobs
