[Remote] IAM Hub: Data Engineering and Reporting

Note: The job is a remote job and is open to candidates in USA. CTG delivers IT and business solutions that enhance clients' digital agility and help them seize new opportunities. The Senior Data Engineer will own complex identity and access management data engineering work, including pipeline development, data governance, business intelligence, analytics, and reporting. The role also involves implementing data certification frameworks, reverse ETL enhancements, schema registry capabilities, and comprehensive documentation.

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

Skills

• * 4+ years data engineering with BigQuery and Google Cloud Platform
• * 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
• * 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 Google Cloud Platform or Azure

Company Overview

Dice offers a marketplace that enables direct connections between recruiters and technologists. It was founded in 1990, and is headquartered in Centennial, Colorado, USA, with a workforce of 201-500 employees. Its website is https://www.uk.dice.com.

Company H1B Sponsorship

Dice has a track record of offering H1B sponsorships, with 2 in 2022, 4 in 2021, 5 in 2020. Please note that this does not guarantee sponsorship for this specific role.