Data Engineer - TS Clearance, Medallion Architecture

Creative Global Consulting

United States

On-site

USD 150,000 - 190,000

Full time

6 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Creative Global Consulting is seeking an experienced Data Engineer to design scalable database architectures and modern data platforms in a United States-based environment. The role emphasizes secure, compliant data models and event-driven architectures, with hands-on work in RedShift, AWS Glue, Spark/PySpark, and CDC using DMS.

You will collaborate with cross-functional teams, optimize ETL/ELT pipelines, and ensure robust data governance and metadata management across cloud-native services.

Qualifications

  • Active Top Secret clearance or TS eligibility with ability to complete adjudication/transfer requirements along with a Security Plus certification on day one.
  • 7+ years of experience designing, building, and supporting enterprise data engineering solutions and modern data platforms.
  • Strong expertise in relational databases (PostgreSQL, Oracle, SQL Server) and experience integrating semi-structured and NoSQL data sources (DynamoDB, JSON, APIs).
  • Extensive experience designing and implementing Medallion Architecture (Bronze, Silver, Gold) and dimensional data models for analytics and operational reporting.
  • Hands-on experience with RedShift
  • Hands-on experience developing scalable ETL/ELT pipelines using AWS Glue, Apache Spark/PySpark, SQL, and Python.
  • Experience implementing Change Data Capture (CDC) using AWS DMS to synchronize operational databases with analytical platforms such as RedShift.
  • Strong knowledge of cloud-native AWS data services, including Amazon S3, AWS Glue, Redshift, Lambda, EventBridge, SQS/SNS, IAM, CloudWatch, and Secrets Manager.
  • Experience designing metadata-driven ingestion frameworks, data lineage, and data quality validation processes.
  • Proficiency in data modeling, schema evolution, data versioning, and master/reference data management.
  • Strong understanding of event-driven architectures and application/database
  • Experience optimizing SQL, Spark jobs, partitioning strategies, indexing, and Redshift
  • Experience working within Agile/Scrum teams and collaborating with application developers, architects, and business stakeholders.

Responsibilities

  • Design scalable, secure, and high-performance database architectures to support Mirador modernization
  • Define data models and storage strategies aligned with cloud migration goals
  • Optimize performance, availability, and disaster recovery across environments
  • Collaborate with IBM IVM team to identify data needs for use stories and update unified data model
  • Leverage data lake to capture functionality-specific data
  • Ensure compliance with data governance, security, and retention policies
  • Document database designs, configurations, and operational procedures
  • Active Top Secret (TS) clearance or TS eligibility with ability to complete adjudication/transfer requirements along with a Security Plus certification on day one.

Skills

TS clearance
7+ years exp
RDBMS
NoSQL integration
Medallion Architecture
Dimensional data models
Analytics & reporting
Agile/Scrum
Data governance
Event-driven architecture
SQL optimization
Spark/PySpark

Tools

AWS Glue
Apache Spark
PySpark
SQL
Python
DynamoDB
Redshift
S3
IAM

Job description

Creative Global Consulting is seeking an experienced Data Engineer to design scalable database architectures and modern data platforms in a United States-based environment. The role emphasizes secure, compliant data models and event-driven architectures, with hands-on work in RedShift, AWS Glue, Spark/PySpark, and CDC using DMS.

You will collaborate with cross-functional teams, optimize ETL/ELT pipelines, and ensure robust data governance and metadata management across cloud-native services.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer (Active Secret Required)
Data Engineer (Active Secret Required)

Creative Global Consulting • United States

On-site
USD 150,000 - 190,000
Data Engineer
Data Engineer

NewGen Technologies • United States

Remote
USD 140,000 - 190,000
Data Engineer, Senior
Data Engineer, Senior

Blue Shield of CA • Providence (RI)

On-site
USD 120,000 - 180,000
Data Engineer
Data Engineer

VTG Defense • McLean (VA)

On-site
USD 100,000 - 130,000
Senior Data Engineer — Cloud Data Pipelines & TS Clearance
Senior Data Engineer — Cloud Data Pipelines & TS Clearance

Mitre Corporation • McLean (VA)

On-site
USD 124,000 - 187,000
Data Engineer
Data Engineer

Compunnel Inc. • Boston (MA)

On-site
USD 110,000 - 140,000
Data Engineer
Data Engineer

Compunnel Inc. • Orlando (FL)

On-site
USD 85,000 - 110,000
Data Engineer - AWS Glue & ELT Pipelines | TS Cleared
Data Engineer - AWS Glue & ELT Pipelines | TS Cleared

SMX • Madison (WI)

On-site
USD 96,000 - 159,000
Health insurance
Paid leave
Retirement
Data Engineer - CLEARED
Data Engineer - CLEARED

The Squires Group • Washington

On-site
USD 90,000 - 131,000
PTO
Medical insurance
401(k) plan
+1
Data Engineer - CLEARED
Data Engineer - CLEARED

Digitailor • Washington

On-site
USD 120,000 - 170,000