Data lead (ETL)- Snowflake, SQL, Python

$48,000 - $192,000/Yr

Photon - Atlanta, GA

Full-time - Senior

Atlanta, GA

Professional, Scientific, and Technical Services

About the position

We are seeking a seasoned Data Lead with expertise in ETL processes to spearhead data-driven projects and initiatives. The ideal candidate will possess a strong background in Snowflake, SQL, and Python, focusing on efficient data management, transformation, and analysis. This role is pivotal in overseeing the design and development of scalable data solutions, ensuring optimal performance and alignment with business needs.

Responsibilities

• Lead the design, development, and maintenance of ETL pipelines to support data transformation and integration across various systems.
• Architect, implement, and optimize data solutions on the Snowflake platform, ensuring scalability, performance, and reliability.
• Collaborate with stakeholders to understand business requirements, ensuring the ETL processes align with organizational data needs.
• Develop and maintain complex SQL queries to extract, manipulate, and analyze data from multiple sources.
• Build and automate data workflows using Python to enhance data transformation and integration tasks.
• Monitor data quality, consistency, and integrity, implementing error-handling and performance-tuning techniques where necessary.
• Provide technical leadership and mentorship to junior data engineers and analysts, promoting best practices in ETL and data management.
• Ensure data governance and security compliance throughout all data processes.
• Continuously evaluate emerging tools and technologies to enhance the ETL process and data platform efficiency.

Requirements

• 6+ years of experience in ETL design, development, and implementation.
• Proficiency in Snowflake for data warehousing and advanced analytics.
• Strong knowledge of SQL (including query optimization) and working with relational databases.
• Expertise in Python for building, automating, and optimizing data workflows.
• Hands-on experience with data integration tools and frameworks (e.g., Informatica, Talend, Airflow, etc.).
• Familiarity with data modeling, data lakes, and cloud platforms like AWS, Azure, or GCP.
• Experience with data governance and security best practices.
• Excellent problem-solving and analytical skills, with a keen attention to detail.
• Strong communication and collaboration skills, capable of working with cross-functional teams.

Nice-to-haves

• Experience with machine learning or advanced analytics.
• Certifications in Snowflake, AWS, or Azure.
• Knowledge of CI/CD pipelines and automation tools for data deployments.

Benefits

• Paid holidays
• Health insurance
• Dental insurance
• 401(k)
• Paid time off
• Vision insurance