Data Engineer I (Remote) — Cloud ETL & Snowflake

Agence PROvidence; Irvine (CA); Remote; USD 110,000 - 170,000; Full time

Benefits offered by this job

401(k) plan

Health benefits

Professional development

Job summary

Responsibilities include building ELT/ETL pipelines, implementing observability, and mentoring junior engineers while adopting emerging technologies to standardize processes.

Qualifications

• Bachelor’s in CS/Engineering or equivalent experience; senior‑level hands‑on ownership of production data operations.
• 1+ year of related experience in Snowflake, CTRL‑M, and ADF.

Responsibilities

• Automation and monitoring batch/streaming ELT/ETL pipelines across cloud services and Snowflake; keep data fresh and accurate.
• Triaging failures, performing root‑cause analyses and post‑mortems, and continuously reducing MTTR.
• Orchestrating schedules and dependencies (e.g., Ctrl‑M) and managing connectors (Fivetran/HVR).
• Building operational automation with SQL, Python, and shell (Bash/PowerShell) on Linux.
• Implementing observability: logging, alerting, data‑quality checks, audits, and runbooks.
• Optimizing Snowflake performance and spend (warehouses, caching).
• Enforcing access controls and secrets management, supporting compliance and audit needs.
• Partnering with product/analytics teams; documenting procedures and providing reliable on‑call support (rotational).

Skills

SQL

Python

Shell

Cloud data warehousing

ETL/ELT tooling

Git/CI-CD

Data ingestion

Snowflake basics

Education

Bachelor’s in CS/Engineering or equivalent

Master's degree (preferred)

Tools

Snowflake

CTRL‑M

ADF

Job description

Responsibilities include building ELT/ETL pipelines, implementing observability, and mentoring junior engineers while adopting emerging technologies to standardize processes.