Senior Semantic Modeling Architect - AtScale & Databricks

Tiger Analytics; Texas; Remote; USD 150,000 - 190,000; Full time

Job summary

Tiger Analytics seeks a seasoned AtScale Semantic Modeling Architect to lead enterprise semantic modeling initiatives across AtScale, Databricks, and BI platforms. 10+ years in data architecture and banking domain guide your work.

You design models, ensure governance and security with Unity Catalog, and enable enterprise analytics across Power BI, Tableau, and Excel. You will implement CI/CD, maintain lineage and regulatory compliance, and work within a fast-growing, entrepreneurial environment

Qualifications

• 10+ years in data architecture, data warehousing, or dimensional modeling.
• Strong banking/financial services industry experience.
• 2+ years of hands-on AtScale and SML experience.
• 2+ years of Databricks architecture experience.
• Strong knowledge of AtScale Semantic Layer, SML, Dimensional/Kimball modeling.
• Experience with Databricks SQL, Delta Lake and security concepts.

Responsibilities

• Design and develop enterprise semantic models using AtScale and SML.
• Build semantic models on top of Databricks Delta Lake and Medallion Architecture.
• Create standardized metrics, preferably BFS domain.
• Develop reusable dimensions, hierarchies, measures, and business definitions.
• Optimize AtScale aggregations and Databricks SQL workloads for high-performance analytics.
• Implement data security using Unity Catalog, RLS, and 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 data lineage, governance, auditability, and regulatory compliance.

Skills

Data architecture

Banking domain

SQL

Governance

Leadership

Tools

AtScale

Databricks

SML

Delta Lake

Unity Catalog

Job description

Tiger Analytics is pioneering what AI and analytics can do to solve some of the toughest problems faced by organizations globally. We develop bespoke solutions powered by data and technology for several Fortune 100 companies. We have offices in multiple cities across the US, UK, India, and Singapore, and a substantial remote global workforce.

If you are passionate about leading large-scale cloud and data modernization initiatives that transform enterprise platforms, we would love to hear from you. 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.

Responsibilities:

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

Significant career development opportunities exist as the company grows. The position offers a unique opportunity to be part of a small, fast-growing, challenging, and entrepreneurial environment, with a high degree of individual responsibility.

Tiger Analytics provides equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity/expression, pregnancy,
national origin, ancestry, marital status, protected veteran status, disability
status, or any other basis as protected by federal, state, or local law.