ETL SQL Data Engineer (Snowflake)-Senior

IKCON TECHNOLOGIES INC delivers exceptional IT services and solutions that provide clients with definite edge over competitors and promoting highest standards of quality. We are currently looking for a ETL SQL Data Engineer (Snowflake)-Senior with one of our clients in Jersey City, NJ. If you are actively looking for opportunities, please send us your updated resume with your contact details.

"U.S. Citizens and those authorized to work in the U.S. are encouraged to apply."

JOB TITLE	ETL SQL Data Engineer (Snowflake)-Senior
CITY	Jersey City
STATE	NJ
TAX TERMS	C2C, W2
EXPERIENCE	12+
INTERVIEW MODE	Teams Video Call/Telephonic

JOB DESCRIPTION

JOB SUMMARY

Sigma Semantic Modeling

JOB DESCRIPTION

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.