AWS Solution Architect

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-native 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., * 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.

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., * 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-native architectures.
• Strong understanding of data fabric and data mesh concepts, including domain ownership, data products, and federated governance.
• Deep familiarity with AWS performance optimization patterns for analytical workloads.
• Solid understanding of modern ETL/ELT pipelines, ingestion patterns, and transformation strategies.
• Experience supporting enterprise BI platforms including Microsoft Power BI and AWS QuickSight.
• Ability to lead through influence, set architectural direction, and translate strategy into enforceable standards.
• Strong communication skills with both technical and nontechnical stakeholders.
• Experience with AWS Glue, Athena, Lake Formation, Lambda, Step Functions, and CloudWatch (preferred).
• Familiarity with data governance, metadata management, lineage, and observability platforms (preferred).
• Experience in large, regulated, or highly federated enterprises (preferred).
• Exposure to CI/CD, infrastructure as code with Terraform or CloudFormation, and platform automation (preferred).
• AWS certifications such as Solutions Architect - Professional or Data Analytics - Specialty (preferred).
• Experience designing semantic layers or enterprise analytics frameworks for self-service BI (preferred).

Education Requirements:

• AWS certifications such as Solutions Architect - Professional or Data Analytics - Specialty (preferred).

Skills, experience, and other compensable factors will be considered when determining pay rate. The pay range provided in this posting reflects a W2 hourly rate; other employment options may be available that may result in pay outside of the provided range.

W2 employees of Eliassen Group who are regularly scheduled to work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans), dental, vision, pre-tax accounts, other voluntary benefits including life and disability insurance, 401(k) with match, and sick time if required by law in the worked-in state/locality. If anyone reaches out to you about an open position connected with Eliassen Group, please ensure that you are working directly with us by confirming the following:

When you work with Eliassen Group, all email communication will come from an Eliassen.com address, never Gmail, Yahoo, etc.

Eliassen Group is a strategic consulting firm that helps organizations reach further and achieve more through our technology, business advisory, and life sciences solutions. For nearly 40 years, we have combined exceptional people, deep domain expertise, and intelligent capabilities to expand our clients' capacity and accelerate meaningful outcomes. We are driven by a purpose to positively impact the lives of our employees, clients, consultants, and the communities we serve.