Semantic Modeling Architect - Atscale

Tiger Analytics is one of the fastest-growing AI services firms, partnering with some of the world's largest and most influential organizations to redefine how business gets done. We help Fortune 500 companies harness the power of Artificial Intelligence, Generative AI, Data Science, Data Engineering and Advanced Analytics to solve their most complex challenges, unlock new growth opportunities, and create lasting business impact.

We are at the forefront of the AI revolution, helping enterprises move beyond traditional analytics to embrace Generative AI, agentic AI, intelligent automation, and cloud-native data platforms. A global presence across North America, Latin America, Europe, and India.

We are looking for a AtScale Semantic Modeling Architect with 10+ years of experience in enterprise data architecture and financial services. The role will focus on designing, developing, and governing enterprise semantic models using AtScale and SML on Snowflake. The ideal candidate will have strong hands-on experience with AtScale Semantic Layer, SML, Snowflake architecture, semantic modeling, enterprise BI, and banking/financial data.

• →Design and develop enterprise semantic models using AtScale and SML, including reusable dimensions, hierarchies, measures, metrics, and business definitions.
• →Architect and implement AtScale semantic models on Snowflake, leveraging Snowflake's cloud data platform for scalable enterprise analytics.
• →Translate complex business requirements into standardized enterprise metrics, KPIs, dimensions, and semantic definitions, ensuring consistency across business and reporting functions.
• →Apply dimensional/Kimball modeling principles to create scalable and reusable semantic models supporting multiple business domains.
• →Design and optimize Snowflake data models, SQL workloads, and AtScale aggregates to deliver high-performance analytical queries and BI workloads.
• →Develop and maintain SML-based semantic definitions, including measures, dimensions, hierarchies, relationships, calculations, and business logic.
• →Implement enterprise data security using Snowflake security capabilities, including Row Access Policies, masking policies, role-based access control (RBAC), and Column-Level Security (CLS).
• →Integrate and enable governed semantic models for enterprise BI and analytics platforms including Power BI, Tableau, Excel, and other reporting tools.
• →Support AI/ML and GenAI use cases through governed semantic metrics and APIs.
• →Establish Git-based development, testing, deployment, and CI/CD processes.
• →Maintain strong data lineage, governance, auditability, and regulatory compliance.

• 10+ years of experience in data architecture, enterprise data warehousing, dimensional modeling, or business intelligence.
• Strong experience in the banking and financial services (BFS) domain.
• 2+ years of hands-on experience with AtScale and SML.
• Strong experience designing and implementing AtScale Semantic Layer solutions.
• Strong hands-on experience with SML (Semantic Modeling Language).
• 2+ years of Snowflake architecture and implementation experience.
• Strong knowledge of Snowflake data architecture, Snowflake SQL, data modeling, performance optimization, and security.
• Strong understanding of dimensional/Kimball modeling and enterprise semantic modeling.
• Advanced SQL development and query optimization skills.
• Experience designing enterprise metrics, KPIs, measures, dimensions, and hierarchies.
• Experience with DAX and/or MDX.
• Experience integrating semantic models with Power BI, Tableau, Excel, or similar enterprise BI platforms.
• Strong understanding of banking data models and financial business processes.
• Experience working with financial, management, risk, or regulatory reporting data.
• Knowledge of Snowflake RBAC, Row Access Policies, masking policies, and Column-Level Security.
• Experience with Git, CI/CD, and automated deployment practices.
• Strong understanding of data governance, lineage, metadata, auditability, and regulatory compliance.