AWS Solution Architect in Charlotte

Job Description

Hybrid 3 on in Charlotte, NC

Our client seeks a Solutions Architect to lead strategy and technical design for an AWS-based analytics ecosystem, guiding the migration of a large on-premises SQL Server data warehouse to cloud- services. The role will define reference architecture aligned to data fabric and data mesh principles, set enforceable standards, and partner with engineering to deliver performant, governed analytics. Expertise with Amazon Redshift, PostgreSQL, Amazon S3, Apache Iceberg, and BI consumption via Power BI and QuickSight will be essential. The architect will influence roadmaps and ensure alignment across data engineering and analytics stakeholders.

Due to client requirements, applicants must be willing and able to work on a w2 basis. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance.

Rate: $82.00 to $92.00/hr. w2

JN -042026-106674

Responsibilities

• Support the enterprise data architectural strategy for AWS analytics platforms across multiple business domains.

• Define and steward a North Star analytics architecture based on data fabric and data mesh operating models.

• Architect the migration of a complex SQL Server data warehouse to AWS with modernized data models and storage formats.

• Establish and govern architectural standards for Amazon Redshift, PostgreSQL, S3-based analytics, Apache Iceberg table design and lifecycle, and analytical data modeling with clear layer separation.

• Apply AWS best practices for performance optimization, intelligent scaling, workload isolation, and cost-aware design.

• Partner with data engineering teams on ETL/ELT flows, pipeline patterns, and orchestration while remaining hands-on.

• Oversee analytics consumption layers with Power BI and AWS QuickSight to align with upstream data design.

• Lead architecture reviews, solution design sessions, and technical decision forums with engineering and business stakeholders.

• Advise leaders on roadmaps, investments, and long-term platform evolution.

Experience Requirements

• 10+ years in data warehousing, analytics architecture, or large-scale data platform design.

• Proven experience architecting AWS analytics with Amazon Redshift, PostgreSQL, Amazon S3, and Apache Iceberg or similar open table formats.

• Record of leading migrations from on-premises SQL Server data warehouses to cloud- architectures.

• Strong understanding of data fabric and data mesh concepts, including domain ownership, data products, and federated governance.