Data Engineer II

About Chula Vista Web:

Orders are packed by hand for two carrier pickups a day, and customer emails go to whoever is free. Hobbyists in the US make up most of our customers, and many have been buying since the beginning.

About the role:

Chula Vista Web needs someone who writes solid SQL and Python and treats pipelines like production software. Remote position. Most of the team is in Chula Vista, but nobody is required to come in. Flexible hours with a daily team call in the morning.

Day to day:

• Handle PII according to retention, masking and access policies.
• Tune slow queries and expensive jobs.
• Write data quality tests with dbt or Great Expectations and alert on failures.
• Build batch and streaming pipelines with Airflow, Dagster or Prefect.
• Ingest data from APIs, SaaS tools and databases with Fivetran, Airbyte or custom Python.
• Respond to pipeline failures and backfill data when needed.
• Maintain CI for data code and review pull requests.

About you:

• 2+ years of data engineering, or backend work with data at volume.
• Hands-on with an orchestration tool such as Airflow.
• Expert SQL, including window functions and query tuning.
• Understanding of dimensional modeling and slowly changing dimensions.
• Working knowledge of AWS, GCP or Azure data services.

Nice to have:

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

What you get:

Salary range: $159,000 to $182,000 annually

• $1,000 home office setup budget.
• Home office stipend.

Start dates are flexible, usually within a few weeks of an offer.

Duration: 12 months. Start: Flexible.

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