IAM Hub: Data Engineering and Reporting

Computer Task Group, Inc•UNAVAILABLE, UNAVAILABLE

11h

About The Position

CTG is seeking a Senior Data Engineer to join our team. The Senior DE will work alongside the SA on a full-stack IAM data engagement. Same broad coverage — pipelines, governance, BI — with deep hands-on ownership of the engineering track. Expected to operate independently on complex pipeline builds and contribute equally to analytics and reporting delivery.

Requirements

4+ years data engineering with BigQuery and GCP
End-to-end pipeline development — ingest, transform, serve
DBT — test authoring, incremental models, model design
Airflow / Cloud Composer DAG development
Python for pipeline logic and tooling
Power BI — can build and publish reports against a semantic model
Familiarity with CDC patterns and streaming ingestion
Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.

Nice To Haves

Active Directory / LDAP query and pipeline experience
Cosmos DB or NoSQL serving layer
SailPoint or IGA source system familiarity
Debezium, DataStream, or Pub/Sub
Terraform / infrastructure-as-code
Private networking constraints on GCP or Azure

Responsibilities

Build and certify identity source pipelines: AD LDAP (Bronze → Gold), Entra Event Hub ETL, SailPoint history recovery and CDC assessment
Implement and operationalize dataset certification framework — DBT test suite, CI/CD gate, schema change alerting
Support SCD 2 completion and Gold layer fact table validation in coordination with Mayo data engineering team
Contribute to Power BI report delivery and semantic model design across all three report batches
Implement reverse ETL delta enhancement — CDC-based push to Cosmos DB, replacing current full primary key scan
Build contract schema registry with version-aware drift detection and migration window support
Author pipeline runbooks and full handoff documentation for client team