Why This Role Stands Out
This hybrid AWS Data Architect role offers significant opportunities to design and implement enterprise-level data solutions within a reputable consulting firm. If you are a seasoned data professional with extensive AWS and Salesforce integration experience, you will thrive in this impactful position. We encourage you to apply and advance your career in a flexible work environment.
Quick Overview
Job Description
Primary (Must-Have) Skills
- 13+ 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 with a strong understanding of cloud-native data patterns & SQL development and advanced data modeling.
- 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 a 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, alongside experience in CI/CD.
Job Description & Responsibilities (RNR)
- 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. [1]
Soft Skills & Other Skills
Communication Skill
- 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 working on Agile/Scrum projects with exposure to tools like Jira.
- Provides regular updates; proactive and due diligent to carry out responsibilities.
Secondary Skills (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.
Similar jobs
- JT
Snowflake Data Architect
NewJBS Technologies
United States🇺🇸Hybrid21 hours agoMachine LearningSnowflakeTechnology - NT
Data Architect - Securities Services
NewNorthern Trust
Chicago, IL🇺🇸$137.4k - $233.6k/yrHybrid21 hours agoAzureDatabricksKafkaTechnology - II
Data Solution Architect
NewIcon International Group LLC
Houston, TX🇺🇸On-site21 hours agoAWSDatabricksRedshiftTechnology - ZT
Data/Information Architect
NewZolon Tech Solutions Inc
Columbia, SC🇺🇸On-site21 hours agoSQLSQL ServerAgile+2 - TR
Data Architect -- W2 Profiles -- Onsite
NewTrebecon LLC
New York, NY🇺🇸On-site21 hours agoSQLAWSETL+7Technology - TR
Data Architect (AI & Data Pod ) -- Hybrid -- Only W2
NewTrebecon LLC
New York, NY🇺🇸On-site21 hours agoSQLAWSSnowflake+4Technology - ME
(Only W2) Data Architect - Remote
NewMetaSense, Inc.
United States🇺🇸Remote21 hours agoOraclePL/SQLSQL+8Technology - RT
Data Governance Lead
NewRICEFW Technologies Inc
Augusta, ME🇺🇸Hybrid21 hours agoComplianceData PrivacyRegulatory Compliance - AD
Data/Information Architect
NewAdientOne LLC
Columbia, SC🇺🇸Hybrid21 hours agoSQLSQL ServerAgile+9 - IA
Data Platform Architect
NewIntento Analytics LLC
United States🇺🇸Remote21 hours agoOracleSQLSQL Server+11 - NS
Data/Information Architect
NewNovaLink Solutions
Columbia, SC🇺🇸Hybrid21 hours agoSQLAgileJava+2 - SS
Data solution architect
NewSDH Systems
GA🇺🇸On-site21 hours agoSQLAWSMLOps+3Technology