Snowflake Data Engineer(Sigma)

Job Purpose (both Onsite / Offshore)

We are seeking an experienced Senior Data & Analytics Engineer with 8+ years of total IT experience, specializing heavily in Sigma Computing (3+ years required) alongside strong working knowledge of Snowflake Data Cloud. In this role, you will bridge the gap between complex enterprise data warehouses and intuitive business reporting. You will lead the design, development, and optimization of live interactive workbooks, input tables, and custom analytics workflows in Sigma, directly powered by underlying Snowflake architecture.

Job Description / Duties and Responsibilities

• Build, optimize, and maintain complex, highly interactive Sigma workbooks, reports, and dashboards using Sigma's spreadsheet-like interface.

• Implement and manage semantic layers, control calculations, and build user-friendly data models directly over Snowflake tables and views.

• Design and deploy operational workflows using Sigma Input Tables to enable safe data write backs directly into Snowflake.

• Leverage advanced Sigma capabilities include parameterization, dynamic filtering, paginated reporting, and integration with Snowflake Cortex AI / semantic views.

• Establish Sigma development standards, governance policies, and train non-technical stakeholders on self-service analytics

• Write, optimize, and tune complex SQL queries natively executed via push-down compute inside Snowflake.

• Collaborate with data platform teams to optimize Snowflake schemas, views, and materializations specifically tailored for high-performance Sigma reporting.

• Ensure seamless security integration by aligning Sigma access with Snowflake Role-Based Access Control (RBAC), row-level security (RLS), and OAuth definitions

Job Specification / Skills and Competencies

• 8+ years of experience in data engineering, business intelligence, or enterprise data warehousing. • Minimum 3+ years of hands-on experience building, architecting, and optimizing analytics solutions in Sigma Computing.

• 3+ years of working experience with Snowflake (writing advanced SQL, understanding compute/warehouse sizing, performance tuning, RBAC, and object structure).

• Deep understanding of relational database concepts, star schema/snowflake schema design, and analytical data modelling.

• Excellent verbal and written English communication skills for collaborating across onshore and offshore teams, gathering business requirements, and translating them into technical solutions

• To adhere to the Information Security Management policies and procedures