Data Engineer, Snowflake, Remote

Who we are:

We operate a subscription e-commerce site selling coffee, tea and brewing gear, shipped from our own warehouse. Built and run from New York City, the site connects pet owners with local sitters and dog walkers. Founded in 1993, we now have 100 employees.

About the role:

Northwest Web is hiring a Data Engineer, Snowflake, Remote to work remotely from Sweden. This hire will help replace a set of fragile nightly scripts with tested, monitored pipelines. We are headquartered in New York City and have been hiring remotely since 2020. You will join as an independent contractor on a long-term agreement. Payment is monthly in USD. Expect to work a schedule that overlaps with US Eastern business hours until about noon ET.

What you'll do:

• Model data in dbt using staging, intermediate and mart layers.
• Ingest data from APIs, SaaS tools and databases with Fivetran, Airbyte or custom Python.
• Build batch and streaming pipelines with Airflow, Dagster or Prefect.
• Maintain CI for data code and review pull requests.
• Document datasets and lineage in a catalogue such as DataHub or Atlan.
• Tune slow queries and expensive jobs.
• Write data quality tests with dbt or Great Expectations and alert on failures.

About you:

• Hands-on with an orchestration tool such as Airflow.
• Understanding of dimensional modelling and slowly changing dimensions.
• Working knowledge of AWS, GCP or Azure data services.

Preferred qualifications:

• Kafka, Flink or Spark Structured Streaming.
• Dbt Certified Developer or Databricks certification.

What we offer:

Compensation: SEK 3,900 - SEK 4,900/day

• Paid time off.
• Flexible hours.
• Long-term engagement.

Duration: 6 months. Start: Immediately.

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