Enterprise AWS Data architect

EROS Technologies Inc; Alameda (CA); On-site; USD 140,000 - 200,000; Full time

Job summary

EROS Technologies Inc in Alameda, CA is seeking an experienced Enterprise Data Architect to design and govern scalable AWS data platforms that align with business strategy.

You will lead the architecture and implementation of data lakes/lakehouse solutions using AWS services, oversee robust ETL/ELT pipelines, and define enterprise data models to support analytics and reporting. The role also includes BI standards with Tableau, security, and CI/CD across data ecosystems.

Qualifications

• Experience designing enterprise data architectures on AWS.
• Knowledge of data lakes/lakehouses and orchestration.
• Ability to design dimensional models (Star/Snowflake).
• Experience building robust ETL/ELT pipelines (batch and real-time).
• Strong SQL and Python/PySpark proficiencies.

Responsibilities

• Architect and oversee implementation of data lakes/lakehouse solutions on AWS.
• Lead design of ETL/ELT pipelines for high quality, reliable data.
• Define enterprise data models and BI architecture standards with Tableau governance.
• Mentor data engineers and BI developers; drive coding and architecture standards.
• Ensure data governance, security, and CI/CD practices across data platforms.

Skills

SQL

Python

PySpark

Data modeling

ETL/ELT

AWS

Tableau

CI/CD

Terraform

CloudFormation

Jira

Data governance

Security IAM

Tools

S3

Glue

Redshift

Athena

EMR

Lake Formation

Tableau

Terraform

CloudFormation

Job description

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.

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