Remote Data Architect | AWS & Snowflake Analytics Lead

Shell Infotech; United States; Remote; USD 140,000 - 230,000; Full time

Job summary

Shell Infotech is seeking a Data Architect to design and optimize modern data platforms on AWS and Snowflake, delivering scalable data solutions for enterprise clients. You will own data modeling, pipeline design, governance, and collaboration with AI/ML initiatives, with a strong emphasis on performance, security, and reliability in a remote-first setting.

The role requires 10–17 years of experience in data warehousing, ETL/ELT, and semantic/BI layers, with leadership skills to guide

Qualifications

• Expert-level AWS and Snowflake experience.
• Strong SQL, Python, and PySpark capabilities.
• Hands-on ETL/ELT and data warehousing expertise.
• Knowledge of Kimball dimensional modeling and BI layers.

Responsibilities

• Design and implement enterprise-scale data architectures on AWS and Snowflake.
• Develop and optimize data integration, CDC, and ETL/ELT pipelines.
• Model data with Kimball dimensional modeling principles.
• Maintain semantic and reporting layers for BI and analytics.
• Collaborate with cross-functional teams on governance and quality.

Skills

AWS Cloud Services

Snowflake

SQL

Python

PySpark

Apache Airflow

dbt

Education

Bachelor/Master in CS or related field

Tools

GitHub Copilot

Cursor

Claude Code

Job description

Shell Infotech is seeking a Data Architect to design and optimize modern data platforms on AWS and Snowflake, delivering scalable data solutions for enterprise clients. You will own data modeling, pipeline design, governance, and collaboration with AI/ML initiatives, with a strong emphasis on performance, security, and reliability in a remote-first setting.

The role requires 10–17 years of experience in data warehousing, ETL/ELT, and semantic/BI layers, with leadership skills to guide