AWS Data Architect

Agile Ventures Pvt Ltd; United States; A distancia; USD 150.000 - 190.000; Jornada completa

Descripción de la vacante

Agile Ventures Pvt Ltd is seeking an experienced AWS Data Architect for a remote/ Alameda CA role. You will design enterprise data architecture across AWS, build data lakes, lead batch and real-time ETL/ELT pipelines, and integrate Salesforce with AWS data platforms.

You will mentor data engineering teams, optimize SQL/Python workloads, and establish Tableau-driven BI standards with security and governance in mind. US-based client-facing exposure is preferred.

Formación

• 13+ years of IT experience with data engineering & analytics, including end-to-end data solution design and architecture.
• 6+ years hands-on AWS data architecture including S3, Glue, Redshift, Athena, Lambda, EMR, Lake Formation, Kinesis, RDS.
• 3+ years integrating Salesforce (Sales Cloud / Service Cloud) with external data platforms via APIs/connectors.
• 3+ years leading data engineering teams as Tech Architect/Lead with mentoring responsibilities.
• 4+ years Tableau experience: dashboard development, data modeling, performance tuning.
• 3+ years real-time and batch data processing architectures with streaming frameworks and CI/CD.

Responsabilidades

• Design enterprise data architecture across AWS data platforms with scalability, security, and performance.
• Architect and oversee data lakes/lakehouse solutions using AWS services (S3, Glue, Redshift, Athena, EMR, Lambda, Lake Formation).
• Lead robust ETL/ELT pipelines (batch and real-time) ensuring data quality and performance.
• Integrate Salesforce with AWS data platforms.
• Define enterprise data models (dimensional modeling) to support analytics and reporting.
• Establish BI architecture standards with Tableau, including security and governance.

Conocimientos

IT strategy

AWS data architecture

Salesforce integration

Technical leadership

Tableau

Streaming & batch processing

Herramientas

Amazon S3

AWS Glue

Redshift

Athena

Lambda

EMR

Kinesis

Lake Formation

Descripción del empleo

Job Title

It will be nice but not mandatory to have below Skills

Salesforce Cloud, Tableau

Job Title: AWS Data Architect

Location Remote/ alameda CA

Job Type: W2, Contract/Full Time

Job Title

It will be nice but not mandatory to have below Skills

Salesforce Cloud, Tableau Or Pharma domain or Market access Application Experience

Primary (Must-Have) Skills

• 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.
• 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+ years of experience in integrating Salesforce (Sales Cloud / Service Cloud) with external data platforms using APIs, connectors, and middleware tools.
• 3+ years of experience in leading data engineering teams as a Technical Architect / Lead, providing architecture guidance, code reviews, design standards, and mentoring developers.
• 4+ years of hands-on experience with Tableau, including dashboard development, data modeling, performance tuning, and data visualization best practices.
• 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.