Data Architect
ExternalPrepare for this interview
EliteAI-generated questions, company research, and talking points tailored to this role
Benefits
Additional Information
Job Summary Are you passionate about innovation that transforms everyday products into extraordinary experiences? IFF is a global leader in flavors, fragrances, food ingredients and health & biosciences, we deliver sustainable innovations that elevate everyday products. Digital Technology Solutions: Accelerating innovation through data, technology and digital transformation, building intelligent solutions that enhance experiences and power smarter decisions. The role is based in Chennai, India (Hybrid role). Be part of a motivated, passionate, and open-minded team where together we can achieve greatness and make a real impact. Your potential is our inspiration. Where You'll Make a Difference Define and own the end-to-end data architecture - from source systems through ingestion, storage, transformation, and consumption. Develop conceptual, logical, and physical data models for enterprise domains (Finance, Supply Chain, Commercial, R&D, HR). Establish and enforce data modelling standards, naming conventions, and design patterns across teams. Architect data integration pipelines connecting SAP, Oracle ERP, Salesforce, Workday, and other enterprise applications to the cloud data platform. Design and optimize the Cloud Data Warehouse (Snowflake / Redshift / Synapse) including layered architecture (Bronze / Silver / Gold), partitioning, clustering, and cost optimization. Lead the design of DBT models, transformations, and data products with strong CI/CD and testing practices. Define data quality, master data, metadata, and lineage frameworks; partner with Data Governance to operationalize them. Collaborate with InfoSec and Compliance on data classification, masking, access controls, and regulatory requirements (GDPR, CCPA, SOX). Develop and maintain architecture artifacts - reference architectures, data flow diagrams, ER models, technology roadmaps. What Makes You the Right Fit Bachelor's or Master's degree in Computer Science, Information Systems, Engineering or any other related discipline. Minimum 10+ years of progressive experience in data engineering, data warehousing, or data architecture roles. 3+ years in a senior or lead architect capacity owning enterprise-scale data initiatives. Demonstrated experience delivering at least one end-to-end modernization from legacy on-prem to cloud data platform. Deep expertise in conceptual, logical, and physical data modelling - dimensional (Kimball), 3NF, Data Vault, and hybrid approaches. Hands-on proficiency with data modelling tools such as erwin Data Modeler, SAP Power Designer, ER/Studio, or equivalent. Strong understanding of enterprise data architecture patterns - Medallion architecture, lakehouse, data mesh, hub-and-spoke. Experience designing semantic / analytical layers for BI tools: Power BI, Tableau, Qlik Sense / QlikView. Understanding of self-service analytics enablement, certified datasets, and report governance. How Would You Stand Out? Experience with AI/ML data pipelines and feature stores supporting GenAI and predictive analytics use cases. Familiarity with Python or PySpark for data engineering workflows. Exposure to streaming platforms (Kafka, Kinesis, Snowflake Streams & Tasks). Why Choose Us? Multinational and supporting environment Health insurance Training opportunities Learning and development programs We are a global leader in taste, scent, and nutrition, offering our customers a broader range of natural solutions and accelerating our growth strategy. At IFF, we believe that your uniqueness unleashes our potential. We value the diverse mosaic of the ethnicity, national origin, race, age, sex, or veteran status. We strive for an inclusive workplace that allows each of our colleagues to bring their authentic self to work regardless of their religion, gender identity & expression, sexual orientation, or disability. Visit IFF.com/careers/workplace-diversity-and-inclusion to learn more
Your Match
How well this role fits your profile.
Company Intel
What employees say
Worked at IFF? Share your experience