Data Engineer (Mid)

SMX Services & Consulting, Inc.

Baton Rouge (LA)

On-site

USD 55,104 - 63,149

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

A leading consulting firm is seeking an experienced data engineer to build reliable data pipelines and models in a secure environment. This position requires 3-5 years of experience, proficiency in SQL and Python, and knowledge of cloud data services. Responsibilities include designing ETL/ELT pipelines, ensuring data quality, and automating workflows. Ideal candidates will also have experience with Airflow and dbt. This is an on-site position with competitive compensation ranging from $40.00 to $45.84 per hour.

Qualifications

  • 3-5 years of data engineering experience in production environments.
  • Strong SQL and scripting language expertise, preferably in Python.
  • Hands-on with Airflow and dbt, and familiarity with cloud data services.

Responsibilities

  • Design, implement, and operate ETL/ELT pipelines.
  • Model data for analytics and application consumption.
  • Automate CI/CD for data workflows and implement monitoring.

Skills

SQL
Python
Data pipeline design
ETL/ELT processes
Cloud services

Education

Bachelor’s in Computer Science or related field

Tools

Airflow
dbt
Spark
Kafka

Job description

SMX Services & Consulting, Inc. provided pay range

This range is provided by SMX Services & Consulting, Inc. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$43.00/hr - $45.84/hr

Clearance: Ability to obtain/maintain Public Trust (IRS)

Work Location: On-site, authorized work sites

Authorized work sites

  • IRS Main Building – 1111 Constitution Ave NW, Washington, DC 20224
  • IRS New Carrollton Federal Building (NCFB) – 5000 Ellin Rd, Lanham, MD 20706
  • IRS Ogden Office – 2484 Washington Blvd, Ste 200, Ogden, UT 84401
  • IRS Farmers Branch Office – 4050 Alpha Rd, Farmers Branch, TX 75244

Work Hours: Mon-Fri, 8:30a-5:30p

Contract Term: Anticipated 12‑month base; options/surge may be exercised; contingent on award.

Compensation

Candidate Pay: $40.00 - $45.84/hr

About the role

You’ll build reliable, scalable data pipelines and models to power analytics, APIs, and ML workloads in a secure federal environment.

What you'll do
  • Design, implement, and operate ETL/ELT pipelines (e.g., Airflow, dbt, Spark, Kafka)
  • Model data for analytics and application consumption; enforce data quality & lineage
  • Tune warehouses/lakes (Snowflake, BigQuery, Redshift, Delta/Lakehouse)
  • Automate CI/CD for data workflows; implement monitoring and cost controls
  • Partner with application and ML teams to deliver governed, production-ready datasets
Required qualifications
  • 3‑5 years data engineering experience in production environments
  • Strong SQL and one scripting language (Python preferred)
  • Hands‑on with at least one orchestrator (Airflow/Prefect) and one transformation tool (dbt/Spark)
  • Familiarity with cloud data services (AWS/GCP/Azure), object storage, and IAM
Preferred qualifications
  • Streaming pipelines (Kafka/Kinesis/PubSub), schema registry, CDC
  • Data versioning (DVC/LakeFS), great expectations or similar for quality
  • Security and privacy controls; PII handling and encryption at rest/in transit
Education
  • Bachelor’s in Computer Science, Information Systems, Data, or related field
  • Equivalent experience may substitute for degree
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

Sotalent • McLean (VA)

On-site
USD 102,000 - 170,000
Health, dental, and vision insurance
401(k) with company matching
Tuition reimbursement
+2
Data Engineer
Data Engineer

Insight Xcite • Chantilly (VA)

On-site
USD 140,000 - 220,000
Health insurance
401(k) employer contribution
Flexible PTO
+7
Data Engineer
Data Engineer

Insight Xcite • Virginia

On-site
USD 140,000 - 220,000
Medical, dental and vision insurance (
401(k) with 7% employer contribution
Flexible PTO
+5
Data Engineer (5688)
Data Engineer (5688)

SMX • Frankfort (KY)

On-site
USD 103,000 - 172,000
Health insurance
Paid leave
Retirement plan
Data Engineer
Data Engineer

CGS Federal • Tampa (FL)

On-site
USD 112,597 - 152,810
Life Insurance
401k
Flexible Spending Account
+1
Cleared Data Engineer (5786)
Cleared Data Engineer (5786)

SMX • Nashville (TN)

On-site
USD 115,000 - 187,000
Data Engineer (5688)
Data Engineer (5688)

SMX • Richmond (VA)

On-site
USD 103,000 - 172,000
Data Engineer (5688)
Data Engineer (5688)

SMX • Annapolis (MD)

On-site
USD 103,000 - 172,000
Health insurance
Paid leave
Retirement
Data Engineer - Active TS/SCI with CI Polygraph (CIP)
Data Engineer - Active TS/SCI with CI Polygraph (CIP)

TOMORROW HIRE • McLean (VA)

On-site
USD 135,000 - 165,000
100% Company-Paid Health Insurance
Life and disability insurance
401(k) retirement contribution 15%
+2
Data Engineer (5688)
Data Engineer (5688)

SMX • Boston (MA)

On-site
USD 103,000 - 172,000