Digital Solution Architect (Datawarehouse/Architecture/Analytics)

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Strategic Staffing Solutions, is seeking the following. Apply via Dice today!Strategic Staffing Solutions is currently looking for a Digital Solutions Architect , a W-2 contract opportunity!Digital Solutions ArchitectLocations: Charlotte, NCType: W-2 Contract (NO C2C)Schedule: HybridPosition OverviewThe Digital Solutions Architect will provide strategic and technical leadership for thecompany's enterprise analytics ecosystem, supporting a segment of the company's dataportfolio through the migration of a very large on-premises SQL Server-based datawarehouse to AWS.This role is responsible for defining and governing the organization's reference dataarchitecture, rooted in data fabric and data mesh principles, enabling scalable,performant, and governed analytics across multiple business domains. The architect willestablish architectural standards, patterns, and best practices for cloud analytics whileworking closely with data engineering teams to ensure high-quality implementation.The ideal candidate brings extensive experience designing AWS-native analytical platformsusing Amazon Redshift, PostgreSQL, Amazon S3, and Apache Iceberg, paired withstrong knowledge of modern BI tools, including Microsoft Power BI and AWS QuickSight.Key Responsibilities:Support the enterprise data architectural strategy for data warehousing andanalytics platforms on AWS, aligning to business priorities across ECOM, EAM, andNGBU domains.Define and steward the North Star architecture for analytics, based on data fabricand data mesh operating models, including domain data products, sharedservices, 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, andanalytical patterns.Establish and govern architectural standards for:o Amazon Redshift, PostgreSQL, and S3-based analyticso Apache Iceberg table design and lifecycle managemento Analytical data modeling and layer separationApply and evangelize AWS best practices for performance optimization, intelligentscaling, workload isolation, and cost-aware design.Partner closely with data engineering teams, maintaining a strong understanding ofETL/ELT data flows, pipeline patterns, and orchestration approaches, whileremaining hands-on-keys.Provide architectural oversight for analytics consumption layers leveraging Power BIand AWS Quick Sight, ensuring alignment with upstream data design.Lead architecture reviews, solution design sessions, and technical decision forumswith 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-scaledata platform design.Proven experience architecting AWS-based analytics platforms, including:Amazon RedshiftPostgreSQLAmazon S3Apache Iceberg or similar open table fo