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.
We seek team members with the grit necessary to forge paths where none previously existed, to get back up when circumstances knock them down, to adapt to the changing needs of the client even when it is uncomfortable, and to deliver on our commitments. Candidates must respect and value people, recognize that over-communication is barely good enough, thrive on solving complex problems, have a passion for building teams, and know that delivering what a client actually values is more important than their own predispositions. They understand value proposition, love delivering value, and take pride in learning the expansive and ever-changing business of clients. Candidates are self-motivated and relentlessly working to become more today than they were yesterday.
What You Will Do
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 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
Qualifications
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
Additional Information
How We Put You First
Trility’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 hours
• Sponsored and supported learning opportunities
Job Requirements
• Must reside within the United States
• Must be authorized to work in the United States without sponsorship now or in the future
Diese Cookies sind für das Funktionieren der Website erforderlich und können in unseren Systemen nicht abgeschaltet werden. Sie können Ihren Browser so einstellen, dass er diese Cookies blockiert, aber dann könnten einige Teile der Website nicht funktionieren.
Sicherheit
Benutzererfahrung
Zielgruppenorientierte Cookies
Diese Cookies werden über unsere Website von unseren Werbepartnern gesetzt. Sie können von diesen Unternehmen verwendet werden, um ein Profil Ihrer Interessen zu erstellen und Ihnen an anderer Stelle relevante Werbung zu zeigen.
Google Analytics
Google Ads
Wir benutzen Cookies
🍪
Unsere Website verwendet Cookies und ähnliche Technologien, um Inhalte zu personalisieren, das Nutzererlebnis zu optimieren und Werbung zu indvidualisieren und auszuwerten. Indem Sie auf Okay klicken oder eine Option in den Cookie-Einstellungen aktivieren, stimmen Sie dem zu.
Die besten Remote-Jobs per E-Mail
Schliess dich über 5'000+ Personen an, die wöchentlich Benachrichtigungen über Remote-Jobs erhalten!