Data Architect

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

Hiring: Data Architect (AWS & Snowflake)

Location: Remote
Employment Type: Full-Time
Education: B.Tech / M.Tech / M.Sc / MCA
Experience: 10 - 17 Ye1ars

About the Role

We are seeking an experienced Data Architect to design, build, and optimize modern data platforms and scalable data solutions for one of our esteemed clients. The ideal candidate will have deep expertise in AWS, Snowflake, data warehousing, data integration, and cloud-based analytics architectures. This role requires a strong blend of architecture, engineering, and leadership capabilities, with a focus on enabling data-driven business outcomes.

Key Responsibilities

• Design and implement enterprise-scale data architectures on AWS and Snowflake.
• Build and optimize data integration, CDC (Change Data Capture), ETL/ELT pipelines, and data warehousing solutions.
• Develop scalable and high-performance data models using Kimball dimensional modeling principles.
• Architect and maintain semantic and reporting layers to support business intelligence and analytics.
• Collaborate with cross-functional teams to enable data accessibility, governance, and quality standards.
• Support the development of AI/ML-enabled data products and advanced analytics initiatives.
• Drive best practices for data engineering, performance optimization, security, and scalability.
• Leverage modern AI-powered development tools such as GitHub Copilot, Cursor, Claude Code, and related productivity platforms.

Mandatory Skills

Expert-level experience with AWS Cloud Services

Strong hands-on expertise in Snowflake

Deep understanding of:

• Data Warehousing
• Data Integration & CDC
• ETL/ELT Pipeline Development
• Kimball Dimensional Modeling
• Semantic/BI Layer Architecture

Strong programming skills in:

• SQL (Expert Level)
• Python
• PySpark

Experience with:

• Apache Airflow
• dbt (Data Build Tool)

Exposure to AI/ML data platforms and modern data product development

Preferred Skills

• Experience in Financial Services, Consumer Finance, Lending, or Debt Settlement domains.
• Exposure to Generative AI, RAG (Retrieval-Augmented Generation), LLMOps, or related AI technologies.
• AWS Certifications.
• SnowPro Certifications.