Semantic Modeling Architect

This is a fully remote position, open to applicants in New Jersey.

📋 Description

• Create and develop enterprise semantic models utilizing AtScale and SML, encompassing reusable dimensions, hierarchies, measures, metrics, and business definitions.

• Design and implement AtScale semantic models on Snowflake to support scalable enterprise analytics.

• Convert intricate business requirements into standardized enterprise metrics, KPIs, dimensions, and semantic definitions.

• Employ dimensional/Kimball modeling principles across various business domains.

• Design and enhance Snowflake data models, SQL workloads, and AtScale aggregates to ensure high-performance analytical queries and BI workloads.

• Develop and sustain SML-based semantic definitions, which include measures, dimensions, hierarchies, relationships, calculations, and business logic.

• Enforce enterprise data security using Snowflake Row Access Policies, masking policies, RBAC, and Column-Level Security.

• Integrate governed semantic models with Power BI, Tableau, Excel, and other reporting platforms.

• Facilitate AI/ML and GenAI use cases through governed semantic metrics and APIs.

• Establish Git-based processes for development, testing, deployment, and CI/CD.

• Ensure data lineage, governance, auditability, and compliance with regulations.

⛳️ Requirements

• Over 10 years of experience in data architecture, enterprise data warehousing, dimensional modeling, or business intelligence.

• Extensive experience in the banking and financial services (BFS) sector.

• At least 2 years of direct experience with AtScale and SML.

• Proven experience in designing and implementing AtScale Semantic Layer solutions.

• Significant hands-on expertise with SML (Semantic Modeling Language).

• Minimum of 2 years of experience in Snowflake architecture and implementation.

• In-depth knowledge of Snowflake data architecture, Snowflake SQL, data modeling, performance optimization, and security measures.

• Solid understanding of dimensional/Kimball modeling and enterprise semantic modeling.

• Advanced skills in SQL development and query optimization.

• Experience in designing enterprise metrics, KPIs, measures, dimensions, and hierarchies.

• Familiarity with DAX and/or MDX.

• Experience in integrating semantic models with Power BI, Tableau, Excel, or similar enterprise BI tools.

• Strong understanding of banking data models and financial business processes.

• Experience with financial, management, risk, or regulatory reporting data.

• Knowledge of Snowflake RBAC, Row Access Policies, masking policies, and Column-Level Security.

• Familiarity with Git, CI/CD, and automated deployment methods.

• Strong grasp of data governance, lineage, metadata, auditability, and regulatory compliance.

🏝️ Benefits

• Medical, Dental, Vision coverage.

• Retirement Account options.

• Long and Short-Term Disability benefits.

• Life Insurance coverage.

• HSA/FSA Accounts (USA).

• Discretionary time-off policy.

• Lead strategic initiatives promoting enterprise-wide AI adoption, cloud-native data modernization, and measurable business outcomes.

• Collaborate with outstanding AI, data, engineering, and consulting professionals across various regions.

• Engage in continuous learning and gain hands-on experience with emerging technologies.

• Opportunities to develop expertise in Generative AI, agentic AI, and next-generation data platforms.

• Career advancement prospects within a team that prioritizes the development of future-ready skills and fosters innovation.