Data Architect

Location: Bengaluru

Role
- Data Modeler Architect
Location - Bangalore/Chennai/Hyderabad/Gurgaon/Noida
Work Mode
- Hybrid

About Straive
Straive is a trusted leader in building and operationalizing enterprise data and AI solutions for top global brands and corporations. Our key differentiators include extensive domain expertise across multiple industry verticals, coupled with cutting-edge data analytics and AI capabilities that have consistently driven measurable ROI for our clients. With a global footprint spanning 30+ countries, Straive serves hundreds of clients, supported by a team of 18,000+ seasoned professionals in data, analytics, AI, and operations.

Our offices are strategically located across India, the Philippines, the USA, Nicaragua, Vietnam, the UK, Canada, and Singapore, where our headquarters are based.
Job Overview
As a  Data Architect  at Straive, you will be the primary designer of high-performance data ecosystems that transform raw information into AI-ready assets. This role is focused on building sophisticated, scalable data models and structural blueprints that support advanced analytics, predictive modeling, and the integration of Generative AI. You will work as a strategic technical leader, bridging the gap between complex business requirements and robust engineering execution to drive measurable ROI for our global clients.
Key   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.

Technical Expertise
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 (Postgre

SQL, SQL Server) and No

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