Snowflake Data Engineer with Cortex AI

Role: Snowflake Data Engineer with Cortex AI

Location: Nashville, TN (100% Onsite, 5 days/week - mandatory)

Duration: 6 Months Contract

Need Only Local candidates in Tennessee

Responsibilities

• Design, develop, enhance, and maintain Snowflake data solutions, including databases, schemas, warehouses, and related objects assigned by the client.
• Build and support workloads that use Snowflake Cortex AI, and apply those capabilities to approved business use cases.
• Analyze approved functional and technical requirements and translate them into maintainable, well-engineered Snowflake solutions.
• Develop data pipelines, transformations, and integrations required to land, model, and serve data in Snowflake.
• Write, review, and optimize SQL, and support performance, cost, and warehouse tuning for assigned workloads.
• Produce source code, configuration changes, unit tests, and supporting technical documentation in client-approved repositories and formats.
• Participate in technical design reviews, code reviews, backlog refinement, sprint planning, demonstrations, and delivery-status reviews.
• Perform unit and integration testing, support system and user-acceptance testing, and correct defects attributable to delivered work.
• Troubleshoot data, pipeline, performance, access, and deployment issues associated with assigned deliverables.
• Identify and communicate technical risks, dependencies, constraints, and blockers early enough to support timely resolution.
• Provide knowledge transfer to designated client personnel and complete end-of-engagement transition documentation.

Technical Competencies

• Snowflake platform engineering, including databases, schemas, virtual warehouses, roles, and secure data sharing patterns as applicable.
• Hands-on Snowflake Cortex AI experience. This is a required skill, not a nice-to-have.
• Strong SQL for data modeling, transformation, and query tuning in Snowflake.
• Data pipeline and integration experience that loads, transforms, and serves data in Snowflake.
• Data quality, testing, and documentation practices suitable for an enterprise delivery environment.
• Troubleshooting of data, performance, access, and deployment issues in a production support capacity.
• Working knowledge of Agile delivery ceremonies, including sprint planning, backlog refinement, demos, and status reviews.

Behavioural Competencies

• Able to work independently in a client environment with limited day-to-day direction.
• Partners effectively with technical teams and business stakeholders.
• Communicates clearly in writing and in conversation, and can produce client-ready technical notes and status updates.
• Surfaces risks, dependencies, and blockers early.
• Owns assigned work through testing, deployment support, and stabilization.
• Comfortable transferring knowledge to client personnel, including a formal end-of-engagement transition.

Required Qualifications

• 6 to 8 years of relevant professional experience, with demonstrated Snowflake engineering ownership.
• Hands-on experience with Snowflake Cortex AI.
• Strong SQL and data-modeling skills in Snowflake.
• Proven experience with testing, code or design reviews, and Agile delivery practices.
• Experience troubleshooting production data and platform issues.
• Bachelor's degree in Computer Science, Engineering, or a related field, or equivalent practical experience.
• Must be authorized to work in the United States for the duration of the engagement.
• Must be able to work 100 percent onsite, five days per week, in Nashville, Tennessee, for the full engagement. Location is non-negotiable.

Key Requirements

• Strong Snowflake engineering experience
• Hands-on experience with Snowflake Cortex AI (required)
• Strong SQL and data modeling skills
• Experience building data pipelines and integrations in Snowflake
• Production support and troubleshooting experience
• Agile delivery experience
• Must be authorized to work in the U.S.
• Must currently be local to Nashville, TN or able to work onsite in Nashville for the full duration without relocation assistance