Data Architect
Indhu MRemoteSENIORPosted 2h ago
SnowflakeDBT (Data Build Tool)Advanced SQL ProgrammingETL Pipeline DevelopmentData Ingestion FrameworksData Modeling (Star Schema / Dimensional Modeling)Unix Shell ScriptingJob Scheduling Tools – Control-M / Autosys / CronData Lineage & ETL Flow AnalysisDeployment & Unit Testing
About the Role
We are looking for an experienced Data Architect with strong technical expertise in Snowflake, DBT, SQL, ETL pipeline development, and enterprise data modeling. This role focuses on designing scalable data pipelines and managing data lineage across complex data environments.
Key Responsibilities
• Design and develop scalable ETL pipelines and data ingestion frameworks using Snowflake, DBT, and SQL
• Build and optimize data transformation workflows across heterogeneous data sources
• Develop enterprise-level data models, including Star Schema and Dimensional Modeling
• Work with distributed systems and computing environments
• Analyze ETL workflows and capture, document, and maintain data lineage
• Develop and maintain Unix shell scripts for data processing and automation
• Manage job scheduling and workflow orchestration using Control-M, Autosys, or Cron
• Perform SQL query optimization and database development using Snowflake
• Validate, deploy, and test data pipeline components
• Perform unit testing and ensure data quality, accuracy, and reliability
• Collaborate with technical teams to deliver scalable and efficient data solutions
Requirements
• 8+ years of experience in Data Engineering / Data Architecture
• Strong hands-on experience with Snowflake and DBT
• Excellent SQL programming and ETL development skills
• Experience working with multiple data sources and enterprise data environments
• Strong understanding of data modeling, data lineage, and ETL architecture
• Excellent problem-solving and communication skills
• Immediate joiners preferred