Semantic Modeling Architect - Atscale

Tiger Analytics
Dallas, TX, United States
10 days ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
2 years minimum
Working hours
Regular working hours

Tech stack

Microsoft Excel Application Programming Interfaces (APIs) Artificial Intelligence Business Analytics Applications Business Logic Audit Trail Cloud Computing Continuous Integration Data Architecture Data Governance Dimensional Modeling Metadata
+14 more
Performance Tuning Query Optimization Role-Based Access Control Power BI SQL Databases Tableau (Software) Cloud Platform System Snowflake Git Data Lineage Deployment Automation Star Schema Tools for Reporting Semantic Modeling

Job description

  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.

Requirements

Artificial Intelligence (AI), Financial Services, Business Intelligence, Cloud Computing, Banking Services, Enterprise Architecture, Architectural Services, Metrics, Snowflake Schema, Performance Metrics, 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., * 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.

About the company

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…