Semantic Modeling Architect - Atscale

Tiger Analytics Inc.•Jersey City, NJ

About The Position

Tiger Analytics is seeking an AtScale Semantic Modeling Architect with 10+ years of experience in enterprise data architecture and financial services. The role focuses on designing, developing, and governing enterprise semantic models using AtScale and SML on Snowflake. The successful candidate will bring hands-on experience with the AtScale Semantic Layer, SML, Snowflake architecture, semantic modeling, enterprise BI, and banking or financial data. The architect will translate complex business needs into standardized enterprise metrics and semantic definitions, build scalable models for multiple business domains, optimize analytical workloads, and provide governed semantic data for BI, analytics, and AI/ML or GenAI use cases. The role also supports secure, auditable, and compliant data practices and establishes Git-based development, testing, deployment, and CI/CD processes.

Requirements

  • 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 Semantic Modeling Language (SML).
  • 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.

Responsibilities

  • 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 for scalable enterprise analytics.
  • Translate complex business requirements into standardized enterprise metrics, KPIs, dimensions, and semantic definitions across business and reporting functions.
  • Apply dimensional and Kimball modeling principles to create scalable, reusable semantic models for multiple business domains.
  • Design and optimize Snowflake data models, SQL workloads, and AtScale aggregates for 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 capabilities, including Row Access Policies, masking policies, role-based access control (RBAC), and Column-Level Security (CLS).
  • Integrate and enable governed semantic models for 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 data lineage, governance, auditability, and regulatory compliance.

Benefits

  • Medical insurance
  • Dental insurance
  • Vision insurance
  • Retirement accounts
  • Long- and short-term disability insurance
  • Life insurance
  • HSA/FSA accounts (USA)
  • Discretionary time off
  • Continuous learning and AI upskilling opportunities
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service