Data Engineer (Snowflake & dbt)
About The Position
CTG is hiring a Data Engineer for a 12-month client engagement in San Antonio, Texas. The role focuses on designing, developing, and maintaining enterprise data pipelines, data warehouses, and integration solutions. The engineer will build and optimize transformation workflows with Snowflake and dbt, integrate data using IBM DataStage and other data management tools, and automate job scheduling and workflows with Control-M. The position also involves ensuring data quality, accuracy, reliability, and performance; troubleshooting data processing issues; improving efficiency and scalability; and collaborating with technical teams and business stakeholders on data and analytics needs. Candidates must successfully complete a background check. A bachelor's degree in Computer Science, Information Systems, Engineering, or a related field is preferred, though equivalent relevant experience is acceptable. Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required. CTG asks applicants to apply directly to the requisition and does not accept unsolicited resumes from headhunters, recruitment agencies, or fee-based recruitment services.
Requirements
- Strong proficiency in Snowflake and dbt for data warehousing and transformation.
- Experience with IBM DataStage for ETL development and data integration.
- Knowledge of Control-M for job scheduling and workflow automation.
- Strong SQL, data modeling, and data integration skills.
- Excellent analytical, problem-solving, and troubleshooting abilities.
- Experience designing, developing, and maintaining enterprise data engineering solutions.
- Hands-on experience with Snowflake, dbt, DataStage, and Control-M.
- Background integrating data across platforms and optimizing large-scale data processing systems.
- Must successfully complete a background check.
- Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group.
Nice To Haves
- Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field; equivalent relevant experience is also acceptable.
Responsibilities
- Design, develop, and maintain data pipelines, data warehouses, and data integration solutions.
- Build and optimize data transformation workflows using Snowflake and dbt.
- Integrate data from multiple sources using IBM DataStage and other data management tools.
- Develop and maintain automated job scheduling and workflows using Control-M.
- Ensure data quality, accuracy, reliability, and performance across enterprise data systems.
- Troubleshoot data processing issues and implement solutions to improve efficiency and scalability.
- Collaborate with technical teams and business stakeholders to support data and analytics requirements.
