Automation Engineer

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

What You’ll Do

Build Workflow Automation

• Design and implement automated workflows for partner onboarding, contact updates, service renewals, and data lifecycle management.
• Create self-service tools that allow operations teams to perform bulk data operations without needing engineering support.
• Build automated alerting for stale data, missing information, or expiring service agreements.

Develop Data Pipelines & Integrations

• Build ETL pipelines that synchronize partner data across multiple internal systems.
• Automate the migration of legacy data from spreadsheets, wikis, and siloed databases into the centralized platform.
• Develop reconciliation scripts to detect discrepancies between systems and maintain data consistency.

Automate Operational Processes

• Build tools that auto-retrieve relevant partner contacts during network incidents, reducing response time.
• Create automated escalation and outreach workflows triggered by network events.
• Develop runbook automation to standardize and speed up repetitive operational tasks.

Monitor & Report

• Build dashboards tracking data quality, freshness, and platform adoption.
• Implement automated health checks and audit scripts to detect duplicates, orphaned records, or incomplete entries.
• Create scheduled reports for leadership on automation ROI and data integrity metrics.

Qualifications:

• 3+ years experience in automation engineering, data engineering
• Strong proficiency in Python
• Experience building and consuming APIs (REST and/or GraphQL)
• Familiarity with SQL and data pipeline/ETL concepts
• Experience with job scheduling and orchestration tools (Airflow, cron, or similar)
• Understanding of data quality principles (validation, deduplication, reconciliation)
• Comfortable working with large datasets across multiple source systems
• Strong problem-solving skills and ability to work independently

Preferred:

• Experience with PHP or Hack (server-side scripting)
• Familiarity with graph databases or relationship/entity management systems.
• Experience with CRM, MDM (Master Data Management), or vendor management platforms.
• Understanding of network infrastructure concepts (ISPs, peering, colocation, Points of Presence).
• Experience with Thrift or similar RPC frameworks.
• Background in telecom, network operations, or infrastructure services.
• Experience automating processes in a large-scale enterprise environment.
• Area Technologies
• Scripting & Automation Python, PHP/Hack, Bash
• Data & Pipelines SQL, Hive/Presto (data warehouse), ETL tooling
• Orchestration Scheduled jobs, event-driven triggers