Senior System Architect AWS & Snowflake Data Warehouse

Overview

On Site
Full Time
Part Time
Accepts corp to corp applications
Contract - Independent
Contract - W2

Skills

Lead the end-to-end architecture of cloud-native data warehouse solutions using Snowflake on AWS. Design data ingestion frameworks to source structured
semi-structured
and unstructured data from diverse internal and external systems. Architect and oversee efficient
resilient ELT pipelines using AWS services (e.g.
S3
Glue
Lambda
Step Functions). Define data modeling strategies
schema optimization
and partitioning approaches within Snowflake to support high-performance workloads. Establish enterprise-wide standards for data integration
transformation
and metadata management. Implement robust data security
including IAM integrations
RBAC
encryption
masking
auditing
and compliance controls. Collaborate with engineering
analytics
and business teams to ensure architectural alignment and stakeholder satisfaction. Provide technical leadership on best practices
architectural governance
and tool selection. Develop and maintain comprehensive technical documentation
architecture diagrams
and operational models.

Job Details


Inspiration Global seeking a Senior System Architect AWS & Snowflake Data Warehouse with natural curiosity and a technical mindset who is interested in actively learning, growing, and taking on more responsibility, Own and develop relationships, act as technical point of contact.


As a Senior System Architect AWS & Snowflake Data Warehouse your job duties involve:

Key Responsibilities:



Lead the end-to-end architecture of cloud-native data warehouse solutions using Snowflake on AWS.

Design data ingestion frameworks to source structured, semi-structured, and unstructured data from diverse internal and external systems.

Architect and oversee efficient, resilient ELT pipelines using AWS services (e.g., S3, Glue, Lambda, Step Functions).

Define data modeling strategies, schema optimization, and partitioning approaches within Snowflake to support high-performance workloads.

Establish enterprise-wide standards for data integration, transformation, and metadata management.

Implement robust data security, including IAM integrations, RBAC, encryption, masking, auditing, and compliance controls.

Collaborate with engineering, analytics, and business teams to ensure architectural alignment and stakeholder satisfaction.

Provide technical leadership on best practices, architectural governance, and tool selection.

Develop and maintain comprehensive technical documentation, architecture diagrams, and operational models.



Additional Information:


Job Type: On-site

Duration: Long term

Company Overview:

Inspiration Global is a growing technology consulting & professional services firm with offices in Harrisburg, PA and India. IG is a Certified Minority Business Enterprise in multiple states and certifying agencies. IG helps organizations realign their existing technology investments and embrace new technologies to keep pace with their business growth. For more information, please visit:








Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.