Job Role: Snowflake Consultant
Location: Hybrid Job at Atlanta, GA
Duration : 6-12 Months of Contract (Extendable)
MUST HAVE: Snowflake and Complex SQL queries experience is a MUST.
Job Description:
An Experienced Snowflake Developer with a strong background in crafting and optimizing complex SQL queries. The ideal candidate will possess in-depth knowledge of Snowflake architecture, AWS services, and SQL programming to design, implement, and optimize data solutions tailored to our business needs. This role requires a strategic thinker with a passion for data analytics and a proven track record of delivering high-quality solutions.
Responsibilities:
- Design, develop, and optimize complex SQL queries in Snowflake to support data integration, transformation, and reporting requirements.
- Collaborate with data architects, data engineers, and business stakeholders to understand data requirements and translate them into scalable and efficient SQL solutions.
- Implement best practices for data modeling, schema design, and query optimization in Snowflake and AWS environments.
- Utilize AWS services such as S3, Glue, and Redshift to ingest, transform, and load data into Snowflake data warehouse.
- Perform query performance tuning and optimization to ensure fast and reliable data retrieval from Snowflake and AWS data sources.
- Develop and maintain ETL pipelines and data workflows using AWS services and Snowflake functionalities.
- Work closely with cross-functional teams to troubleshoot data-related issues, identify root causes, and implement timely solutions.
- Stay current with industry trends and advancements in AWS and Snowflake technologies, and recommend best practices for continuous improvement.
Requirements:
- Bachelor's degree in Computer Science, Information Systems, or a related field.
- Proven experience as a Snowflake Developer or similar role, with expertise in crafting complex SQL queries.
- In-depth understanding of Snowflake architecture, AWS services, and SQL programming.
- Experience with AWS services such as S3, Glue, Redshift, and EC2 for data integration and analytics.
- Strong knowledge of SQL programming, including advanced SQL concepts such as window functions, CTEs, and query optimization techniques.
- Experience with performance tuning and optimization of SQL queries in a data warehouse environment.
- Familiarity with data modeling concepts and techniques, preferably in a Snowflake environment.
- Excellent analytical and problem-solving skills, with a keen attention to detail.
- Strong communication and collaboration skills, with the ability to work effectively in a team environment.
- AWS or Snowflake certifications (e.g., AWS Certified Solutions Architect, Snowflake Certified Professional) are a plus.
Thanks & Regards,
Amit Shrivastava
amit.s@klimbnow.com