NEWPosted 3 hours ago
Job ID: JOB_ID_5971
About the Role:
We are seeking a highly skilled AWS Data Architect with extensive experience in Salesforce and Tableau integration to design, develop, and maintain scalable data pipelines and analytics solutions. This role is crucial for ensuring seamless data flow, reporting, and insights generation by working closely with business stakeholders, data teams, and CRM teams.
The ideal candidate will be responsible for architecting and implementing enterprise-level data solutions on AWS, ensuring scalability, security, and performance.
Key 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 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.
- 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.
Key Skills:
- AWS (S3, Glue, Redshift, Athena, Lambda, EMR, Lake Formation, Kinesis, RDS)
- Data Engineering & Analytics
- Data Solution Design & Architecture
- Enterprise Data Platform Implementation
- Salesforce Integration (Sales Cloud / Service Cloud)
- Tableau (Dashboard Development, Data Modeling, Performance Tuning, Data Visualization)
- ETL/ELT Pipelines (Batch and Real-time)
- SQL and advanced data modeling
- Python/PySpark
- CI/CD and Infrastructure as Code (Terraform/CloudFormation)
- DevOps best practices
- Agile/Scrum methodologies
Experience:
- 15+ Years of overall IT experience
- 8+ Years in Data Engineering & Analytics
- 6+ Years of hands-on experience in AWS data architecture
- 3+ Years of experience in integrating Salesforce with external data platforms
- 3+ Years of experience in leading data engineering teams as Technical Architect / Lead
- 4+ Years of hands-on experience with Tableau
- 3+ Years of experience in real-time and batch data processing architectures
Secondary Skills (Training Plan Post Hiring):
- Experience with real-time streaming tools (Kafka, Kinesis)
- Knowledge of data governance and compliance standards
- Prior experience in US-based client-facing roles
Special Requirements
Onsite must. Open for FTE/Contract.
Compensation & Location
Salary: $150,000 – $180,000 per year
Location: Alameda, CA
Recruiter / Company – Contact Information
Email: esh.s@saxonglobal.com
Recruiter Notice:
To remove this job posting, please send an email from
esh.s@saxonglobal.com with the subject:
DELETE_JOB_ID_5971