WorkboxIn

Senior Manager

EXL · Pune, Maharashtra · Full-time

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.