Job Description
<p><p><b>Location </b>: Pune / Bangalore.<br/><br/> Work Mode : Hybrid (3 days WFO, 2 days WFH).<br/><br/><b> Shift : </b>UK hours (9 AM 5 PM GMT).<br/><br/><b> Experience : </b>10+ years (Level 3).</p><p><br/><b>About the Role :</b><br/><br/> We are seeking an experienced Data Modeler / Data Architect to join our team in the Asset Management / Security Servicing space.<br/><br/> You will play a key role in building and managing data models (conceptual, logical, physical) and ensuring trusted, high-quality, business-aligned data solutions on Snowflake and Azure platforms.</p><p><br/><b>Key Responsibilities :</b><br/><br/> - Create and manage conceptual, logical & physical data models across multiple domains (accounts, holdings, transactions).<br/><br/> - Design and optimize Snowflake data solutions (clustering, partitioning, schema best practices).<br/><br/> - Drive data architecture & governance, ensuring data is trusted, understood, and easy to use.<br/><br/> - Collaborate with Data Product Owners, engineers, and business stakeholders to deliver scalable solutions.<br/><br/> - Document and present architecture/design decisions, ensuring alignment with enterprise standards.</p><p><br/><b>Must-Have Skills :</b><br/><br/> - 10+ years in Enterprise Data Architecture, Data Modelling, Database Engineering.<br/><br/> - Strong expertise in OLTP/OLAP design, Data Warehouse, ELT/ETL processes.<br/><br/> - Proven experience in Snowflake (data sharing, streams, tasks, schema design).<br/><br/> - Proficiency with Enterprise Modelling tools (Erwin, PowerDesigner, IBM Infosphere).<br/><br/> - Hands-on with Azure Data Factory, Synapse, Databricks, Cosmos DB.<br/><br/> - Excellent SQL skills (performance tuning, query optimization, indexing).<br/><br/> - Knowledge of ontology & taxonomy design and regulatory/financial data standards (BIAN, ACORD, ESG).<br/><br/> - Strong communication skills with ability to work across tech & business teams.</p><p><br/><b>Nice to Have :</b><br/><br/> - 3+ years in security servicing / asset management / investment domain.<br/><br/> - Familiarity with MDM, data vault, information architecture frameworks.<br/><br/> - Exposure to Python / R for data analysis.<br/><br/> - Strong presentation skills (architecture diagrams, stakeholder discussions).</p><p><br/><b>Company Profile :</b><br/><br/> Creospan is a subsidiary of Creospan Inc.
, headquartered in Chicago, IL.<br/><br/> Since our inception in 1999, we have grown into a leading technology consulting and solutions provider, serving clients across Telecom, Technology, Manufacturing, Ecommerce, Insurance, Banking, Transportation, and Healthcare industries.<br/><br/> Our team specializes in emerging technologies, helping clients build next-generation products that drive innovation.<br/></p><br/></p> (ref:hirist.tech)