AWS Data Architect

WinWire Technologies Inc.; Alameda (CA); On-site; USD 150,000 - 190,000; Full time

Job summary

WinWire Technologies Inc. is seeking a highly skilled AWS Data Architect to design, develop, and maintain scalable data pipelines and analytics solutions in partnership with stakeholders and CRM teams.

You will lead architecture across AWS data services, integrate Salesforce with data platforms, and govern data security and governance while mentoring engineers and delivering BI-ready environments.

Qualifications

• 15+ years in IT with 8+ years in Data Engineering & Analytics.
• 8+ years in AWS data architecture (S3, Glue, Redshift, Athena, Lambda, EMR).
• 3+ years integrating Salesforce with external data platforms via APIs/connectors.
• 3+ years leading data engineering teams as architect/lead.
• 4+ years with Tableau for dashboards and data visualization.
• 3+ years in real-time and batch data processing, CI/CD experience.

Responsibilities

• Design enterprise data architecture across AWS data platforms for scalability and security.
• Architect and oversee data lakes/lakehouse using AWS services (S3, Glue, Redshift, etc.).
• Lead ETL/ELT pipelines (batch and real-time) with high data quality.
• Integrate and synchronize data between Salesforce and AWS data platforms.
• Define enterprise data models including dimensional modeling for analytics.
• Establish Tableau-based BI standards, including semantic layer and governance.
• Provide hands-on leadership in SQL, Python/PySpark, and performance tuning.
• Enforce data governance, security, IAM, encryption, and compliance.
• Guide CI/CD, IaC (Terraform/CloudFormation), and data DevOps practices.
• Review designs/code for scalability and best practices; collaborate with cross-functional teams.
• Drive modernization from on-prem to AWS; ensure monitoring, logging, and DR strategies.
• Mentor data engineers and BI developers; evaluate emerging AWS technologies.

Skills

Data engineering

AWS data architecture

Salesforce integration

Technical leadership

Tableau

Real-time processing

CI/CD

Python/PySpark

Tools

Amazon S3

AWS Glue

Redshift

Athena

EMR

Lake Formation

Kinesis

RDS

SQL

Terraform

CloudFormation

Job description

Primary (Must have skills)* - To be Screened by TA Team

1). 15+ 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 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 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 and ingestion and experience in CI/CD

Job Description of Role* (RNR) - To be Evaluated by Technical Panel (Define it to give more clarity)

Design and define enterprise-level data architecture across AWS data platforms, ensuring scalability, security, performance, and alignment with business strategy.

Architect, develop, and oversee 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.

Collaborate with cross-functional teams to gather requirements and deliver scalable solutions

Drive modernization initiatives including migration from legacy/on-prem systems to AWS cloud environments.

Ensure monitoring, logging, observability, backup, and disaster recovery strategies are implemented effectively.

Mentor and technically guide data engineers and BI developers, establishing development standards and reusable frameworks.

Continuously evaluate emerging technologies, BI trends, and AWS innovations to recommend improvements and optimize enterprise data capabilities.

Soft skills/other skills - To be Evaluated by Hiring Manager (To define how this will be evaluated)

Communication Skills:

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 in working on Agile/Scrum projects with exposure to tools like Jira

Provides regular updates, proactive and due diligent to carry out responsibilities

Expected Outcome

We are seeking a highly skilled AWS Data Architect with strong experience in Salesforce and Tableau integration to design, develop, and maintain scalable data pipelines and analytics solutions. The ideal candidate will work closely with business stakeholders, data teams, and CRM teams to ensure seamless data flow, reporting, and insights generation.

Candidate should go to customer Alameda office 4 days or as per customer expectation

Secondary Skills to be planned 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