What are the responsibilities and job description for the Senior Sigma Engineer position at Avtech Solutions?
Title: Senior Sigma Engineer
Duration: Long term contract
Location: Jersey City, NJ Hybrid
Position Summary
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.
Education
- Bachelor's or Master's in Information technology, Computer Science or related field.
Work Environment
This job operates in a professional office environment. This role routinely uses standard office equipment, including but not limited to, computers, phones, and photocopiers.
Physical Demands
This position requires the frequent and repetitive use of a computer, keyboard, and mouse. Hand and finger dexterity is required.
Other Duties
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.