AtScale Semantic Modeling Architect

Position Overview

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 building and governing enterprise semantic models on AtScale and Snowflake, enabling business intelligence across banking functions.

The ideal candidate should have strong experience in AtScale, Snowflake, semantic modeling, banking domain, and enterprise BI platforms.

Key Responsibilities

·         Design and develop enterprise semantic models using AtScale and SML.

·         Build semantic models on top of Snowflake Delta Lake and Medallion Architecture.

·         Experience in creating standardized metrics, preferably BFS domain

·         Develop reusable dimensions, hierarchies, measures, and business definitions.

·         Optimize AtScale aggregations and Snowflake SQL workloads for high-performance analytics.

·         Implement data security using Unity Catalog, Row-Level Security (RLS), and Column-Level Security (CLS).

·         Enable semantic models for Power BI, Tableau, Excel, and other enterprise analytics platforms.

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

Required Qualifications

·         10+ years of experience in data architecture, data warehousing, or dimensional modeling.

·         Strong experience in the banking or financial services industry.

·         2+ years of hands-on AtScale and SML experience.

·         2+ years of Snowflake architecture experience.

·         Strong knowledge of:

o   AtScale Semantic Layer

o   SML

o   Dimensional/Kimball modeling

·         Working knowledge in

o   Snowflake

o   Delta Lake

o   Unity Catalog

o   Snowflake SQL

·         Strong SQL skills.

·         Experience with DAX/MDX.

·         Understanding of banking data models .

·         Experience with financial and regulatory reporting data.

Preferred Qualifications

·         Experience leading semantic-layer modernization programs for large financial institutions.

·         Experience with Power BI, Tableau, and Excel integration.

·         Experience in Snowflake architecture and development

·         Experience implementing enterprise data governance and CI/CD for semantic models.

Ideal Candidate

The ideal candidate combines strong banking domain knowledge with hands-on AtScale and Snowflake architecture experience and can translate complex banking data into simple, governed, reusable business metrics for enterprise users.

Experience Level: 10+ Years
Role: Senior Architect / Technical Lead
Domain: Banking & Financial Services
Core Technologies: AtScale, SML, Snowflake, Delta Lake, Unity Catalog, SQL, Power BI, Tableau