Technical Data 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 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.

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 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 www.ctg.com.

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.