Data Engineer (5626)

SMX; Hartford (CT); On-site; USD 96,000 - 159,000; Full time

Benefits offered by this job

Health insurance

Paid leave

Retirement

Competitive compensation

Job summary

SMX in Hartford, CT is seeking a Data Engineer to architect, build, test, and maintain data infrastructure for mission partners. You will design scalable data pipelines and perform ELT/ETL work to transform raw data into trusted datasets.

Collaborate with analytics and business teams to define data requirements, optimize schemas, and ensure data quality. Proficiency with SQL, AWS Glue, Glue Catalog, and Step Functions is highly valued.

Qualifications

• Bachelor's degree or higher in a relevant field.
• 3 years of professional experience in data engineering or backend software engineering.
• Active Top Secret security clearance.
• Strong proficiency in SQL and data query creation.
• Hands-on experience with AWS services (Glue, Glue Catalog, Step Functions).
• Experience with data modeling, data migration, and ETL functions.
• Excellent written and verbal communication interfacing with customers.

Responsibilities

• Design, build, test, and maintain scalable data management systems and ELT/ETL pipelines.
• Create data ingestion and transformation infrastructure using cloud technologies, emphasizing AWS Glue.
• Support data migration efforts and ETL functions.
• Optimize database schemas and data collection/validation systems.
• Combine data from various sources to meet business needs.
• Collaborate with analytics and business teams to deliver production-ready datasets.

Skills

SQL

Data modeling

ETL workflows

Data migration

Communication skills

Security clearance

Education

Bachelor's degree in Computer Science, Information Technology, Data Engineering, or related field

Tools

AWS Glue

Glue Catalog

Step Functions

Databricks

Job description

SMX is hiring a Data Engineer responsible for architecting, building, testing, and maintaining the data infrastructure for our mission partners. You will be responsible for a mix of data modeling and backend data mesh work, including creating data queries and performing SQL work. The ideal candidate will analyze and organize raw data, build robust data systems, and explore ways to enhance data quality and reliability. This role involves collaborating with analytics and business teams to transform raw information from different sources into high‑quality, accessible data pipelines.

Essential Duties & Responsibilities:

• Design, construct, test, and maintain highly scalable data management systems and robust ELT/ETL pipelines.

• Build the infrastructure required for optimal extraction, transformation, and loading of data from various sources using cloud technologies, with a strong focus on AWS Glue, Glue Catalog, and Step Functions.

• Support data migration efforts and ETL functions.

• Optimize database schemas and build systems to collect, validate, and prepare data.

• Combine raw information from different sources to meet business and mission needs.

• Work with analytics and business teams to understand data requirements and deliver production‑ready datasets

Required Skills & Experience

• Bachelor's degree in Computer Science, - Information Technology, Data Engineering, or a related field.

• 3 years of professional experience in a data engineering or backend software engineering role.

• Active Top Secret security clearance.

• Strong proficiency in SQL and data query creation.

• Hands‑on experience with AWS services, specifically AWS Glue, Glue Catalog, and Step

• Functions for data integration and workflow automation.

• Experience with data modeling, data migration, and ETL functions.

• Excellent communication skills, both written and verbal, with the ability to interface with customers

Desired Skills & Experience

• Experience supporting AI/ML pipelines, vectorization, or embedding generation

• Experience with data governance, access controls, or sensitive data protection

• Exposure to DevOps/CI‑CD patterns for data workflows

• Experience with Databricks

• Experience with real‑time data streaming and event‑driven architectures

The SMX salary determination process takes into account a number of factors, including but not limited to, geographic location, Federal Government contract labor categories, relevant prior work experience, specific skills, education and certifications. At SMX, one of our Core Values is to Invest in Our People so we offer a competitive mix of compensation, learning & development opportunities, and benefits. Some key components of our robust benefits include health insurance, paid leave, and retirement.

The proposed salary for this position is:

$95,500—$159,100 USD

At SMX®, we are a team of technical and domain experts dedicated to enabling your mission. From priority national security initiatives for the DoD to highly assured and compliant solutions for healthcare, we understand that digital transformation is key to your future success.

We share your vision for the future and strive to accelerate your impact on the world. We bring both cutting edge technology and an expansive view of what’s possible to every engagement. Our delivery model and unique approaches harness our deep technical and domain knowledge, providing forward‑looking insights and practical solutions to power secure mission acceleration.

SMX is an Equal Opportunity employer including disabilities and veterans.

Selected applicant may be subject to a background investigation and/or education verification.

SMX does not sponsor a new applicant for employment authorization or immigration related support for this position (i.e. H1B, F‑1 OPT, F‑1 STEM OPT, F‑1 CPT, J‑1, TN, E‑2, E‑3, L‑1 and O‑1, or any EADs or other forms of work authorization that require immigration support from an employer).