Junior Data Engineer

Content moderation runs around the clock, with reviewers in multiple time zones and languages. Founded in 2017, we now have 250 employees.

Job summary:

Hemlockwright Apps is looking for a Junior Data Engineer to join a small, steady team. This hire will help replace a set of fragile nightly scripts with tested, monitored pipelines. Fully remote. You can work from anywhere in the US. Hours are flexible, with one short team call each morning. Good written English matters here, since most updates are written.

Essential duties and responsibilities:

• Write data quality tests with dbt or Great Expectations and alert on failures.
• Tune slow queries and expensive jobs.
• Handle PII according to retention, masking and access policies.
• Process large datasets with Spark on Databricks or EMR.
• Build batch and streaming pipelines with Airflow, Dagster or Prefect.
• Design table layouts and partitioning for Parquet, Delta Lake or Iceberg.

Minimum qualifications:

• Understanding of dimensional modeling and slowly changing dimensions.
• Strong Python for data processing.
• Patience with messy source data and the habit of documenting assumptions.
• Working knowledge of AWS, GCP or Azure data services.
• Familiarity with Git, CI/CD and testing practices for data code.
• Expert SQL, including window functions and query tuning.

Preferred qualifications:

• Terraform for data infrastructure.
• Reverse ETL tools like Hightouch or Census.
• Background in finance or marketing data.
• Knowledge of GDPR, CCPA or HIPAA data handling rules.

What you get:

• Health savings account (HSA) with employer contribution.
• 401(k) with a 100% match up to 5%.
• 11 paid holidays.
• Life insurance.
• Profit sharing.

Start: Flexible.

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