Data Engineer II - Snowflake

Two developers, a designer and a support lead make up most of the company, so everyone touches the product. We are a small, self-funded team building a booking app for independent salons and tattoo studios.

Overview:

We're looking for a Data Engineer II - Snowflake to join our team. This is a remote role. The operations team moves data from about 30 source systems into Snowflake. You'll own ingestion, modeling and data quality checks. Remote, open to candidates across the US. Flexible hours with a daily team call in the morning. We use Slack, Notion and Google Meet. Cameras on for team calls.

Key responsibilities:

• Handle PII according to retention, masking and access policies.
• Write data quality tests with dbt or Great Expectations and alert on failures.
• Ingest data from APIs, SaaS tools and databases with Fivetran, Airbyte or custom Python.
• Tune slow queries and expensive jobs.

Qualifications:

• Familiarity with Git, CI/CD and testing practices for data code.
• Hands-on with an orchestration tool such as Airflow.
• Working knowledge of AWS, GCP or Azure data services.
• Patience with messy source data and the habit of documenting assumptions.
• Understanding of dimensional modeling and slowly changing dimensions.

What you get:

Salary: $144,000 - $170,000 a year

• Health insurance.
• 401(k) with a 100% match up to 5%.
• Paid time off.
• Vision insurance.

Applicants must be authorized to work in the U.S.

Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Lilacward.