Senior Data Engineer (Remote)

About us

Since 2009, the company has run a comparison site for car insurance, mortgages and credit cards. Two million people a month visit our recipe and meal planning site, which earns money from ads and a paid membership. We started in 2009 and have grown to about 60 people. Experiments run constantly, and most product decisions follow A/B test results.

About the role

Bellwether Media needs someone who writes solid SQL and Python and treats pipelines like production software. Our team is spread across 20 countries. Headquarters is in Mobile. You will join as an independent contractor on a long-term agreement. Payment is monthly in USD. You will need at least 4 hours of overlap with US Central time. You will need a stable internet connection and a backup power source (UPS or inverter).

What you'll work on

• Work with analysts to define metrics and fix discrepancies between reports.
• Design table layouts and partitioning for Parquet, Delta Lake or Iceberg.
• Handle PII according to retention, masking and access policies.
• Model data in dbt using staging, intermediate and mart layers.
• Build batch and streaming pipelines with Airflow, Dagster or Prefect.
• Respond to pipeline failures and backfill data when needed.
• Tune slow queries and expensive jobs.

What you bring

• Understanding of dimensional modelling and slowly changing dimensions.
• Expert SQL, including window functions and query tuning.
• Working knowledge of AWS, GCP or Azure data services.
• Patience with messy source data and the habit of documenting assumptions.

Preferred

• Dbt Certified Developer or Databricks certification.
• Reverse ETL tools like Hightouch or Census.

What we offer

• Flexible hours.
• Annual rate review.
• Monthly payments via wire transfer or Wise.

Duration: 6 months. Start: Immediately.

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