ETL Developer (Snowflake & AWS)
- Stamford, CT
- Permanent
- Full-time
- We are seeking a skilled ETL Developer with strong experience in Snowflake and AWS to design, develop, and maintain scalable data pipelines and ETL processes. The ideal candidate will have a deep understanding of cloud-based data warehousing, data integration, and transformation techniques, and will play a key role in enabling data-driven decision-making across the organization.
- Design, develop, and optimize ETL workflows and data pipelines using Snowflake and AWS services.
- Implement data ingestion from various sources including APIs, databases, and flat files.
- Ensure data quality, integrity, and consistency across all ETL processes.
- Collaborate with data architects, analysts, and business stakeholders to understand data requirements.
- Monitor and troubleshoot ETL jobs and performance issues.
- Automate data workflows and implement CI/CD practices for data pipeline deployment.
- Maintain documentation for ETL processes, data models, and data flow diagrams.
- Bachelor's degree in computer science, Information Systems, or related field.
- 9+ years of experience in ETL development and data engineering.
- Hands-on experience with Snowflake including data modeling, performance tuning, and SQL scripting.
- Proficiency in AWS services such as S3, Lambda, Glue, Redshift, and CloudWatch.
- Strong programming skills in Python or Scala for data processing.
- Experience with orchestration tools like Apache Airflow or AWS Step Functions.
- Familiarity with version control systems (e.g., Git) and CI/CD pipelines.
- Excellent problem-solving and communication skills.
- Snowflake certification.
- Experience with data visualization tools (e.g., Tableau, Power BI).
- Knowledge of data governance and security best practices.
- Experience in Agile/Scrum development environments