Data Engineering Architect/Manager - Remote

Overview

The Data Engineering Architect/Manager will be responsible for designing scalable data solutions on AWS, focusing on Data Lakehouse architecture and data warehousing.

In Short

• 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.

Requirements

• 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.

Benefits

• 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.