Data Engineer

Halvik Corp delivers a wide range of services to various executive and independent agencies, focusing on Digital Services and Advanced Analytics. They are seeking a Data Engineer to support the DOT Secure Data Commons/Data Analytics and Visualization Environment platform, where the engineer will design, build, and maintain data pipelines.

Responsibilities:

• Designing and implementing ETL/ELT pipelines using Python and PySpark within a distributed compute environment
• Working with big data technologies including Apache Spark for large-scale data transformation and processing
• Developing scalable database solutions using PostgreSQL and other relational or columnar data stores
• Contributing to data quality monitoring and automated testing frameworks within pipeline workflows
• Supporting the development of data visualizations and dashboards (Tableau, Power BI)
• Participating in code reviews, documentation, and change control processes
• Collaborating with senior architects to implement data catalog and metadata tagging standards
• Rapidly learning new tools and platforms as the program evaluates and adopts them, including emerging AI and analytics capabilities

Requirements:

• Bachelor's degree in Computer Science, Data Science, Engineering, Statistics, or a closely related technical discipline
• Strong SQL skills with practical experience querying relational or columnar data stores
• Proficiency in Python for data processing, transformation, and scripting
• Demonstrated experience with ETL/ELT processes, data manipulation, or database management - through coursework, projects, or internship
• Familiarity with version control and collaborative development practices (Git)
• Portfolio or GitHub repository demonstrating data engineering or database project work
• Must be eligible to obtain and maintain Public Trust security clearance