Senior Data Engineer

SOLTECH; Duluth (GA); On-site; USD 120,000 - 170,000; Full time

Job summary

SOLTECH is seeking a Senior Data Engineer to take ownership of modernizing and evolving their data pipeline architecture. The role focuses on migrating legacy ETL workloads from Redshift stored procedures and SSIS packages into scalable, cloud-native solutions using AWS Glue and S3, in a cross-functional engineering environment.

You will design scalable ETL/ELT pipelines, optimize Redshift performance, and collaborate with analytics and product teams to support AI/ML initiatives and reporting.

Qualifications

• 5+ years of hands-on experience in data engineering.
• Strong expertise with AWS Glue (PySpark/Python), S3, and Redshift.
• Experience migrating ETL workloads from legacy platforms to cloud-native architectures.

Responsibilities

• Design and implement modern ETL/ELT pipelines using AWS Glue, S3, and related AWS services.
• Architect data transformation workflows that are scalable, testable, version-controlled, and observable.
• Optimize and maintain Redshift data warehouse performance, including query tuning and cost management.
• Collaborate with product, analytics, and engineering teams to build data models for reporting, AI/ML initiatives and customer-facing apps.
• Establish and promote best practices, standards, and reusable patterns for data pipeline development.
• Support production data systems, including monitoring, troubleshooting, and incident response.

Skills

Data engineering

SQL

AWS Glue

Python

ETL/ELT design

Tools

AWS Glue

S3

Redshift

dbt

Apache Airflow

AWS Step Functions

Kinesis

Job description

MUST LIVE WITHIN 30 MINUTES OF DULUTH, GA

Our client is seeking a Senior Data Engineer to take ownership of modernizing and evolving their data pipeline architecture. This role is central to a large-scale transformation initiative, focused on migrating legacy ETL processes from Redshift stored procedures and SSIS packages into scalable, cloud-native solutions using AWS Glue and S3. You’ll work within a collaborative, cross-functional engineering environment and play a key role in shaping how data flows across the platform.

Key Responsibilities

• Design and implement modern ETL/ELT pipelines using AWS Glue, S3, and related AWS services to replace legacy systems
• Architect data transformation workflows that are scalable, testable, version-controlled, and observable
• Optimize and maintain Redshift data warehouse performance, including query tuning, materialized views, and cost management
• Collaborate with product, analytics, and engineering teams to build data models that support reporting, AI/ML initiatives, and customer-facing applications
• Establish and promote best practices, standards, and reusable patterns for data pipeline development
• Support production data systems, including monitoring, troubleshooting, and incident response

Required Qualifications

• 5+ years of hands-on experience in data engineering
• Strong expertise with AWS Glue (PySpark/Python), Amazon S3, and Amazon Redshift
• Proven experience migrating ETL workloads from legacy platforms (e.g., SSIS, stored procedures) to modern cloud-native architectures
• Advanced SQL skills, particularly within columnar or MPP databases like Redshift
• Experience with data pipeline orchestration, monitoring, and error-handling frameworks
• Familiarity with infrastructure-as-code and CI/CD practices for data engineering workflows

Preferred Qualifications

• Experience working with Aurora MySQL or other relational databases
• Exposure to real-time or streaming data technologies (e.g., Kinesis, Kafka, MQTT)
• Background working with IoT, metering, or utility-related data
• Familiarity with tools such as dbt, Apache Airflow, or AWS Step Functions

Why Join Our Client

• Make a meaningful impact by contributing to solutions that support critical water infrastructure
• Lead greenfield modernization efforts with strong executive and organizational backing
• Work within a modern, AWS-native technology stack with opportunities to influence architecture decisions
• Collaborate with a dynamic and innovative engineering organization spanning multiple development teams

About SOLTECH

SOLTECH is a leading national technology company based in Atlanta, driven by a steadfast commitment to integrity, strong company values, and customer centricity. For nearly 30 years, we’ve been part of the thriving technology community and have earned honors such as The Atlanta Journal-Constitution’s Top Workplace and the Best & Brightest Companies To Work For In The Nation.

Our exceptional team of engineers, designers, and strategists delivers custom software applications, technology consulting, AI and data engineering solutions, and IT staffing services that help organizations solve complex challenges nationwide.

Join us on our quest to make the world a better place by bringing to life innovative software solutions that make our lives easier, safer, healthier, and more productive.

SOLTECH believes in the dignity of every individual and practices equal employment opportunity as a core principle. We consider all applicants without regard to race, color, age, sex, sexual orientation, gender identity, religion, marital status, national origin, disability, or veteran status.