About this role
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. 4-6 years of experience in data engineering or related field.