AWS Data Architect - SQL/ETL

Job Title : Data Architect AWS.

Location : PAN India (Remote).

Experience : 10 15 Years.

Job Summary :

We are seeking an experienced AWS Data Architect to design and implement scalable, enterprise-grade data solutions.

The ideal candidate will have expertise in enterprise AWS data architecture, data modeling, and database design, with hands-on experience using ER tools and SQL.

Roles & Responsibilities :

- Design and implement enterprise-level AWS Data Architecture solutions.

- Develop conceptual, logical, and physical data models to support business requirements.

- Work with ER Diagrams, ER Studio, and Enterprise Architect (EA) to document and manage data models.

- Collaborate with stakeholders to define data strategy, standards, and governance frameworks.

- Optimize database structures and data pipelines for scalability and performance.

- Ensure data solutions align with business goals, security, and compliance requirements.

- Provide technical leadership and guidance to development and data engineering teams.

Required Skills :

- Strong expertise in AWS Data Services (Redshift, S3, Glue, Athena, Lake Formation, RDS, DynamoDB, etc.

- Solid experience in enterprise data modeling and data architecture design.

- Proficiency in SQL and database optimization techniques.

- Experience creating and managing ER Diagrams using ER Studio / EA tools.

- Knowledge of ETL/ELT pipelines and integration with enterprise systems.

- Strong understanding of data governance, security, and compliance.

Good To Have :

- Experience in Big Data frameworks (Spark, Hadoop).

- Knowledge of Snowflake, Databricks, or other cloud data platforms.

- Exposure to API-based data integration and microservices architecture.

Soft Skills :

- Excellent communication and stakeholder management skills.

- Strong problem-solving and analytical mindset.

- Ability to work independently in a remote environment.