Data Engineer - CLEARED

The Squires Group

Washington (District of Columbia)

On-site

USD 90,000 - 131,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

PTO
Medical insurance
401(k) plan
Life insurance

Job summary

The Squires Group is seeking a Data Engineer to design, develop, and optimize secure, scalable enterprise data solutions supporting modernization and cloud migration of a background investigation system. The role emphasizes AWS data platforms, Medallion Architecture, and robust ETL/ELT pipelines. Candidates must be U.S.

Citizens with an ACTIVE TOP SECRET CLEARANCE and a Security+ certification on day one. You will work in a collaborative Agile environment with cross-functional teams to deliver

Qualifications

  • Active Top Secret clearance or TS eligibility, with the ability to complete adjudication/transfer requirements, and a Security+ certification required on day one.
  • 7+ years of experience designing, developing, and supporting enterprise data engineering solutions and modern data platforms.
  • Strong expertise in relational databases, including PostgreSQL, Oracle, and SQL Server, with experience integrating semi-structured and NoSQL data sources, such as DynamoDB, JSON, and APIs.
  • Extensive experience designing and implementing Medallion Architecture (Bronze, Silver, Gold) and dimensional data models for analytics and operational reporting.
  • Hands-on experience with Amazon 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 Amazon 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 solutions, 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 synchronization patterns.
  • Experience optimizing SQL queries, Spark jobs, partitioning strategies, indexing, and Redshift performance for large-scale datasets.
  • 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 that align with cloud migration objectives.
  • Optimize performance, availability, and disaster recovery across environments.
  • Collaborate with the client team to identify data requirements for user stories and update the unified data model.
  • Leverage the data lake to capture functionality-specific data.
  • Ensure compliance with data governance, security, and data retention policies.
  • Document database designs, configurations, and operational procedures.

Skills

Data modeling
ETL/ELT
SQL
Python
Spark
Redshift
NoSQL
CDC

Education

Security+ certification

Tools

AWS Glue
Spark/PySpark
SQL Server
PostgreSQL
Oracle
Redshift
DynamoDB

Job description

Overview

Our client is a large global integrator. They are seeking a Data Engineer. In this role you will design, develop, and optimize secure, scalable enterprise data solutions supporting the modernization and cloud migration of their background investigation system, leveraging AWS data platforms, modern data architectures, and advanced ETL/ELT technologies.

Per our Federal Government Contract, candidates must be U.S. Citizens with an ACTIVE TOP SECRET CLEARANCE.

Responsibilities
  • Design scalable, secure, and high-performance database architectures to support Mirador modernization.
  • Define data models and storage strategies that align with cloud migration objectives.
  • Optimize performance, availability, and disaster recovery across environments.
  • Collaborate with the client team to identify data requirements for user stories and update the unified data model.
  • Leverage the data lake to capture functionality-specific data.
  • Ensure compliance with data governance, security, and data retention policies.
  • Document database designs, configurations, and operational procedures.
Qualifications
  • Active Top Secret (TS) clearance or TS eligibility, with the ability to complete adjudication/transfer requirements, and a Security+ certification required on day one.
  • 7+ years of experience designing, developing, and supporting enterprise data engineering solutions and modern data platforms.
  • Strong expertise in relational databases, including PostgreSQL, Oracle, and SQL Server, with experience integrating semi-structured and NoSQL data sources, such as DynamoDB, JSON, and APIs.
  • Extensive experience designing and implementing Medallion Architecture (Bronze, Silver, Gold) and dimensional data models for analytics and operational reporting.
  • Hands-on experience with Amazon 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 Amazon 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 solutions, 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 synchronization patterns.
  • Experience optimizing SQL queries, Spark jobs, partitioning strategies, indexing, and Redshift performance for large-scale datasets.
  • Experience working within Agile/Scrum teams and collaborating with application developers, architects, and business stakeholders.
Nice to Have:
  • AWS Certified Data Engineer – Associate or AWS Certified Solutions Architect certification.
  • Experience designing enterprise data lakes and lakehouse architectures.
  • Experience implementing enterprise metadata repositories and data catalogs.
  • Familiarity with Qlik and AWS Glue Data Catalog.
  • Experience supporting real-time and near-real-time data integration architectures.
Compensation:
  • W2 Hourly rate: $65 - 95/hour. Pay rates are based on experience, qualifications, location, and certifications, and are subject to change at any time.
  • Benefits vary by compensation type and may include paid time off (PTO), medical, dental, and vision coverage, life insurance, long-term disability insurance, a 401(k) plan, and additional optional benefits.
4 Reasons to Join The Squires Group, Inc.:

1. Our Commitment to You - We offer competitive pay, multi-year projects, and a list of exciting clients.

2. Work-Life Balance - We work hard; we work smart and have quality time for family and "life."

3. Golden Rule - We treat our consultants the way we want to be treated: with integrity, professionalism, and trust.

4. We Care About You – We help you meet your career goals and continuously support your efforts in the field.

The Squires Group, Inc. is an Equal Opportunity/Affirmative Action Employer.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Top-Secret Data Engineer — AWS & Medallion Architecture
Top-Secret Data Engineer — AWS & Medallion Architecture

The Squires Group • Washington

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

NewGen Technologies • United States

Remote
USD 140,000 - 190,000
AWS MDM / Big Data (Data Lake) Engineer
AWS MDM / Big Data (Data Lake) Engineer

Select Search Associates LLC • Fairfax (VA)

On-site
USD 120,000 - 180,000
Data Engineer (Active Secret Required)
Data Engineer (Active Secret Required)

Creative Global Consulting • United States

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

Digitailor • Washington

On-site
USD 120,000 - 170,000
Workforce Analytics Data Scientist - CLEARED
Workforce Analytics Data Scientist - CLEARED

The Squires Group • Washington

Hybrid
USD 62,000 - 76,000
Cloud Data Engineer - Clearance Required
Cloud Data Engineer - Clearance Required

Phoenix Operations Group • Bethesda (MD)

On-site
USD 110,000 - 140,000
Medical Insurance
Dental Insurance
Vision Insurance
+7
Data Engineer
Data Engineer

Eliassen Group • United States

Remote
USD 69,000 - 79,000
Medical, Dental, Vision
401k with company matching
Life insurance
Senior Data/Systems Analyst
Senior Data/Systems Analyst

Diaconia • Gaithersburg (MD)

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

Disruptive Solutions, LLC • Washington

Hybrid
USD 120,000 - 160,000