Database Administrator

J5 Consulting; Virginia (IL); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Health coverage

401(k) match

PTO

Tuition reimbursement

Bonuses

Professional development

Job summary

J5 Consulting seeks a Data Engineer to support travel data applications and ETL pipelines for government and commercial clients. You will build and optimize data pipelines, handle diverse data formats, and work with AWS, Spark, and SQL databases in a Linux environment.

Position requires onsite work in the Washington Metropolitan Area with security clearances and US citizenship considerations. Join an 18+ year cybersecurity focused firm.

Qualifications

• Experience building and managing data pipelines.
• Proficiency in Python and AWS cloud services.
• Experience with Spark processing and SQL/RDBMS.
• Comfort with Linux and shell scripting; handling varied data formats.
• Ability to write and validate unit tests.

Skills

Data pipelines

Python

AWS

Spark

SQL

Linux scripting

Data formats

Unit tests

Tools

PostgreSQL/Oracle/MySQL

Apache Spark

NiFi/Airflow (desirable)

Job description

J5 Consulting is a Maryland based company established in 2006 to provide computing and consulting services for government and commercial entities. Our services improve Information System networking performance and compliance and protect electronic assets from loss and compromise. We welcome your application to receive consideration for the following position.

Introduction

The Sponsor requires a team to provide operations and maintenance as well as new development work for existing applications. The Sponsor's office is a central data processor and applications developer for applications that utilize travel data. The Sponsor aims to establish support to travel data applications and the associated backend environment while that travel data undergoes a transition period and is ingested into new environments and user applications. As these travel applications analytic capabilities continue to be absorbed, this team will need to provide ongoing support and development to travel data models and travel data ETL pipelines.

Required Skills and Demonstrated Experience

• Demonstrated experience building and managing data pipelines
• Demonstrated experience with Python
• Demonstrated experience with cloud computing using AWS services
• Demonstrated experience processing data using Apache Spark
• Demonstrated experience with an RDBMS (Relational Database Management System) such as Postgres, Oracle, or MySQL and writing SQL queries
• Demonstrated experience with Linux and shell scripting
• Demonstrated experience analyzing data in different file formats such as CSV, XML, JSON, Avro, and Parquet
• Demonstrated experience writing and validating unit tests

Highly Desired Skills and Demonstrated Experience

• Demonstrated experience in NiFi, Apache AirFlow, or equivalent orchestration tools for data pipelines
• Demonstrated experience with Java or Scala
• Demonstrated experience administering an EMR/Spark cluster
• Demonstrated experience conducting performance tuning of Spark jobs
• Demonstrated experience supporting Hive, Iceberg, or similar SQL access technologies
• Demonstrated experience developing cloud-based security solutions
• Demonstrated experience following configuration management processes to review and deploy code as part of releases

US Citizenship

• This position requires US Citizenship. Verification of US Citizenship to meet federal government security requirements will be confirmed.

Security Clearance

• The successful candidate must have an active U.S. Government Top Secret Security Clearance with a Full Scope Polygraph.
• Clearance Verification: This position requires successful verification of the stated security clearance to meet federal government customer requirements. You will be asked to provide clearance verification information prior to an offer of employment.

Travel

• This position is expected to be onsite. The position will be located within the Washington Metropolitan Area (WMA). Local travel/POV will be on an as needed basis, within the local place of performance.

Join J5 Consulting and Grow Your Cybersecurity Career

At J5, we’re a team of innovators protecting organizations from evolving cyber threats. With 18+ years of success in government and commercial sectors, we offer meaningful opportunities to grow your career.

Benefits

Enjoy comprehensive benefits, including:

• 100% employer-paid health coverage
• a 6% 401(k) match
• PTO
• tuition reimbursement
• bonuses
• professional development, and more

Ready to make an impact?

Explore our open positions and apply today.