Snowflake Data Engineer

Job Description

Job Description

Overview

CTG is seeking a skilled Snowflake Data Engineer to join our client's growing data engineering team. This role is ideal for a data professional with strong Snowflake expertise who enjoys designing scalable cloud data warehouses, building high-performance ELT pipelines, and delivering reliable data solutions that power enterprise analytics. You'll collaborate with cross-functional teams to develop secure, optimized, and scalable data platforms in a cloud environment.

Location: New York, NY
Duration: Ongoing Contract

• Design, develop, and optimize cloud-native data warehouses using Snowflake.
• Build, maintain, and enhance scalable ELT data pipelines for structured and semi-structured data.
• Configure and administer Snowflake features including virtual warehouses, stages, Snowpipe, streams, and tasks.
• Develop optimized SQL queries, stored procedures, views, and User-Defined Functions (UDFs).
• Design dimensional data models using Star and Snowflake schemas.
• Monitor and optimize platform performance through query tuning, clustering keys, materialized views, and result caching.
• Implement security and governance using Role-Based Access Control (RBAC), data masking, and row- and column-level security.
• Develop transformation workflows using dbt and/or Snowpark with Python or Java.
• Collaborate with business stakeholders, data architects, and analytics teams to translate business requirements into scalable data solutions.
• Ensure data quality, governance, reliability, and adherence to enterprise best practices.
• Participate in Agile development activities including sprint planning, testing, code reviews, and deployments.

• Advanced Snowflake development and administration.
• Expert SQL development and query optimization.
• Strong experience with dimensional data modeling (Star and Snowflake schemas).
• Python and/or Bash scripting.
• Experience with dbt, Snowpark, or similar data transformation frameworks.
• Knowledge of AWS, Azure, or Google Cloud Platform.
• Experience building ELT/ETL pipelines and cloud data integration solutions.
• Snowflake performance tuning and optimization.
• Data governance, RBAC, data masking, and security best practices.
• Strong analytical, troubleshooting, and communication skills.
• Experience working within Agile/Scrum environments.

• 4+ years of experience building cloud-native data platforms.
• Minimum 3 years of hands-on Snowflake engineering experience.
• Proven experience designing and optimizing enterprise data warehouses and ELT pipelines.
• Experience integrating data from multiple enterprise systems into cloud-based analytics environments.
• Demonstrated ability to translate business requirements into scalable technical solutions.

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related technical discipline.
• Equivalent professional experience will also be considered.

Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.

CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee based recruitment services for this role.

To Apply:
To be considered, please apply directly to this requisition using the link provided. Kindly forward this to any other interested parties. Thank you!