Haystack
← Back to Jobs
Technology
AT

AWS Data Architect

Applied Thought Auditors & Consultants Inc.Santa Clara, CA🇺🇸United StatesPosted Oct 13, 2026

Why This Role Stands Out

This hybrid AWS Data Architect role offers significant opportunities to design and implement enterprise-level data solutions within a reputable consulting firm. If you are a seasoned data professional with extensive AWS and Salesforce integration experience, you will thrive in this impactful position. We encourage you to apply and advance your career in a flexible work environment.

Quick Overview

Seniority
Mid Senior
Work mode
Hybrid
Location
Santa Clara, CA, United States
Posted
21 hours ago
SQLAWSETLEncryptionScrumSnowflakeTableauAgileCloudFormationJiraKafkaPythonRedshiftTerraform

Job Description

Primary (Must-Have) Skills

  1. 13+ years of overall IT experience, with 8+ years in Data Engineering & Analytics, including end-to-end data solution design, architecture, and enterprise data platform implementation.
  2. 6+ years of hands-on experience in AWS data architecture, including Amazon S3, AWS Glue, Redshift, Athena, Lambda, EMR, Lake Formation, Kinesis, and RDS with a strong understanding of cloud-native data patterns & SQL development and advanced data modeling.
  3. 3+ years of experience in integrating Salesforce (Sales Cloud / Service Cloud) with external data platforms using APIs, connectors, and middleware tools.
  4. 3+ years of experience in leading data engineering teams as a Technical Architect / Lead, providing architecture guidance, code reviews, design standards, and mentoring developers.
  5. 4+ years of hands-on experience with Tableau, including dashboard development, data modeling, performance tuning, and data visualization best practices.
  6. 3+ years of experience in real-time and batch data processing architectures, including streaming frameworks and large-scale data ingestion, alongside experience in CI/CD.

Job Description & Responsibilities (RNR)

  • Design and define enterprise-level data architecture across AWS data platforms, ensuring scalability, security, performance, and alignment with business strategy.
  • Architect, develop, and oversee the implementation of data lakes/lakehouse solutions using AWS services such as S3, Glue, Redshift, Athena, EMR, Lambda, and Lake Formation.
  • Lead the design and development of robust ETL/ELT pipelines (batch and real-time), ensuring high data quality, reliability, and performance optimization.
  • Integrate and synchronize data between Salesforce and AWS data platforms.
  • Define and implement enterprise data models (conceptual, logical, physical), including dimensional modeling (Star/Snowflake schemas) to support analytics and reporting needs.
  • Establish BI architecture standards using Tableau, including semantic layer design, dashboard governance, security (row-level security), and performance optimization.
  • Translate complex business requirements into scalable technical architecture and actionable data solutions.
  • Provide hands-on technical leadership in SQL, Python/PySpark, query optimization, and performance tuning for large-scale datasets.
  • Define and enforce data governance, security frameworks (IAM, encryption, masking), and compliance standards across the data ecosystem.
  • Guide teams in implementing CI/CD pipelines, Infrastructure as Code (Terraform/CloudFormation), and DevOps best practices for data platforms.
  • Review solution designs and code to ensure adherence to architectural standards, scalability principles, and best practices. [1]

Soft Skills & Other Skills

Communication Skill

  • Communicate effectively with internal and customer stakeholders.
  • Communication approach: verbal, emails, and instant messages.

Interpersonal Skills

  • Collaborative mindset; comfortable working across delivery, product, and sales functions.
  • Ability to distill complex industry concepts into digestible insights for technical and non-technical audiences.
  • Self-driven, organized, and adaptive in a fast-paced environment.

Problem-Solving and Analytical Thinking

  • Capability to troubleshoot and resolve issues efficiently.
  • Analytical mindset.

Task / Work Updates

  • Prior experience working on Agile/Scrum projects with exposure to tools like Jira.
  • Provides regular updates; proactive and due diligent to carry out responsibilities.
  •  

Secondary Skills (Post-Hiring / Training Plan)

  • Experience with real-time streaming tools (Kafka, Kinesis).
  • Knowledge of data governance and compliance standards.

Prior experience in US-based client-facing roles.

Similar jobs