remoteonsite
Data Migration Specialist - Addepar
Software Engineer
Lead complex data migration projects for a global investment platform, designing ETL pipelines, ensuring data integrity, and leveraging AWS and Python to deliver high‑quality, AI‑ready datasets.
About the role
Key Responsibilities
- Design, develop, and maintain robust ETL pipelines to migrate large volumes of financial data into the platform.
- Collaborate with data architects and product teams to model source and target schemas, ensuring alignment with business requirements.
- Implement data quality checks, validation scripts, and automated monitoring to guarantee accuracy and consistency.
- Utilize AWS services (S3, Glue, Lambda, Redshift) and Python to orchestrate scalable, fault‑tolerant data workflows.
- Document migration processes, troubleshoot issues, and provide post‑migration support and performance tuning.
Requirements
- 3+ years of experience in data migration, ETL development, or data integration roles.
- Strong proficiency in SQL and Python for data transformation and automation.
- Hands‑on experience with AWS data services (Glue, Redshift, S3, Lambda).
- Solid understanding of data modeling, governance, and quality assurance practices.
- Excellent problem‑solving skills and ability to work cross‑functionally in a fast‑paced environment.