Snowflake Data Consultant

Snowflake Data Consultant At Trility Consulting, we've built a strong, remote-work culture where people thrive, grow, and support each other – earning us Great Place to Work Certification. Headquartered in Central Iowa, we embrace flexible schedules and collaboration across geographically distributed teams serving clients from all corners of the United States and globally.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.Key Responsibilities Analyze, interpret, and reverse-engineer existing Oracle Data Integrator (ODI) workflows and data transformation logicDocument and understand current data flows, dependencies, and legacy data structuresDesign Snowflake-optimized data models and ELT patterns that improve performance and scalabilityWrite performance-aware SQL and implement ELT transformations within SnowflakeRestructure inefficient or "stair-step" legacy models into normalized, maintainable, and scalable architecturesCleanse legacy artifacts, including redundant columns, null-handling inconsistencies, and outdated dependenciesDesign conformed and curated data objects to support analytics and reporting needsBuild modular, testable transformation pipelines using DBT or approved transformation toolsManage Snowflake development environments, including roles, access control, and governance for development workEstablish data validation and reconciliation patterns to compare Oracle vs. Snowflake resultsImplement data quality checks to ensure accuracy and consistency during migrationCollaborate closely with QA and review teams to validate transformation logic and performance outcomesQualifications 5+ years of experience in data engineering or data consulting rolesStrong hands-on expertise with Oracle Data Integrator (ODI), including reading and interpreting legacy transformation logicDeep experience building data pipelines and transformation logic in SnowflakeStrong SQL skills with a focus on performance optimizationExperience with DBT (Data Build Tool) or similar modern data transformation toolingStrong understanding of data modeling, normalization, and warehouse design patternsExperience validating data migrations between legacy and modern platformsAbility to work independently in complex migration environments while collaborating with cross-functional QA and review teamsExcellent written and verbal communication skillsTrility's culture is built upon the journey, character, and work ethic of our team members. We are a team of honorable and professional lifelong learners who work together to solve problems proactively.Work remotely anywhere in the United States with flexible work hoursSponsored and supported learning opportunitiesJob RequirementsMust reside within the United StatesMust be authorized to work in the United States without sponsorship now or in the futureMust be able to pass a background check