What are the responsibilities and job description for the AWS Data Architect (ETL with Medallion architecture) - Alameda, CA (Onsite) position at Cuboid IT Solutions?
We're Hiring | AWS Data Architect
Location: Alameda, CA (Onsite Candidate must work from Exelixis office as per client expectations)
Employment Type: Open for FTE / Contract
Experience Required: 15 Years
We are looking for a highly skilled AWS Data Architect with strong expertise in AWS Redshift, ETL/Data Engineering, Salesforce Integration, and Business Intelligence (Tableau) to lead enterprise-scale data modernization and analytics initiatives.
Key Skills Required
AWS Redshift
ETL/ELT with Medallion Architecture (Bronze, Silver, Gold Layers)
Business Intelligence & Analytics
Core Responsibilities
Design and implement enterprise-scale AWS data architectures
Build and oversee:
- Data Lakes
- Lakehouse Platforms
- Enterprise Analytics Solutions
Architect solutions using:
- Amazon S3
- AWS Glue
- Redshift
- Athena
- Lambda
- EMR
- Lake Formation
- Kinesis
- RDS
Design and optimize:
- Batch ETL/ELT Pipelines
- Real-Time Data Processing Pipelines
- Advanced Data Models
Lead Salesforce integrations using APIs, middleware, and connectors
Define and implement:
- Star Schema
- Snowflake Schema
- Enterprise Data Models
Establish Tableau BI architecture, governance, and performance standards
Drive cloud modernization and migration initiatives from legacy platforms to AWS
Implement data governance, security, compliance, monitoring, backup, and disaster recovery strategies
Mentor and guide Data Engineers and BI Developers
Required Skills
10 years of Data Engineering & Analytics experience
6 years of AWS Data Architecture experience
Strong expertise with:
- AWS Redshift
- AWS Glue
- Athena
- Lambda
- EMR
- Lake Formation
- Kinesis
- SQL
- Data Modeling
3 years of Salesforce Integration experience
4 years of Tableau Development & Architecture experience
Experience leading architecture teams and conducting design reviews
Strong experience with:
- Python / PySpark
- CI/CD
- Infrastructure as Code (Terraform / CloudFormation)
Preferred Skills
Life Sciences / Biopharma Industry Experience
Salesforce Sales Cloud / Service Cloud
Data Quality & Data Governance
Kafka or Kinesis Streaming
Client-Facing Consulting Experience
Ideal Candidate
We're looking for a hands-on Architect who can bridge business and technology, drive enterprise architecture decisions, and lead modern cloud-based analytics initiatives while collaborating with stakeholders across data, CRM, and business teams.
Interested candidates, please share:
Updated Resume
Current Location
Work Authorization
Availability
Expected Rate/Salary