Data Architect

Straive; Bengaluru; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Straive is seeking a seasoned Data Architect to define and lead the end-to-end data architecture strategy. You will design complex data models for high-performance analytics and build scalable Lakehouse environments across Bronze/Silver/Gold layers to ensure quality and lineage.

You will collaborate with data engineers, consultants, and stakeholders to translate business logic into robust technical blueprints, while driving governance, metadata, and MDM standards across the enterprise.

Qualifications

• 7+ years in Data Architecture or Senior Data Engineering in analytics-heavy environments.
• Expert in logical/physical data modeling (3NF, Star/Snowflake, Data Vault 2.0).
• Proven reverse engineering to modernize legacy schemas.
• Proficient with modeling tools such as ER/Studio, Erwin Data Modeler, Lucidchart.
• Hands-on with cloud/big data on Azure (Fabric/Synapse) and AWS/Snowflake ecosystems.

Responsibilities

• Define and lead end-to-end data architecture strategy for analytics.
• Design and implement conceptual, logical, and physical data models for high-performance analytics.
• Architect scalable Lakehouse with Bronze/Silver/Gold patterns for data quality and lineage.
• Establish enterprise data standards, metadata, security, and MDM governance.
• Partner with Data Science teams to optimize for LLMs, vector DBs, and RAG pipelines.
• Lead cross-functional collaboration to translate business logic into technical blueprints.

Skills

Data architecture

Data modeling

Reverse engineering

Cloud & big data

Vector databases

SQL/NoSQL proficiency

Tools

ER/Studio

Erwin Data Modeler

Lucidchart

Azure Synapse

Snowflake

Redshift/Glue

Job description

Role & responsibilities

• Architectural Strategy: Define and lead the end-to-end data architecture strategy, ensuring alignment with long-term business goals and advanced analytics requirements.


• Strategic Data Design: Design and implement complex conceptual, logical, and physical data models optimized for high-performance analytics and reporting.


• Medallion Architecture: Architect scalable Lakehouse environments using Bronze, Silver, and Gold layer patterns to ensure data quality and lineage.


• Governance & Standards: Establish enterprise-wide data standards, including metadata management, data security protocols, and master data management (MDM).


• AI Readiness: Partner with Data Science teams to ensure data architectures are optimized for LLM integration, Vector databases, and RAG pipelines.


• Cross-Functional Leadership: Orchestrate collaboration between data engineers, business consultants, and stakeholders to translate business logic into technical blueprints.

Preferred candidate profile

• Professional Experience: Minimum 7+ years in Data Architecture or Senior Data Engineering within an Analytics-heavy environment.


• Data Modeling Mastery: Extensive experience in Logical and Physical data modeling techniques, including 3NF, Dimensional Modeling (Star/Snowflake), and Data Vault 2.0.


• Reverse Engineering: Proven expertise in Reverse Engineering techniques to document and modernize legacy database schemas into optimized target architectures.


• Modeling Stacks: Expert proficiency in industry-standard tools such as ER/Studio, Erwin Data Modeler, or Lucidchart for designing relational and non-relational structures.


• Cloud & Big Data: Hands-on experience architecting solutions on Azure (Fabric/Synapse), AWS

(Redshift/Glue), or Snowflake, utilizing Delta Lake and Spark-based processing.

• Advanced Database Systems: Deep knowledge of SQL (PostgreSQL, SQL Server) and NoSQL systems,

along with Vector Databases (Pinecone, Milvus) for AI-driven applications.