Senior Data Architect: AWS, Snowflake & AI Platforms

Aspire Talent Innovations; United States; Remote; USD 150,000 - 210,000; Full time

Job summary

Aspire Talent Innovations seeks a senior Data Architect to own the end-to-end data platform—from source systems and CDC through the data lake and Snowflake warehouse to dimensional and semantic models, the BI layer, and emerging AI products.

This role is hands-on and high autonomy, requiring architectural leadership, coding, and governance, with collaboration across CloudOps/DevOps and analytics teams to deliver scalable, compliant data solutions.

Qualifications

• 12–17 years of data engineering/architecture experience with production systems.
• Expert-level SQL, Python, and PySpark able to write, review and debug production code.
• Hands-on AWS and Snowflake architecture with data lifecycle expertise.
• Strong communication and ability to translate requirements into resilient architecture.

Responsibilities

• Design end-to-end data architecture across AWS and Snowflake from raw to curated zones.
• Define standards for data integration, orchestration (Airflow), and warehousing.
• Own data modelling using Data Vault and dimensional models for BI/AI use cases.
• Architect reliable batch and CDC data pipelines; ensure governance and testing.
• Design the semantic layer for Power BI and guide analytics engineers.

Skills

Experience 12-17 years

SQL

Python

PySpark

Data governance

Strong communication

Tools

AWS

Snowflake

Airflow

dbt

AI/LLM tooling

Job description

Aspire Talent Innovations seeks a senior Data Architect to own the end-to-end data platform—from source systems and CDC through the data lake and Snowflake warehouse to dimensional and semantic models, the BI layer, and emerging AI products.

This role is hands-on and high autonomy, requiring architectural leadership, coding, and governance, with collaboration across CloudOps/DevOps and analytics teams to deliver scalable, compliant data solutions.