What are the responsibilities and job description for the Senior Data Engineer position at SOLTECH?
NO SPONSORSHIP OR VENDORS.
MUST BE LOCAL TO ATLANTA, 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.
If you’re an IT professional seeking your next career opportunity, we’d love to match your expertise with a role where you can thrive. Learn more at https://soltech.net/working-for-soltech/.
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.