Automation Engineer: Data Workflows & Pipelines

Astreya; Fremont (CA); On-site; USD 120,000 - 160,000; Full time

Job summary

Astreya in Fremont, CA seeks an Automation Engineer / Data Engineer to design automated workflows for partner onboarding, data updates, and data lifecycle management. You will build ETL pipelines and self-service tools enabling operations teams to perform bulk data tasks with minimal engineering support.

You’ll create automated alerts, dashboards, and health checks to ensure data quality and platform adoption.

Qualifications

• 3+ years in automation or data engineering.
• Proficient in Python and SQL.
• Experience designing and consuming APIs.
• Familiarity with ETL concepts and data quality.
• Experience with job scheduling tools like Airflow or cron.
• Able to work independently with large datasets.

Responsibilities

• Design automated workflows for partner onboarding, data updates, service renewals, and data lifecycle management.
• Create self-service tools enabling bulk data operations without heavy engineering support.
• Build automated alerts for stale data, missing information, or expiring service agreements.
• Build ETL pipelines that synchronize partner data across systems.
• Automate migration of legacy data into centralized platform.
• Develop reconciliation scripts to detect discrepancies between systems.

Skills

Python

APIs (REST/GraphQL)

SQL

ETL concepts

Airflow/cron

Data quality

Data pipelines

Problem solving

Tools

Airflow

Cron

REST/GraphQL

SQL

Hive/Presto

Job description

Astreya in Fremont, CA seeks an Automation Engineer / Data Engineer to design automated workflows for partner onboarding, data updates, and data lifecycle management. You will build ETL pipelines and self-service tools enabling operations teams to perform bulk data tasks with minimal engineering support.

You’ll create automated alerts, dashboards, and health checks to ensure data quality and platform adoption.