Note: The job is a remote job and is open to candidates in USA. AptivaCorp is seeking a hands-on Data Operations Engineer to build and support secure data integrations and automated file-processing workflows. The role focuses on EFT/file transfers, Python and SQL development, data quality, automation, production data pipelines, monitoring, troubleshooting, and operational support.
Responsibilities
- Design, build, and maintain secure SFTP/FTPS and PGP-encrypted file transfers
- Develop repeatable processes for onboarding and managing inbound/outbound partner feeds
- Build automated file validation, reconciliation, error handling, retry, and alerting processes
- Develop production-quality Python for data ingestion, transformation, reconciliation, and automation
- Write complex SQL for data validation, reconciliation, uniqueness, variance, and trend analysis
- Monitor data pipelines and proactively identify data quality or processing issues
- Troubleshoot production failures and perform root-cause analysis
- Replace recurring manual processes with automation and monitoring
- Create documentation, runbooks, and procedures for operational support
- Work with engineering, data, and business teams to resolve integration and data issues
- Handle sensitive data using appropriate security, access, and privacy practices
Skills
- • 5+ years of production software or data engineering experience
- • Strong hands-on EFT/file transfer experience, including SFTP/FTPS and PGP/GPG
- • Strong Python development skills
- • Advanced SQL skills, including CTEs, joins, window functions, and data validation
- • Experience with Snowflake or equivalent data warehouse
- • Experience building and supporting production data pipelines
- • Strong understanding of data quality, reconciliation, monitoring, and error handling
- • Automation mindset with experience eliminating manual processes
- • Strong troubleshooting and root-cause analysis skills
- • Excellent written and verbal communication
- • Experience working with sensitive/confidential data
- • Healthcare data experience, particularly EDI/X12, 834, 835, or 837
- • Experience with Airflow, Dagster, Prefect, or similar orchestration tools
- • Experience with Pandera, Great Expectations, dbt, or similar data-quality frameworks
- • CI/CD experience
- • Cloud infrastructure experience
- Experience reducing operational incidents, processing time, or costs through automation
Benefits
- Remote work arrangement
Company Overview
Company H1B Sponsorship