ETL Developer with Snowflake (Only Locals - Fulltime - Hybrid - Atlanta, GA)

Overview

Hybrid
Depends on Experience
Full Time
50% Travel

Skills

ETl
Snowflake
SQL
SSIS
BI

Job Details

ETL Developer

2-3x week onsite (Hybrid)

Location: Atlanta, GA

Fulltime Role

Key Responsibilities:

  • ETL Development: Design, develop, and maintain ETL processes to efficiently extract, transform, and load data from various sources into SQL Server and Snowflake.
  • Data Integration: Integrate data from diverse sources, including on-premises databases, cloud-based services, and third-party applications.
  • Database Management: Create and optimize SQL queries, stored procedures, and functions in SQL Server and Snowflake to support data processing and reporting.
  • Data Modeling: Collaborate with data architects and analysts to design and implement data models that meet business requirements and optimize performance.
  • Performance Tuning: Monitor and optimize ETL processes for performance and scalability, addressing any bottlenecks or inefficiencies.
  • Data Quality: Implement data validation and cleansing processes to ensure data accuracy and integrity.
  • Documentation: Maintain comprehensive documentation for ETL processes, data flows, and system architecture.
  • Collaboration: Work closely with business stakeholders, data analysts, and other team members to understand data needs and deliver solutions that meet those needs.
  • Troubleshooting: Diagnose and resolve issues related to ETL processes, data integration, and database performance.
  • Experience: 5+ years of experience in ETL development with a strong background in SQL Server and Snowflake.
  • Technical Skills: Proficiency in SQL, T-SQL, and Snowflake SQL. Hands-on experience with ETL tools such as SSIS (SQL Server Integration Services) or equivalent.
  • Data Warehousing: Understanding of data warehousing concepts, data modeling, and dimensional modeling.
  • Scripting Languages: Experience with scripting languages (e.g., Python, PowerShell) is a plus.
  • Cloud Platforms: Familiarity with cloud platforms (e.g., AWS, Azure, Google Cloud) and their data services.
  • Problem-Solving: Strong analytical and problem-solving skills with attention to detail.
  • Communication: Excellent communication skills with the ability to collaborate effectively with technical and non-technical stakeholders.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.