AWS CLOUD DATA SOLUTION ARCHITECHT
Ridgefield, CT - USA
Job Summary
Role: AWS CLOUD DATA / SOLUTION ARCHITECHT
Position: Full-Time salaried w/benefits
Location: Ridgefield CT (Hybrid / On-site preferred) - Flexible work from home days
Interview mode: Webcam
Job Description:
The ideal candidate will be responsible for designs and governs scalable secure cloud native data architecture. This role converts business and analytics needs into Snowflake models patterns and pipelines for consistent data ingestion transformation quality and governance.
If you are passionate about cloud data architecture and are looking for an exciting opportunity to contribute this is the opportunity. Were looking for someone like you to bring expertise and energy to our dynamic team.
Focus Areas: Solution Design Snowflake dbt Data Management ETL and data contracts is essential.
Duties & Responsibilities
-
Design scalable cost efficient Snowflake based data architectures
-
Define standardized patterns for ingestion transformation modeling and consumption
-
Develop solution blueprints including data flows lineage and integrations
-
Establish and govern data contracts (schema SLAs validation evolution)
-
Lead conceptual logical and physical modeling using tools like SqlDBM and dbt
-
Build modular reusable dbt models with strong testing and CI/CD practices
-
Integrate data quality observability and metadata driven validation
-
Design orchestrated pipelines using Airflow Jenkins or similar tools
-
Ensure compliance with governance security and access control standards
-
Partner across data platform and governance teams; mentor engineers and analysts
Value of the Role
This role ensures reliable transparent data flow from source to insight enabling scalable data products trusted analytics and enterprise ready AI on a unified well governed data foundation.
Requirements
-
Experience of analytics layers (Power BI Tableau semantic models)
-
Bachelor degree from an accredited institution with four-plus (4) years IT experience
-
In lieu of a degree ten-plus (10) years of relevant IT experience required.
-
AWS Cloud experience is required.
-
One large-scale cloud modernization project.
-
Enterprise data architecture experience with Snowflake or similar platforms
-
Strong hands on ELT/ETL and dbt skills (models tests macros CI/CD)
-
Deep understanding of Data Vault and dimensional modeling
-
Experience designing and governing data contracts
-
Advanced SQL and ELT expertise
-
Familiarity with orchestration tools Git workflows and governance platforms
-
Strong communication and stakeholder engagement skills
-
Additional: Experience with agile delivery models and willingness to travel occasionally as needed.
Added Advantage Qualifications
-
Data Vault 2.0 experience
-
Familiarity with Iceberg external tables and data catalogs
-
Exposure to cloud native and platform engineering practices
-
Pharmaceutical commercial data experience is a plus.