Description

You will develop and enhance SAS Teradata jobs, stored procedures, and ETL processes for campaign management.

This role is remote.

Responsibilities

• Develop and enhance existing jobs, stored procedures, and SAS Base code.
• Build new campaign and customer management reports.
• Execute ETL processes to prepare data for campaign distribution.
• Manage the full development lifecycle, including test data preparation and validation.
• Operate within an Agile environment using JIRA Kanban boards.

Required Skills

• 8+ years of experience in SAS Teradata development.
• High proficiency in SQL, including Temporal Tables.
• Expertise in SAS functionality: Pass-thru SQL, Proc, Data Steps, and SAS Macros.
• Extensive experience with Base SAS and SAS Enterprise Guide.
• Strong understanding of ETL processing, batch processing, and data change strategies (Type 1, Type 2, versioning).
• Experience with BitBucket and Jenkins for build and deploy processes.
• Knowledge of job scheduling tools and versioned tables for data synchronization.

Preferred Skills

• Query performance tuning.
• Familiarity with SQL Server or making RESTful API calls via Postman.
• Experience with IWS job scheduling.

Key Skills

Education

Not specified