Data Engineer

Vienna, VA - USA

Monthly Salary: Not Disclosed

Posted on: 8 hours ago

Vacancies: 1 Vacancy

Job Summary

Halvik Corp delivers a wide range of services to 13 executive agencies and 15 independent agencies. Halvik is a highly successful WOB business with more than 50 prime contracts and 500 professionals delivering Digital Services Advanced Analytics Artificial Intelligence/Machine Learning Cyber Security and Cutting-Edge Technology across the US Government. Be a part of something special!

Role and Responsibilities

This position supports data engineering for the VISTA (Vehicle Importation Safety and Tracking Application) project at NHTSA. The role focuses on managing large-scale XML data processing pipelines PostgreSQL database optimization and building data reporting solutions from ACE (Automated Commercial Environment) data. This is a specialized mid-level data engineering role that performs Operations and Maintenance and Development/Modernization/Enhancement work.

Required Skills:

Database & SQL (Expert Level)
PostgreSQL administration and optimization
Complex SQL query writing and optimization
Stored procedure development and debugging (PL/pgSQL)
Database schema design and normalization
Understanding of indexes query plans and performance tuning Data Processing
Python 3.13 for data engineering tasks
XML parsing and validation at scale
ETL pipeline design and troubleshooting
Data quality validation and error handling
Experience processing millions of records efficiently AWS Services (Working Knowledge)
RDS PostgreSQL
S3 for data storage
Lambda functions for data processing
SQS for pipeline orchestration
Basic understanding of AWS data services

Tools & Environment

Git/GitHub Enterprise for version control
Windows 11 cmd prompt environment
VS Code with Python extensions
AWS CLI for database and S3 access

Preferred Skills:

Experience with data visualization and dashboard creation across multiple platforms (AWS QuickSight Tableau Power BI Python libraries such as matplotlib/plotly)
Understanding of data visualization best practices and ability to translate business requirements into visual analytics
Experience with AI/ML model integration and data quality for ML workflows
Familiarity with AWS Bedrock or similar AI services
Understanding of document processing and OCR technologies
Strong analytical and problem-solving abilities with attention to detail for data quality issues
Ability to work independently with minimal supervision
Clear documentation practices and ability to explain technical data issues to non-technical stakeholders
Diplomatic communication skills and ability to navigate challenging stakeholder relationships while maintaining project momentum
Halvik offers a competitive full benefits package including:
Company-supported medical dental vision life STD and LTD insurance
Benefits include 11 federal holidays and PTO
Eligible employees may receive performance-based incentives in recognition of individual and/or team achievements.
401(k) with company matching
Flexible Spending Accounts for commuter medical and dependent care expenses
Tuition Assistance
Charitable Contribution matching

Halvik Corp is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race color religion sex sexual orientation gender identity national origin disability or veteran status.

Halviks pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job education experience knowledge skills and abilities as well as internal equity alignment with market data applicable bargaining agreement (if any) or other law.

Required Experience:

Halvik Corp delivers a wide range of services to 13 executive agencies and 15 independent agencies. Halvik is a highly successful WOB business with more than 50 prime contracts and 500 professionals delivering Digital Services Advanced Analytics Artificial Intelligence/Machine Learning Cyber Securit...

Role and Responsibilities

Required Skills:

Database & SQL (Expert Level)
PostgreSQL administration and optimization
Complex SQL query writing and optimization
Stored procedure development and debugging (PL/pgSQL)
Database schema design and normalization
Understanding of indexes query plans and performance tuning Data Processing
Python 3.13 for data engineering tasks
XML parsing and validation at scale
ETL pipeline design and troubleshooting
Data quality validation and error handling
Experience processing millions of records efficiently AWS Services (Working Knowledge)
RDS PostgreSQL
S3 for data storage
Lambda functions for data processing
SQS for pipeline orchestration
Basic understanding of AWS data services

Tools & Environment

Git/GitHub Enterprise for version control
Windows 11 cmd prompt environment
VS Code with Python extensions
AWS CLI for database and S3 access

Preferred Skills:

Experience with data visualization and dashboard creation across multiple platforms (AWS QuickSight Tableau Power BI Python libraries such as matplotlib/plotly)
Understanding of data visualization best practices and ability to translate business requirements into visual analytics
Experience with AI/ML model integration and data quality for ML workflows
Familiarity with AWS Bedrock or similar AI services
Understanding of document processing and OCR technologies
Strong analytical and problem-solving abilities with attention to detail for data quality issues
Ability to work independently with minimal supervision
Clear documentation practices and ability to explain technical data issues to non-technical stakeholders
Diplomatic communication skills and ability to navigate challenging stakeholder relationships while maintaining project momentum
Halvik offers a competitive full benefits package including:
Company-supported medical dental vision life STD and LTD insurance
Benefits include 11 federal holidays and PTO
Eligible employees may receive performance-based incentives in recognition of individual and/or team achievements.
401(k) with company matching
Flexible Spending Accounts for commuter medical and dependent care expenses
Tuition Assistance
Charitable Contribution matching

Halvik Corp is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race color religion sex sexual orientation gender identity national origin disability or veteran status.

Required Experience:

Key Skills

Apache Hive
S3
Hadoop
Redshift
Spark
AWS
Apache Pig
NoSQL
Big Data
Data Warehouse
Kafka
Scala

Apply Now

About Company

Halvik

Certifications: CMMI DEV L3 | CMMI SVC L2 | ISO 9001:2015 | ISO 14001:2015 | ISO 17025:2017 | ISO 20000-1:2011 | ISO 27001:2013 Contract Vehicles: GSA OASIS SB | ARMY ITES-3S | 8(a) STARS III |

View Profile View Profile

AI AutoApply

Apply to 100+ jobs with one click