Sigma Semantic Modeler

About the role

As a Sigma Semantic Modeler, you will make an impact by architecting and governing enterprise-grade semantic data models on Snowflake, enabling business stakeholders to access trusted, AI-enriched analytics at scale. You will be a valued member of our Data & Analytics team and work collaboratively with data engineers, business analysts, and cross-functional stakeholders.

Responsibilities

• Semantic Modeling & Governance
• Arcitect data models: Design governed Sigma Data Models on top of Snowflake, translating raw database schemas into an intuitive, business-friendly semantic layer.
• Centralize logic & security: Develop reusable core metrics and enforce inherited row-level security within the semantic layer, ensuring a single source of truth and strict data governance.
• AI Integration
• Deploy AI capabilities: Leverage Sigma Assistant and Snowflake Cortex to enable secure, natural-language querying (NLQ) for business stakeholders.
• Enrich data natively: Implement inline AI functions directly within workbooks to classify, summarize, and extract insights from unstructured text at warehouse scale.
• Workflow Design & Operational Apps
• Build interactive workflows: Transform static dashboards into dynamic operational applications using Sigma UI components for cross-functional tasks like forecasting and budget approvals.
• Enable scenario modeling: Design robust workbooks leveraging dynamic parameters and Input Tables to support complex, human-in-the-loop “what-if” analysis.
• Snowflake Writeback & Architecture
• Implement secure writeback: Configure Sigma Input Tables to push user inputs, manual adjustments, and workflow decisions directly back to dedicated Snowflake schemas.
• Maintain immutable audit trails for all writeback activity and balance live-query performance with strategic Snowflake materializations.

Requirements

• Strong expertise in Snowflake combined with Sigma or similar semantic BI tools
• Demonstrated experience in data modeling, governance frameworks, and enterprise BI architecture
• Familiarity with AI/ML integrations including Snowflake Cortex, natural-language querying, and unstructured data processing
• Ability to design business-facing analytics applications and workflow solutions
• Strong understanding of data security, auditability, and enterprise-scale performance optimization

Qualifications

• Experience building end-to-end semantic layers in a regulated or enterprise-scale environment
• Hands-on experience with Snowflake Cortex AI functions and natural-language querying solutions
• Prior work designing operational applications with writeback architecture and human-in-the-loop workflows

Benefits

• Medical/Dental/Vision/Life Insurance
• Paid holidays plus Paid Time Off
• 401(k) plan and contributions
• Long-term/Short-term Disability
• Paid Parental Leave
• Employee Stock Purchase Plan

Pay

The annual salary for this position is between $90,000- $145,000 USD depending on experience and other qualifications of the successful candidate.

Schedule

This is an onsite position requiring 5 days a week in a Cognizant office in Jersey City, NJ. The working arrangements for this role are accurate as of the date of posting. This may change based on the project you’re engaged in, as well as business and client requirements.