Data Engineer | SME

The Amatriot Group; Chantilly (VA); On-site; USD 130,000 - 182,000; Full time

Job summary

The Amatriot Group in Chantilly, VA is seeking an experienced Data Engineer (SME) to design, build, and maintain data systems that support advanced analytics and visual intelligence applications. This role develops scalable pipelines, builds enterprise databases, and ensures secure data flows across the organization.

You will integrate new data systems with existing platforms, transform structured and semi-structured data, and collaborate with teams to improve data quality and usability.

Qualifications

• Bachelor's degree required.
• Minimum of 10 years of experience in data engineering or related field.
• Strong experience with relational databases and SQL.
• Hands-on experience building pipelines for structured and unstructured data.
• Experience integrating systems with enterprise data warehouses.

Responsibilities

• Build and maintain data pipelines for visual analytics and high-performance processing.
• Transform structured and semi-structured data into actionable information.
• Design large enterprise relational databases and ensure performance.
• Integrate new data systems with enterprise data warehouses.
• Develop standards for database operations, security, and best practices.
• Collaborate with teams to improve data quality and usability.

Skills

Data engineering

Database development

Analytics & visualization

Zero trust

Communication

Problem solving

Education

Bachelor's degree

Tools

Kubernetes

Terraform

GitLab CI/CD

JFrog Artifactory

AWS

Job description

Location: Chantilly, VA. 4 days onsite.

Security Clearance: Active TS or higher [Required]

Job Type: Full-Time

Target Salary Range*: $130,000 - $182,000

• This represents the potential salary range for this position depending on education level, years of experience and/or certifications in addition to other position specific requirements which may impact salary

Position Overview

The Data Engineer (SME) provides expert leadership in designing, building, and maintaining data systems supporting advanced analytics and visual intelligence applications. This role develops scalable data pipelines, builds large enterprise relational databases, and ensures secure, efficient data flows across the organization. The SME integrates new data systems with existing platforms and transforms structured and semi-structured data into actionable information.

Key Responsibilities

Data Pipeline Development and Transformation

• Build and maintain data pipelines supporting visual analytics applications and high-performance data processing.
• Transform structured and semi-structured data into usable, actionable information.
• Use open-source, commercial off-the-shelf (COTS), and government off-the-shelf (GOTS) technologies to support analytics and data workflows.

Database Design and Systems Integration

• Design and construct large enterprise relational databases and ensure efficient performance.
• Integrate new data systems with existing enterprise data warehouses.
• Refine system performance to support data processing and analytics needs.

Standards and Secure Data Operations

• Develop strategies, standards, and best practices for database operations, programming, and security.

Collaboration and Data Quality

• Collaborate with teams to analyze data needs and improve data quality and usability.

Qualifications

Education

• Bachelor's degree required.

Experience

• Minimum of 10 years of experience.
• Strong experience with relational databases, SQL, and large-scale data design.
• Hands-on experience building pipelines for structured and semi-structured data.
• Experience integrating new systems with enterprise data warehouses.

Skills

• Knowledge of data engineering, database development, or related areas.
• Familiarity with analytics, visualization technologies, and high-performance or distributed computing.
• Understanding of secure data practices and zero trust principles.
• Strong communication and problem-solving skills.
• Technical capabilities supporting an in-house, custom-developed data pipeline.

Infrastructure and Delivery Technologies

• Kubernetes.
• Terraform.
• GitLab CI/CD.
• JFrog Artifactory.
• AWS cloud services.

UI and Application Technologies

• Vue.js.
• Flask.
• Elixir.
• Phoenix LiveView.
• DaisyUI.

ETL and Data Processing

• Python.
• Cribl.
• Apache NiFi.
• PostgreSQL.
• Apache Kafka.
• Splunk.
• Custom GOTS applications.
• Complex data parsing and streamlined ingestion.
• Data provenance and end-to-end lineage tracking.
• Schema-aligned ingestion and normalization of diverse structured and unstructured data.

Other Requirements

• On-site attendance four days per week.

Preferred Qualifications

• Experience with government or multi-enclave data environments.
• Background with data visualization platforms or visual analytics applications.
• Experience with cloud data platforms or hybrid architectures.
• Degree in Data Engineering, Computer Science, or a related field.