Snowflake Data Engineer

Snowflake Data Engineer

CTG is seeking an experienced Snowflake Data Engineer to design, develop, and support enterprise data warehouse solutions. This role will focus on Snowflake development, ETL processes, SQL development, data integration, and batch scheduling using Control-M. The ideal candidate will have strong IBM DataStage experience, expertise with relational databases, and the ability to support large-scale data environments.

Location: Dallas, TX Duration: 5 months

Key Responsibilities:

• Design, develop, and enhance data warehouse solutions using Snowflake.
• Develop and maintain ETL workflows using IBM DataStage.
• Create and optimize complex SQL queries for data extraction, transformation, and reporting.
• Support data integration processes across enterprise database platforms, including DB2 and Netezza.
• Develop and maintain Unix and Shell scripts to automate data processing tasks.
• Configure, monitor, and troubleshoot scheduled jobs using Control-M.
• Analyze data issues, perform root cause analysis, and implement solutions to improve data quality and performance.
• Collaborate with technical teams and business stakeholders to deliver reliable data solutions.

Required Skills:

• Hands-on experience with Snowflake data warehouse development.
• Strong IBM DataStage ETL development experience.
• Advanced SQL development skills.
• Experience with Control-M or similar enterprise scheduling tools.
• Proficiency with Unix and Shell scripting.
• Experience working with DB2 and Netezza databases.
• Strong understanding of data warehousing concepts and ETL methodologies.

Preferred Skills:

• Insurance industry experience.
• Experience supporting enterprise-scale data analytics environments.
• Strong analytical and problem-solving skills.

Experience:

• 5+ years of experience in data engineering, data warehousing, or ETL development.
• Proven experience building and supporting enterprise data solutions.
• Experience working with large-scale data integration processes and production support environments.

Education:

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field preferred.

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.