Senior Manager

EXL · IT Services & Consulting

Core Technologies

DBT (Data Build Tool)

Google BigQuery

SQL

Python

PySpark

Git

GCP Services

BigQuery

Cloud Storage

Dataproc

Cloud Composer (Airflow)

Dataflow

IAM

SAS Migration & Modernization

Analyze existing SAS datasets, ETL jobs, PROC SQL code, and SAS macros.

Convert SAS transformation logic into DBT models and cloud-native data pipelines.

Support migration of historical and incremental data from SAS platforms to GCP.

Participate in migration assessments, code conversion, and reconciliation activities.

Data Engineering & Development

Design and develop scalable ELT pipelines using DBT and BigQuery.

Build and optimize data ingestion, transformation, and aggregation processes.

Develop reusable and modular DBT models following best practices.

Implement performance tuning for SQL and BigQuery workloads.

Create and maintain data lineage and metadata documentation.

Data Quality & Reconciliation

Design and implement data quality validation frameworks.

Perform source-to-target reconciliation between SAS and GCP platforms.

Investigate and resolve data inconsistencies and migration issues.

Support automated testing and monitoring of data pipelines.

Graduate in Computer Science, Data Science, or related field. 6-8 years of experience in data engineering or related field.