Lead AWS Cloud & Data Architect

About the Company

About Incedo:

Incedo Inc. is a high-growth Digital, Data and AI Transformation Specialist firm headquartered in New Jersey. We are a long-term strategy execution partner for Fortune 500 enterprises, operating at the intersection of business and technology across Banking & Payments, Wealth Management, Telecom, Hi-Tech, and Life Sciences.

We are building Incedo 4.0 - an AI-native, execution-focused, founder-led organization designed for scale, speed, and long-term impact.

Incedo delivers ROI from AI @ Scale through the “Power of 3”:

• Deep domain expertise

• AI & Data capabilities

• Engineering & Operations excellence

Please visit the link to know about Incedo: https://www.incedoinc.com/

Lead AWS Cloud & Data Architect

Location: Remote/ Santa Clara, CA (Open to travel when required)

Experience: 10+ years overall experience, with strong hands-on AWS Cloud and Data Engineering/Architecture experience

Role Overview

We are seeking a Lead AWS Cloud & Data Architect to take end-to-end technical ownership of the AWS cloud, database, and data platform architecture and implementation .

This is a hands-on lead architect / builder role , not a purely advisory architecture position. The individual will be responsible for designing and directly contributing to the development of AWS-based databases, data models, ingestion pipelines, cloud infrastructure, security, automation, and production-ready data services.

The architect will serve as the technical lead for the AWS data platform , working closely with application developers, data engineers, DevOps engineers, security teams, and client stakeholders. The role requires someone capable of moving seamlessly from architecture and design discussions to hands-on implementation, troubleshooting, code reviews, and deployment.

Key Responsibilities

AWS Data & Database Architecture

• Own the end-to-end architecture and development of the AWS database and data platform .
• Design and implement scalable, secure, highly available AWS-native database solutions.
• Lead database design, schema development, data modeling, indexing, partitioning, and performance optimization .
• Design relational and analytical data structures based on application, reporting, and analytics requirements.
• Define database standards, naming conventions, data access patterns, archival strategies, and lifecycle management.
• Design and implement database backup, restore, high availability, and disaster recovery strategies.
• Troubleshoot database performance, connectivity, data integrity, and scalability issues.
• Provide hands-on technical leadership to developers and data engineers working on the database layer.

AWS Cloud Architecture & Engineering

Design and implement AWS-native architectures using services including:

• Amazon S3 – Data storage, data lake architecture, lifecycle management, encryption, and access controls
• Amazon RDS / Aurora – Relational database architecture, implementation, administration, and optimization
• Amazon Redshift – Data warehouse architecture and performance optimization where applicable
• AWS Glue – ETL development, Glue Jobs, Crawlers, Data Catalog, and data integration
• AWS Lambda – Event-driven processing and serverless orchestration
• Amazon API Gateway – Secure API integration
• AWS Step Functions – Workflow orchestration where applicable
• Amazon MWAA / Apache Airflow – Data pipeline orchestration and scheduling
• AWS DMS (Database Migration Service) – Database migration and replication
• AWS DataSync – Data movement and migration
• AWS Transfer Family – Secure SFTP/FTP-based data exchange
• AWS IAM – Roles, policies, least-privilege access, and service-level security
• AWS Secrets Manager / Parameter Store – Secure credential and configuration management
• Amazon CloudWatch / CloudTrail – Monitoring, logging, alerting, and auditing
• Amazon VPC – Networking, security groups, private endpoints, and secure connectivity

Data Engineering & Integration

• Architect and develop production-grade ETL/ELT pipelines on AWS .
• Design ingestion patterns for batch, file-based, API, and database sources.
• Build transformation, validation, reconciliation, and data quality frameworks.
• Develop AWS Glue/Python/SQL-based data processing solutions.
• Design reusable and metadata-driven data pipelines where appropriate.
• Implement error handling, logging, retry mechanisms, monitoring, and operational controls.
• Ensure data pipelines are scalable, maintainable, observable, and production-ready.

Database & Data Modeling

• Lead logical and physical data modeling .
• Translate business and application requirements into scalable database schemas.
• Design normalized and dimensional models based on transactional and analytical requirements.
• Develop complex SQL queries, stored procedures, views, and database objects.
• Establish primary/foreign key strategies, indexing, partitioning, and data integrity controls.
• Perform SQL/database performance tuning and query optimization.
• Review database designs and SQL developed by engineering teams.

