Senior ETL Developer - Fulltime - Hybrid (Atlanta, GA locals only)

Sr ETL Developer

Fulltime

Hybrid - Atlanta, GA

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.

Education: Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field. Relevant certifications are a plus.

Preferred Skills:

Big Data Technologies: Knowledge of big data technologies (e.g., Hadoop, Spark) and their integration with Snowflake.

Data Visualization: Experience with data visualization tools (e.g., Tableau, Power BI) is a plus.

Agile Methodologies: Familiarity with Agile development methodologies.