Sigma Semantic Modeler

Cognizant Technology Solutions Corporation
Jefferson City, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Compensation
$ 145K

Job location

Jefferson City, United States of America

Tech stack

Query Performance
Artificial Intelligence
Application Integration Architecture
ARM
Audit Trail
Data Governance
Data Security
Performance Tuning
Systems Integration
Unstructured Data
Workflow Management Systems
Snowflake
Material Design
Data Analytics
Star Schema

Job description

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.

In this role, you will:

Semantic Modeling & Governance

  • Architect 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.

  • Optimize & Audit: Maintain immutable audit trails for all writeback activity and balance live-query performance with strategic Snowflake materializations.

Work model

At Cognizant, we strive to provide flexibility wherever possible, and we are here to support a healthy work-life balance through our various wellbeing programs. Based on this role's business requirements, 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. Rest assured; we will always be clear about role expectations.

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

These will help you stand out

  • 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 & conditions

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

This position is also eligible for Cognizant's discretionary annual incentive program, based on performance and subject to the terms of Cognizant's applicable plans.

Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:

  • Medical/Dental/Vision/Life Insurance

  • Paid holidays plus Paid Time Off

  • 401(k) plan and contributions

Apply for this position