AWS Infrastructure, Security & Automation

• Design secure AWS environments aligned with enterprise security standards.
• Implement IAM roles and policies following least-privilege principles .
• Ensure encryption of data at rest and in transit using AWS-native capabilities.
• Support VPC, subnet, security group, endpoint, and network architecture decisions.
• Implement infrastructure using Infrastructure as Code (Terraform preferred) .
• Define deployment patterns across Development, Test, Non-Production, and Production environments.
• Design backup, restore, disaster recovery, and business continuity mechanisms.
• Support AWS security reviews and remediation activities.

Migration & Modernization

• Lead database and data migration initiatives into AWS.
• Assess source systems and define migration approaches and target AWS architectures.
• Use AWS DMS, DataSync, Transfer Family, Glue, S3, and related AWS services for migration and integration.
• Define data reconciliation and validation strategies.
• Support migration cutover, rollback planning, and post-migration stabilization.
• Identify opportunities to modernize legacy workloads using AWS-native and serverless capabilities.

Technical Leadership & Ownership

• Serve as the technical lead and primary AWS architecture authority for the project.
• Own architecture decisions for the AWS cloud and data/database platform.
• Lead architecture and technical design discussions with client and internal stakeholders.
• Convert business and application requirements into implementable AWS solutions.
• Mentor developers and data engineers and provide hands-on technical guidance.
• Conduct architecture, database, SQL, pipeline, infrastructure, and code reviews.
• Establish AWS engineering standards, reusable patterns, and development best practices.
• Troubleshoot complex technical issues across AWS infrastructure, databases, and data pipelines.
• Take ownership of technical issues through resolution rather than limiting involvement to recommendations.

Required Skills & Qualifications

• 10+ years of experience in Cloud, Data Engineering, Database Engineering, or Solution Architecture roles.
• Strong hands-on experience designing and implementing solutions specifically on AWS .
• Deep experience with AWS database and data services , particularly RDS/Aurora, S3, Glue, and AWS DMS.
• Strong relational database architecture and development experience.
• Advanced SQL skills including database design and performance tuning.
• Strong understanding of logical, physical, and dimensional data modeling.
• Hands-on experience building AWS Glue-based ETL/ELT pipelines .
• Experience with AWS DMS for database migration and replication.
• Experience with Apache Airflow / Amazon MWAA .
• Strong understanding of AWS IAM, networking, security, encryption, and Secrets Manager.
• Hands-on experience with Terraform or equivalent Infrastructure as Code .
• Experience implementing AWS monitoring and logging using CloudWatch and CloudTrail.
• Strong understanding of backup, recovery, high availability, and disaster recovery concepts.
• Ability to independently troubleshoot AWS infrastructure, database, pipeline, and performance issues.
• Strong client-facing communication and stakeholder-management capabilities.

Preferred Qualifications

• AWS Certified Solutions Architect – Professional or Associate certification
• AWS Data Engineer or Database-related AWS certification
• Experience building enterprise-scale AWS data platforms
• Experience supporting React/web applications through AWS-hosted backend/database services
• Experience with regulated enterprise environments and strong security/compliance requirements
• Experience supporting analytics and BI applications
• Experience with CI/CD and automated AWS deployments

Ideal Candidate Profile

The ideal candidate is someone who can:

Architect it → Build it → Deploy it → Troubleshoot it → Lead the team supporting it.

We are specifically looking for an architect who remains hands-on with AWS, databases, SQL, data pipelines, and infrastructure and is comfortable owning technical delivery.

The candidate should demonstrate:

• Strong ownership and accountability
• Hands-on builder mindset
• AWS-first architectural thinking
• Deep database and data engineering expertise
• Ability to lead engineers while still contributing technically
• Strong troubleshooting and problem-solving skills
• Clear client-facing technical communication
• Ability to make architecture decisions and drive them through implementation

Success Measures

Success in this role will be measured by:

• Delivery of a stable and scalable AWS database and data platform
• Quality and performance of database architecture and data models
• Reliable AWS-based data ingestion and processing pipelines
• Successful AWS/database migration and modernization initiatives
• Security, reliability, observability, and recoverability of the AWS platform
• Effective technical leadership of developers and data engineers
• Reduction of production issues through strong architecture and engineering standards
• Ability to independently own AWS technical delivery from design through production