AWS Solution Architect

Job Title: AWS Solution Architect Duration 6 month(s) Location: Doraville, GA

Job Description Design and implement serverless data pipelines leveraging AWS Lambda, S3, Step Functions, SNS, and Athena for real-time shop floor and production data flow.
Build and maintain Athena data queries to parse, transform, and aggregate manufacturing data stored in S3, supporting KPI dashboards, SAH performance metrics, and operator scorecards.
Develop Python-based automation for AWS workflows and data transformation processes.
Create and manage Infrastructure as Code (IaC) using Terraform or AWS Cloud Formation to deploy secure and repeatable environments.
Develop and optimize SQL and Athena queries for large-scale manufacturing datasets to enable analytics and integration with BI tools (e.g., QuickSight, Power BI).
Design and manage AWS networking components including VPCs, subnets, security groups, and Transit Gateways ensuring secure, multi-plant connectivity and proper segmentation.
Use AWS Systems Manager to maintain and patch EC2 instances, apply configuration baselines, and manage automation runbooks.
Collaborate closely with internal IT, MES, and Digital teams to support integration between AWS and on-prem systems.
Partner with external AWS SysOps and Solution Architects to ensure compliance with best practices, cost efficiency, and resiliency.

Primary Skills
4 years of experience building AWS solutions using serverless and data analytics services (Lambda, S3, SNS, Step Functions, Athena).
Proficiency in AWS Athena for querying, transforming, and analyzing structured and unstructured data stored in S3.
AWS Solutions Architect Associate and/or AWS Developer Associate certification required.
AWS Data Engineer certification preferred.
4 years of experience developing in Python for automation and data processing.
4 years of experience writing and optimizing SQL and Athena queries for analytics or integrations.
Hands-on experience with Terraform or equivalent IaC frameworks.
Strong understanding of AWS networking fundamentals (VPCs, subnets, security groups, Transit Gateways).
Working knowledge of AWS Systems Manager for EC2 operations.
Experience supporting manufacturing or MES environments is a strong plus.
Excellent analytical and problem-solving skills; ability to design and troubleshoot complex AWS data architectures.