Sr. Snowflake Data Engineer

job summary: We are looking for two Senior Snowflake Data Engineers for a remote contract opportunity.

The ideal candidate along with the requirements will meet the following key skills:

Snowflake

• SQL

• Data transformation design

• Curated data layer design

• Semantic-supporting structure implementation

• Technical design support

• Source-to-target mapping interpretation

• Performance and scalability considerations

• Client implementation support

location: Telecommute job type: Contract salary: $60 - 75 per hour work hours: 8am to 5pm education: Bachelors

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

qualifications: 5+ years of experience in data engineering, with strong hands-on expertise in Snowflake

• Strong experience designing and implementing Snowflake tables, views, materialized views,

SQL transformations, and curated analytical datasets

• Experience supporting data model implementation, source-to-target mappings,

derivations, and transformation logic

• Strong SQL development skills and understanding of performance, scalability, and

maintainability considerations in Snowflake

• Experience partnering with architects and analysts to convert business and design

requirements into technical implementation patterns

• Experience reviewing technical designs and supporting implementation teams through

clarifications, issue resolution, and design alignment

• Ability to explain technical implementation considerations clearly to both architects and

client engineering teams

Preferred Experience

• Experience in client-led implementation or advisory-based delivery models

• Experience supporting canonical and semantic model implementation in Snowflake

• Experience in payments, financial services, or transaction-data environments

• Familiarity with KPI-oriented data structures, curated layers, and reporting-ready datasets

• Experience contributing to implementation design documentation and technical handoff

materials

• Experience supporting testing, reconciliation, and rollout readiness from a technical

advisory perspective

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.

Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).

This posting is open for thirty (30) days.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance.

Qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.

We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

,

• 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

5+ years of experience in data engineering, with strong hands-on expertise in Snowflake - Strong experience designing and implementing Snowflake tables, views, materialized views, SQL transformations, and curated analytical datasets - Experience supporting data model implementation, source-to-target mappings, derivations, and transformation logic - Strong SQL development skills and understanding of performance, scalability, and maintainability considerations in Snowflake - Experience partnering with architects and analysts to convert business and design requirements into technical implementation patterns - Experience reviewing technical designs and supporting implementation teams through clarifications, issue resolution, and design alignment - Ability to explain technical implementation considerations clearly to both architects and client engineering teams Preferred Experience - Experience in client-led implementation or advisory-based delivery models - Experience supporting canonical and semantic model implementation in Snowflake - Experience in payments, financial services, or transaction-data environments - Familiarity with KPI-oriented data structures, curated layers, and reporting-ready datasets - Experience contributing to implementation design documentation and technical handoff materials - Experience supporting testing, reconciliation, and rollout readiness from a technical advisory perspective