Snowflake Data Engineer

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 Duties 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. Skills 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. Experience 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. Education 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. About CTG CTG, a Cegeka company, delivers IT and business solutions that enhance clients’ digital agility, empowering them to seize new opportunities and overcome any challenge. Backed by more than 60 years’ experience and a commitment to being a reliable, results-driven partner, we work shoulder to shoulder with clients to shape digital together. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. With more than 9,000 team members in over 15 countries, we combine global expertise with local insight to deliver innovative solutions. We operate across the Americas, Europe, and India, working with over 3,000 clients in many of today's highest-growth industries. Together, we shape what’s next—working shoulder to shoulder to deliver impactful solutions for our clients and society. Our culture is built by the people who work at CTG, the values we hold, and the actions we take. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. At CTG, you’ll find a workplace where you are encouraged to grow, supported in your ambitions, and empowered to shape your own career journey. For more information, visit . CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws. CTG is an Equal Opportunity Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law. CTG is fully committed to promoting employment opportunities for members of protected classes. #J-18808-Ljbffr Computer Task Group, Inc