AWS Data Architect ||

Aroha Technologies, Inc; Alameda (CA); Vor Ort; USD 140.000 - 190.000; Vollzeit

Zusammenfassung

Aroha Technologies, Inc. seeks an AWS Data Architect in Alameda, CA to design scalable data pipelines and analytics solutions. You will architect data lakes, lead ETL/ELT development, and ensure secure data flow between Salesforce and AWS services.

With 13–20 years in IT and 8+ years in data engineering, you will guide teams, implement CI/CD for data platforms, and mentor engineers while optimizing Tableau dashboards and data models for business insights.

Qualifikationen

• 15+ years of IT experience, with 8+ years in Data Engineering & Analytics and enterprise data platform implementation.
• 6+ years hands-on AWS data architecture experience (S3, Glue, Redshift, Athena, Lambda, EMR, Lake Formation).
• 3+ years integrating Salesforce with external data platforms via APIs/connectors.
• 4+ years Tableau experience: dashboards, data modeling, performance tuning.

Aufgaben

• Design enterprise data architecture across AWS, ensuring scalability, security, and performance.
• Develop data lakes/lakehouse solutions using AWS services (S3, Glue, Redshift, Athena, EMR, Lambda, Lake Formation).
• Lead robust ETL/ELT pipelines (batch and real-time) with high data quality.
• Integrate Salesforce data with AWS platforms and define enterprise data models (Star/Snowflake).
• Establish BI architecture standards in Tableau with semantic layer, governance, and security.
• Provide hands-on leadership in SQL, Python/PySpark, and optimization for large data sets.
• Define data governance, security, and compliance across the data ecosystem.

Kenntnisse

AWS Data Architecture

SQL Development

Python PySpark

ETL Pipelines

Data Modeling

Data Governance

Security & Compliance

Leadership

Tableau BI

CI/CD

Agile/Scrum

Communication

Ausbildung

Bachelor's Degree

Tools

AWS S3

AWS Glue

Redshift

Athena

EMR

Lambda

Lake Formation

Kinesis

Terraform

CloudFormation

Jira

Jobbeschreibung

Job Title

AWS Data Architect

Location

Alameda, CA

Duration

Full-Time (FTE)

Experience

13 20 Years

Job Description

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.

Primary Responsibilities

• 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, 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.
• 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, 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.
• Drive modernization initiatives, including migration from legacy/on‑prem systems to AWS cloud environments.
• Mentor and technically guide data engineers and BI developers, establishing development standards and reusable frameworks.

Required Skills & Experience

• 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.
• 6+ years of hands‑on experience in AWS data architecture, including Amazon S3, AWS Glue, Redshift, Athena, Lambda, EMR, Lake Formation, Kinesis, and RDS.
• 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 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, and experience in CI/CD.
• Strong understanding of cloud‑native data patterns, SQL development, and advanced data modeling.
• Any Bachelor's Degree.

Secondary Skills

• Experience with real‑time streaming tools (Kafka, Kinesis).
• Knowledge of data governance and compliance standards.
• Prior experience in US‑based client-facing roles.

Soft Skills

• Communicate effectively with internal and customer stakeholders.
• 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.
• Prior experience in working on Agile/Scrum projects with exposure to tools like Jira.