Data Engineering Architect/ Manager

About Naveera IT Consulting Pvt Ltd

Naveera Technology LLC is a trusted global engineering partner delivering Data Engineering, Generative AI, Application Development and IT Infrastructure solutions. With over 15 years of IT services and consulting experience and a team of 400+ expert engineers, we help organizations transform raw data into deployable business value. Our approach emphasises Production over Pilots we don't stop at proof-of-concepts; we engineer systems that go live, scale reliably, and deliver measurable outcomes. With our CoE-driven delivery model, product engineering DNA, and a scalable talent acquisition engine, we align deeply with enterprise demands for performance, compliance, continuity and innovation. From Digital Health to Financial Services, E-Commerce to Technology, we serve a diverse industry base and back every engagement with proven frameworks, low-attrition teams and agile global delivery. At Naveera, we empower clients to turn challenge into growth, data into insight and concepts into platforms.

Job Title: Data Engineering Architect/ Manager Data Lakehouse

Experience: 10+ Years

Job Location: Madurai, Tamil Nadu, India

Working Mode: Remote/Hybrid

Job Type: Full-Time

Shift Timing: 2 PM to 11 PM IST Time Zone

Key Skills: AWS Data Architecture, Redshift, Snowflake, SQL, PySpark, AWS Glue, DBT, Data Warehousing, Tableau/Power BI

About the Role

We are looking for an experienced AWS Data Architect with 8+ years of experience in building scalable data platforms. The ideal candidate should have strong expertise in Data Lakehouse architecture, Data Warehousing (Redshift & Snowflake), SQL, PySpark, AWS Glue, and DBT. The role involves designing and optimizing data pipelines, data models, and data warehouse solutions to support analytics and reporting.

Key Responsibilities

• Design and implement scalable Data Lakehouse architectures on AWS


• Build and optimize data warehouse solutions using Amazon Redshift and Snowflake


• Develop and manage ETL/ELT pipelines using PySpark and AWS Glue


• Design Fact and Dimension data models for analytics workloads


• Optimize SQL queries, data distribution, and partition strategies


• Process and transform structured and semi-structured data using PySpark


• Manage data transformation workflows using DBT


• Ensure data quality, performance, and reliability across data pipelines


• Work with BI tools such as Tableau or Power BI for reporting and analytics


• Collaborate with data engineers, analysts, and business teams to deliver scalable data solutions

Required Skills

• Strong knowledge of Amazon Redshift and Snowflake data warehouse architectures


• Understanding of MPP architecture, distribution keys, and sort keys


• Experience with advanced SQL including window functions and query optimization


• Hands-on experience with PySpark and Spark SQL


• Experience handling JSON data, partitioning, and Spark transformations


• Knowledge of AWS Glue, DynamicFrame, and incremental data processing


• Experience with DBT including macros, Jinja templating, and incremental models


• Understanding of data warehouse concepts such as Fact and Dimension tables


• Experience working with Tableau or Power BI


• Familiarity with AI tools used in data workflows

Opportunity to work on large-scale cloud data transformation initiatives.

Flexible remote work model from India

Exposure to enterprise clients across the East Coast region.

Growth-oriented leadership culture.

Join Naveera Technology LLC as a Data Engineering Architect/Manager and lead innovative projects with a global team. Transform data into business value and drive impactful results.