Data Engineer (Mid)

SMX Services & Consulting, Inc.; Baton Rouge (LA); On-site; USD 55,104 - 63,149; Full time

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