Semantic Modeling Architect - Atscale

Overview

Design, develop and govern enterprise semantic models using AtScale and SML on Snowflake for banking and financial services analytics.

What you'll do

• 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, 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 for 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 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.

What you'll need

• 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.

Details

• Location: Jersey City, New Jersey, United States.