Technical Data Analyst

Job Description

Job Description

Overview

CTG is seeking to fill a Technical Data Analyst position for our client.

 

Location: Atlanta, GA / Charlotte, NC / Raleigh, NC — No Remote
Duration: Ongoing Contract

Duties:

• Analyze SAS programs, macros, datasets, and business logic to support migration and modernization to Snowflake.

• Develop and maintain Source-to-Target Mapping (STM/MapDocs), transformation logic, data lineage, and business rules.

• Perform data profiling, data quality analysis, validation, reconciliation, and root-cause analysis.

• Develop complex SQL, including advanced CTEs, for data analysis and validation.

• Analyze Snowflake schemas, tables, views, data models, and database objects.

• Analyze ETL workflows using Talend and Informatica and support ETL testing and deployment validation.

• Validate data across source, staging, integration, Snowflake, and reporting layers.

• Support data migration, data warehousing, reporting, analytics, and data modernization initiatives.

• Develop or support Power BI/Tableau reports and dashboards.

• Monitor data pipelines and support SLA/OLA reporting and performance tracking.

• Collaborate with Data Engineers, ETL Developers, Architects, Business Analysts, and stakeholders.

• Support SIT, UAT, production releases, post-deployment validation, and issue resolution.

• Maintain data governance, metadata, technical documentation, data lineage, and data quality standards.

Skills:

• SAS code analysis and conversion/migration to Snowflake

• Snowflake Data Warehouse

• SQL and Advanced CTEs

• Data Analysis, Data Profiling, Data Validation & Reconciliation

• Source-to-Target Mapping (STMs/MapDocs)

• Data Lineage, Data Governance & Data Quality

• Data Migration & Modernization

• ETL: Talend, Informatica

• Hive Query Development

• Data Modeling & Database Object Management

• Unix/Linux and Python

• Power BI/Tableau

• Reporting & Analytics

• Performance Optimization

• Dev/Test/QA Deployment Processes

• Machine Learning Pipeline Enablement and SageMaker Integration

• Agile/Scrum

Experience:

• Experience analyzing complex SAS code, datasets, macros, and data transformation logic.

• Experience with Snowflake, SQL, data warehousing, ETL, data migration, and data validation.

• Experience creating Source-to-Target Mapping and data lineage documentation.

• Experience with data profiling, reconciliation, data quality, and governance.

• Experience working with ETL tools such as Talend or Informatica.

• Experience supporting data integration, testing, production releases, and Agile/Scrum environments.

Education:

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field preferred.

 

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!