remoteonsite
Senior ETL Developer - Ameriprise Financial
Software Engineer
Senior ETL Developer responsible for designing, building, and maintaining scalable data pipelines using SQL, Python, and AWS services to support enterprise analytics and reporting.
About the role
Key Responsibilities
- Design, develop, and optimize ETL processes for large-scale data ingestion and transformation.
- Leverage SQL and Python to extract, cleanse, and load data into data warehouses and data lakes.
- Utilize AWS services (Glue, Redshift, S3, Lambda) to build serverless and scalable data pipelines.
- Collaborate with data architects and business analysts to translate business requirements into technical solutions.
- Implement data quality checks, monitoring, and alerting to ensure pipeline reliability.
- Document architecture, code, and best practices for maintainability and knowledge transfer.
Requirements
- 5+ years of experience in ETL development and data integration.
- Strong proficiency in SQL and Python for data manipulation and automation.
- Hands‑on experience with AWS data services (Glue, Redshift, S3, Lambda).
- Solid understanding of data warehousing concepts and dimensional modeling.
- Excellent problem‑solving skills and ability to work in a fast‑paced environment.