Snowflake Data Migration & Quality Analyst

Computer Task; Atlanta, Raleigh, Charlotte (GA, NC, NC); On-site; USD 69,000 - 96,000; Full time

Benefits offered by this job

Hybrid work flexibility

Job summary

CTG is seeking a Technical Data Analyst to support client data modernization efforts across multiple locations. The role concentrates on migrating SAS logic to Snowflake, building mappings and data lineage, and validating data throughout the warehouse and reporting layers.

You will work with ETL tools like Talend and Informatica, develop advanced SQL, and help drive data governance and quality initiatives in a collaborative Agile environment.

Qualifications

• Analyze SAS programs, macros, datasets, and business logic for migration to Snowflake.
• Design and maintain STMs/MapDocs, data lineage, and business rules.
• Perform data profiling, quality analysis, validation, and reconciliation.
• Develop complex SQL with advanced CTEs for analysis and validation.
• Analyze Snowflake schemas, tables, views, and data models.
• Support ETL workflows with Talend and Informatica; validate deployments.
• Ensure data governance, metadata, and quality standards.

Responsibilities

• Analyze SAS code and migrate to Snowflake to support modernization.
• Build and maintain STM/MapDocs and data lineage documentation.
• Profile data, perform quality checks, reconcile results, and root-cause issues.
• Develop SQL with complex CTEs for data validation and analytics.
• Collaborate with Data Engineers, ETL developers, and analysts on data projects.
• Support SIT/UAT and production releases with data validation.

Skills

SAS migration

Snowflake DW

SQL/CTEs

Data profiling

Data lineage

Data governance

Data migration

ETL tools

Hive

Data modeling

Unix/Linux

Python

Power BI/Tableau

Reporting/Analytics

Performance tuning

Dev/Test/QA

ML pipeline SageMaker

Agile/Scrum

Education

Bachelor’s degree in Computer Science, Information Systems, Data Analytics

Tools

Talend

Informatica

Snowflake

Power BI

Job description

CTG is seeking a Technical Data Analyst to support client data modernization efforts across multiple locations. The role concentrates on migrating SAS logic to Snowflake, building mappings and data lineage, and validating data throughout the warehouse and reporting layers.

You will work with ETL tools like Talend and Informatica, develop advanced SQL, and help drive data governance and quality initiatives in a collaborative Agile environment.