AWS CLOUD DATA / SOLUTION ARCHITECHT - 1777


Location: Ridgefield, CT (Hybrid / On-site 2-3 days) - Flexible work from home days
Employment Type: Full-Time, salaried w/benefits
Visa Restrictions: We are currently only able to consider candidates who are authorized to work in the U.S. without sponsorship.
Salary Range: depends on experience and level of role: $140K - $200K + potential bonus


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.   We’re 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.