Staff Data Engineer

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

The position

This is a backfill for a team member who moved to another team. This hire will help replace a set of fragile nightly scripts with tested, monitored pipelines. Remote, open to candidates across the US. Normal working hours, Monday to Friday.

Day to day

Design table layouts and partitioning for Parquet, Delta Lake or Iceberg. Work with analysts to define metrics and fix discrepancies between reports. Maintain CI for data code and review pull requests. Document datasets and lineage in a catalog such as DataHub or Atlan. Build batch and streaming pipelines with Airflow, Dagster or Prefect. Model data in dbt using staging, intermediate and mart layers. Process large datasets with Spark on Databricks or EMR.

Qualifications

Understanding of dimensional modeling and slowly changing dimensions. 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. Expert SQL, including window functions and query tuning.

Nice to have

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

Compensation: $210,000 to $245,000 per year DOE.

Pay and benefits

Medical, dental and vision insurance. 401(k) with 4% match. Three weeks of PTO to start. Dental insurance.

We are an equal opportunity employer and value diversity. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

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

Start: Within 30 days.

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