Data Solution Architect

a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; }

Data Architect - Movate

Role: Data Architect
Experience: 10+ Years
Employment Type: Full-Time
Location: Chennai / Bangalore / Pune (Hybrid)

About Movate

Movate (formerly CSS Corp) is a digital technology and customer experience services company that helps organizations accelerate business transformation through innovative technology solutions. With over 11,500 professionals across 20 global locations, Movate partners with leading enterprises worldwide to deliver digital transformation, cloud, data, AI, and customer support solutions.

Job Summary

Movate is looking for an experienced Data Architect to drive large-scale data modernization and cloud data warehouse transformation initiatives. The ideal candidate will lead the design of enterprise data architectures, assess existing SAP HANA environments, and architect scalable, secure, and high-performing Snowflake-based data platforms.

This role will be responsible for defining future-state architecture, data governance standards, cloud data warehousing strategies, Medallion Architecture, and AI-ready data foundations while ensuring optimal performance, scalability, security, and cost efficiency.

Key Responsibilities

Data Architecture & Modernization

• Assess and analyze existing SAP HANA landscapes, including Calculation Views, Stored Procedures, ETL processes, and reporting frameworks.
• Define target-state architecture and migration strategies from SAP HANA and other legacy platforms to Snowflake.
• Design enterprise-scale Snowflake data warehouse solutions aligned with business and technology objectives.
• Create scalable, secure, and high-performance cloud-native data architectures.
• Develop modern Data Lakehouse and Data Warehouse architectures.

Data Modeling & Governance

• Design and implement enterprise data models using:

• Kimball Methodology

• Inmon Methodology

• Data Vault 2.0

• Implement Medallion Architecture (Bronze, Silver, Gold layers).

• Establish enterprise data governance, metadata management, data lineage, and data quality frameworks.

• Define security, compliance, and regulatory standards across the data ecosystem.

• Implement role-based access controls (RBAC) and data security best practices.

Snowflake Architecture

• Design Snowflake architecture, including:

• Virtual Warehouses

• Storage & Compute Strategy

• Snowpipe

• Data Sharing

• Time Travel & Fail-safe

• Clustering Keys

• Query Performance Optimization

• Drive platform performance tuning, workload management, and cost optimization initiatives.

• Define standards and reusable design patterns for enterprise-wide adoption.

Data Engineering & Transformation

• Lead the design of ELT/ETL frameworks and data integration strategies.
• Utilize dbt for transformation, testing, deployment automation, and data lineage management.
• Establish scalable data ingestion, transformation, and consumption frameworks.
• Support legacy system reverse engineering and modernization programs.

AI & Advanced Analytics

• Design AI-ready data platforms supporting advanced analytics and machine learning.
• Enable LLM integration, Prompt Engineering, and Generative AI use cases.
• Architect data pipelines for AI/ML workloads.
• Collaborate with analytics and AI teams on enterprise AI initiatives.

Leadership & Collaboration

• Lead architecture review boards, design workshops, and governance discussions.
• Mentor engineering teams on modern data architecture practices.
• Collaborate with business stakeholders, architects, engineers, and analytics teams.
• Provide technical leadership and strategic direction for enterprise data programs.

Required Skills

Snowflake

• Snowflake Architecture
• Virtual Warehouses
• Snowpipe
• Clustering Keys
• Query Performance Optimization
• Snowflake Security & Governance
• Data Sharing
• Time Travel & Fail-safe

Data Architecture & Modeling

• Enterprise Data Architecture
• Dimensional Modeling
• Inmon Methodology
• Kimball Methodology
• Data Vault 2.0
• Data Warehouse Design
• Data Lakehouse Architecture
• Medallion Architecture

Cloud & Governance

• Cloud Security Governance
• Data Governance Frameworks
• Data Quality Management
• Metadata Management
• Master Data Management (MDM)
• Data Lineage
• Compliance & Regulatory Controls

Data Engineering

• dbt (Data Build Tool)
• ETL / ELT Frameworks
• Data Integration
• SQL Development
• Data Migration & Modernization
• Reverse Engineering of Legacy Systems

AI & Advanced Analytics

• LLM Integration
• Prompt Engineering
• AI/ML Data Architecture
• Generative AI Data Pipelines

Mandatory Qualifications

• 10+ years of experience in Data Architecture and Data Engineering.
• Hands-on experience delivering at least two enterprise-scale Snowflake implementations.
• Strong expertise in Snowflake architecture and cloud-native data platforms.
• Proven experience with Kimball, Inmon, and Data Vault 2.0 modeling methodologies.
• Hands-on implementation experience with Medallion Architecture.
• Strong understanding of cloud security, governance, and compliance frameworks.
• Experience with dbt and modern ELT practices.
• Exposure to AI, LLM Integration, and Prompt Engineering use cases.
• Excellent stakeholder management, solution design, and architecture governance experience.

Preferred Qualifications

• Experience with SAP HANA migration and modernization programs.
• Snowflake certifications.
• Experience with Azure, AWS, or GCP cloud platforms.
• Knowledge of DataOps, CI/CD, and modern analytics ecosystems.
• Experience designing AI-ready enterprise data platforms.

Nice-to-Have Skills

• Databricks
• Apache Spark
• Kafka
• Azure Data Factory (ADF)
• AWS Glue
• Power BI
• Tableau
• MLOps Frameworks
• Vector Databases
• Retrieval-Augmented Generation (RAG) Architecture

Key Competencies

• Enterprise Architecture
• Strategic Thinking
• Stakeholder Management
• Solution Design
• Technical Leadership
• Problem Solving
• Communication Skills
• Mentoring & Team Leadership