Senior AWS Data Architect: Lakehouse, ETL & Tableau Lead

TechNeptune Consulting Inc.; United States; On-site; USD 150,000 - 210,000; Full time

Job summary

TechNeptune Consulting Inc. seeks an accomplished AWS Data Architect to design, develop, and maintain scalable data pipelines and analytics solutions, including Salesforce and Tableau integrations.

You will work with business stakeholders, data teams, and CRM teams to ensure data flow, governance, and timely insights generation. The role requires leading data engineering teams, architecting enterprise data models, and guiding CI/CD, IaC, and performance optimization for a US-based client.

Qualifications

• : 13+ years IT experience with 8+ years in Data Eng & Analytics; end-to-end data solution design and enterprise data platform implementation.
• : 6+ years AWS data architecture incl. S3, Glue, Redshift, Athena, EMR, Lambda, Lake Formation, Kinesis, RDS with cloud-native patterns & SQL
• : 3+ years Salesforce integration with external data platforms via APIs/connectors
• : 3+ years leading data engineering teams as Architect/Lead with mentoring
• : 4+ years Tableau dashboard development, data modeling, and performance tuning
• : 3+ years in real-time and batch data processing architectures including streaming and CI/CD

Responsibilities

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

Skills

AWS data arch

Tableau

Salesforce integration

Python PySpark

SQL modeling

Data governance

CI/CD DevOps

ETL/ELT pipelines

Lead / mentoring

Architecture design

Tools

Terraform

CloudFormation

Kafka

Kinesis

Job description

TechNeptune Consulting Inc. seeks an accomplished AWS Data Architect to design, develop, and maintain scalable data pipelines and analytics solutions, including Salesforce and Tableau integrations.

You will work with business stakeholders, data teams, and CRM teams to ensure data flow, governance, and timely insights generation. The role requires leading data engineering teams, architecting enterprise data models, and guiding CI/CD, IaC, and performance optimization for a US-based client.