ETL Developer, VM

Job Description:• Develop and automate ETL workflows using AWS Glue (Python/PySpark) to ingest, transform, and load data into Redshift and S3. • Monitor and troubleshoot pipelines, ensuring data accuracy and SLA adherence. • Optimize S3 storage (partitioning, lifecycle policies) for cost-effective data lake management. • Collaborate on data modeling (star schema, dimensional modeling) for analytics-ready datasets. • Document data flows, ERDs, and lineage for clarity and governance. • Profile and validate data to catch issues early and maintain trust in reporting.• Support BI teams by resolving data discrepancies and improving pipeline efficiency. • Conduct ad hoc analysis and exploratory data work as needed. • Contribute to the documentation of system specifications, testing procedures, and operational support materials. • Participate in code reviews and continuous improvement of development standards. • Provide production support and assist with troubleshooting and resolving data issues. Requirements:• Bachelor's degree in Computer Science or a related field, or equivalent work experience.• 3+ years of related work experience as an ETL Developer, with AWS cloud experience (Glue, Redshift, S3). • Strong SQL & Python (PySpark preferred). • Experience building batch ETL pipelines (not just drag-and-drop tools). • Knowledge of data warehousing (ODS, dimensional modeling, slowly changing dimensions). • Ability to troubleshoot pipeline failures and optimize performance/cost. • Clear communicator who can explain technical details to non-engineers. • Excellent problem-solving and analytical skills.• Strong organizational skills and attention to detail. Benefits:• Salary in USD• Long-term• Flexible schedule (within US Time zones)• 100%Remote Apply tot his job