Sr. Snowflake Data Engineer

RIT Solutions, Inc. is seeking a Senior Snowflake Data Engineer responsible for implementing scalable data transformation logic and production-ready Snowflake objects. This role involves collaborating with architects and analysts to translate designs into working data assets and providing technical guidance on Snowflake-based data design and implementation.

Responsibilities:

• Support the Data Architect / Solution Design Lead in translating target-state architecture into implementation-ready Snowflake design guidance
• Provide input into the design of curated data structures, semantic-supporting objects, transformation patterns, and physical implementation considerations
• Assist in defining how approved mappings, derivations, and business rules should be implemented in Snowflake
• Help identify the required technical objects for implementation, including tables, views, materialized views, reference structures, and related artifacts as applicable
• Advise on Snowflake development patterns, object design, SQL implementation approaches, and performance considerations
• Partner with the Data Architect to support definition of implementation sequencing, object dependencies, and technical design checkpoints
• Participate in design reviews and working sessions to ensure the solution is technically practical and implementable
• Support the preparation of implementation-ready technical specifications for client development teams
• Provide technical clarification to the client implementation team during build, testing, and validation phases
• Review selected client-built artifacts at agreed checkpoints to assess alignment with approved design and intended Snowflake implementation patterns
• Assist with issue triage by helping determine whether questions or defects are related to design interpretation, Snowflake implementation approach, or build quality
• Contribute to documentation of transformation logic, technical assumptions, implementation considerations, and design decisions
• Support walkthroughs and knowledge transfer sessions for the client technical team

Requirements:

• Experience with Snowflake data design and implementation
• Strong understanding of data transformation logic and curated datasets
• Ability to translate approved designs into working data assets
• Experience providing technical guidance on Snowflake-based data design
• Knowledge of transformation patterns and curated data structures
• Experience in defining mappings, derivations, and business rules in Snowflake
• Ability to identify required technical objects for implementation
• Experience advising on Snowflake development patterns and SQL implementation
• Ability to support implementation sequencing and object dependencies
• Experience participating in design reviews and working sessions
• Ability to prepare implementation-ready technical specifications
• Experience providing technical clarification during build, testing, and validation phases
• Ability to review client-built artifacts for alignment with approved design
• Experience assisting with issue triage related to design interpretation or build quality
• Ability to document transformation logic and design decisions
• Experience supporting knowledge transfer sessions for technical teams