Snowflake Data Consultant

Trility Consulting

11d • Remote

About The Position

Trility Consulting is seeking a Snowflake Data Consultant who is a powerhouse on the keyboard and thrives in complex data migration environments. In this role, you will lead the technical transformation of legacy Oracle BI and ODI logic into modern, performant Snowflake data models.

You’ll reverse-engineer existing data flows, untangle legacy structures, and redesign them using scalable Snowflake-optimized patterns. This is a hands-on role focused on thoughtful modernization — not just lift-and-shift — ensuring the new Snowflake environment is clean, performant, and built for long-term growth.

This is a remote 1099 position.

Requirements

• 5+ years of experience in data engineering or data consulting roles
• Strong hands-on expertise with Oracle Data Integrator (ODI), including reading and interpreting legacy transformation logic
• Deep experience building data pipelines and transformation logic in Snowflake
• Strong SQL skills with a focus on performance optimization
• Experience with DBT (Data Build Tool) or similar modern data transformation tooling
• Strong understanding of data modeling, normalization, and warehouse design patterns
• Experience validating data migrations between legacy and modern platforms
• Ability to work independently in complex migration environments while collaborating with cross-functional QA and review teams
• Excellent written and verbal communication skills
• Must reside within the United States
• Must be authorized to work in the United States without sponsorship now or in the future
• Must be able to pass a background check

Responsibilities

• Analyze, interpret, and reverse-engineer existing Oracle Data Integrator (ODI) workflows and data transformation logic
• Document and understand current data flows, dependencies, and legacy data structures
• Design Snowflake-optimized data models and ELT patterns that improve performance and scalability
• Write performance-aware SQL and implement ELT transformations within Snowflake
• Restructure inefficient or “stair-step” legacy models into normalized, maintainable, and scalable architectures
• Cleanse legacy artifacts, including redundant columns, null-handling inconsistencies, and outdated dependencies
• Design conformed and curated data objects to support analytics and reporting needs
• Build modular, testable transformation pipelines using DBT or approved transformation tools
• Manage Snowflake development environments, including roles, access control, and governance for development work
• Establish data validation and reconciliation patterns to compare Oracle vs. Snowflake resultsImplement data quality checks to ensure accuracy and consistency during migration
• Collaborate closely with QA and review teams to validate transformation logic and performance outcomes

Benefits

• Work remotely anywhere in the United States with flexible work hours
• Sponsored and supported learning opportunities

What This Job Offers

• Career Level: Mid Level
• Education Level: No Education Listed