Digital Solution Architect (Datawarehouse/Architecture/Analytics)

Strategic Staffing Solutions is currently looking for a Digital Solutions Architect , a W-2 contract opportunity!

Digital Solutions Architect

Position Overview

The Digital Solutions Architect will provide strategic and technical leadership for the

company's enterprise analytics ecosystem, supporting a segment of the company's data

portfolio through the migration of a very large on-premises SQL Server-based data

warehouse to AWS.

This role is responsible for defining and governing the organization's reference data

architecture, rooted in data fabric and data mesh principles, enabling scalable,

performant, and governed analytics across multiple business domains. The architect will

establish architectural standards, patterns, and best practices for cloud analytics while

working closely with data engineering teams to ensure high-quality implementation.

The ideal candidate brings extensive experience designing AWS-native analytical platforms

using Amazon Redshift, PostgreSQL, Amazon S3, and Apache Iceberg, paired with

strong knowledge of modern BI tools, including Microsoft Power BI and AWS QuickSight.

Key Responsibilities:

• Support the enterprise data architectural strategy for data warehousing and



• analytics platforms on AWS, aligning to business priorities across ECOM, EAM, and



• NGBU domains.



• Define and steward the North Star architecture for analytics, based on data fabric



• and data mesh operating models, including domain data products, shared



• services, and federated governance.



• Architect the migration of a large, complex SQL Server data warehouse to AWS,



• guiding modernization of domain aligned data models, storage formats, and



• analytical patterns.



• Establish and govern architectural standards for:



• o Amazon Redshift, PostgreSQL, and S3-based analytics



• o Apache Iceberg table design and lifecycle management



• o Analytical data modeling and layer separation



• Apply and evangelize AWS best practices for performance optimization, intelligent



• scaling, workload isolation, and cost-aware design.



• Partner closely with data engineering teams, maintaining a strong understanding of



• ETL/ELT data flows, pipeline patterns, and orchestration approaches, while



• remaining hands-on-keys.



• Provide architectural oversight for analytics consumption layers leveraging Power BI



• and AWS Quick Sight, ensuring alignment with upstream data design.



• Lead architecture reviews, solution design sessions, and technical decision forums



• with engineering, analytics, and business stakeholders.



• Serve as a senior technical advisor, influencing roadmaps, investment decisions,



• and long-term platform evolution.

Required Qualifications:

• 10+ years of experience in data warehousing, analytics architecture, or large-scale



• data platform design.



• Proven experience architecting AWS-based analytics platforms, including:

o Amazon Redshift

o PostgreSQL

o Amazon S3

o Apache Iceberg or similar open table fo